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

Line 212: IF (l_optv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

208: p_optv_rec IN optv_rec_type
209: ) RETURN optv_rec_type IS
210: l_optv_rec optv_rec_type := p_optv_rec;
211: BEGIN
212: IF (l_optv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
213: l_optv_rec.object_version_number := NULL;
214: END IF;
215: IF (l_optv_rec.name = OKC_API.G_MISS_CHAR) THEN
216: l_optv_rec.name := NULL;

Line 215: IF (l_optv_rec.name = OKC_API.G_MISS_CHAR) THEN

211: BEGIN
212: IF (l_optv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
213: l_optv_rec.object_version_number := NULL;
214: END IF;
215: IF (l_optv_rec.name = OKC_API.G_MISS_CHAR) THEN
216: l_optv_rec.name := NULL;
217: END IF;
218: IF (l_optv_rec.description = OKC_API.G_MISS_CHAR) THEN
219: l_optv_rec.description := NULL;

Line 218: IF (l_optv_rec.description = OKC_API.G_MISS_CHAR) THEN

214: END IF;
215: IF (l_optv_rec.name = OKC_API.G_MISS_CHAR) THEN
216: l_optv_rec.name := NULL;
217: END IF;
218: IF (l_optv_rec.description = OKC_API.G_MISS_CHAR) THEN
219: l_optv_rec.description := NULL;
220: END IF;
221: IF (l_optv_rec.from_date = OKC_API.G_MISS_DATE) THEN
222: l_optv_rec.from_date := NULL;

Line 221: IF (l_optv_rec.from_date = OKC_API.G_MISS_DATE) THEN

217: END IF;
218: IF (l_optv_rec.description = OKC_API.G_MISS_CHAR) THEN
219: l_optv_rec.description := NULL;
220: END IF;
221: IF (l_optv_rec.from_date = OKC_API.G_MISS_DATE) THEN
222: l_optv_rec.from_date := NULL;
223: END IF;
224: IF (l_optv_rec.TO_DATE = OKC_API.G_MISS_DATE) THEN
225: l_optv_rec.TO_DATE := NULL;

Line 224: IF (l_optv_rec.TO_DATE = OKC_API.G_MISS_DATE) THEN

220: END IF;
221: IF (l_optv_rec.from_date = OKC_API.G_MISS_DATE) THEN
222: l_optv_rec.from_date := NULL;
223: END IF;
224: IF (l_optv_rec.TO_DATE = OKC_API.G_MISS_DATE) THEN
225: l_optv_rec.TO_DATE := NULL;
226: END IF;
227: IF (l_optv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
228: l_optv_rec.attribute_category := NULL;

Line 227: IF (l_optv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN

223: END IF;
224: IF (l_optv_rec.TO_DATE = OKC_API.G_MISS_DATE) THEN
225: l_optv_rec.TO_DATE := NULL;
226: END IF;
227: IF (l_optv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
228: l_optv_rec.attribute_category := NULL;
229: END IF;
230: IF (l_optv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
231: l_optv_rec.attribute1 := NULL;

Line 230: IF (l_optv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN

226: END IF;
227: IF (l_optv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
228: l_optv_rec.attribute_category := NULL;
229: END IF;
230: IF (l_optv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
231: l_optv_rec.attribute1 := NULL;
232: END IF;
233: IF (l_optv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN
234: l_optv_rec.attribute2 := NULL;

Line 233: IF (l_optv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN

229: END IF;
230: IF (l_optv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
231: l_optv_rec.attribute1 := NULL;
232: END IF;
233: IF (l_optv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN
234: l_optv_rec.attribute2 := NULL;
235: END IF;
236: IF (l_optv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN
237: l_optv_rec.attribute3 := NULL;

Line 236: IF (l_optv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN

232: END IF;
233: IF (l_optv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN
234: l_optv_rec.attribute2 := NULL;
235: END IF;
236: IF (l_optv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN
237: l_optv_rec.attribute3 := NULL;
238: END IF;
239: IF (l_optv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
240: l_optv_rec.attribute4 := NULL;

Line 239: IF (l_optv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN

235: END IF;
236: IF (l_optv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN
237: l_optv_rec.attribute3 := NULL;
238: END IF;
239: IF (l_optv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
240: l_optv_rec.attribute4 := NULL;
241: END IF;
242: IF (l_optv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
243: l_optv_rec.attribute5 := NULL;

Line 242: IF (l_optv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN

238: END IF;
239: IF (l_optv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
240: l_optv_rec.attribute4 := NULL;
241: END IF;
242: IF (l_optv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
243: l_optv_rec.attribute5 := NULL;
244: END IF;
245: IF (l_optv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
246: l_optv_rec.attribute6 := NULL;

Line 245: IF (l_optv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN

241: END IF;
242: IF (l_optv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
243: l_optv_rec.attribute5 := NULL;
244: END IF;
245: IF (l_optv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
246: l_optv_rec.attribute6 := NULL;
247: END IF;
248: IF (l_optv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
249: l_optv_rec.attribute7 := NULL;

Line 248: IF (l_optv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN

244: END IF;
245: IF (l_optv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
246: l_optv_rec.attribute6 := NULL;
247: END IF;
248: IF (l_optv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
249: l_optv_rec.attribute7 := NULL;
250: END IF;
251: IF (l_optv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
252: l_optv_rec.attribute8 := NULL;

Line 251: IF (l_optv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN

247: END IF;
248: IF (l_optv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
249: l_optv_rec.attribute7 := NULL;
250: END IF;
251: IF (l_optv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
252: l_optv_rec.attribute8 := NULL;
253: END IF;
254: IF (l_optv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
255: l_optv_rec.attribute9 := NULL;

Line 254: IF (l_optv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN

250: END IF;
251: IF (l_optv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
252: l_optv_rec.attribute8 := NULL;
253: END IF;
254: IF (l_optv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
255: l_optv_rec.attribute9 := NULL;
256: END IF;
257: IF (l_optv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
258: l_optv_rec.attribute10 := NULL;

Line 257: IF (l_optv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN

253: END IF;
254: IF (l_optv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
255: l_optv_rec.attribute9 := NULL;
256: END IF;
257: IF (l_optv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
258: l_optv_rec.attribute10 := NULL;
259: END IF;
260: IF (l_optv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
261: l_optv_rec.attribute11 := NULL;

Line 260: IF (l_optv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN

256: END IF;
257: IF (l_optv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
258: l_optv_rec.attribute10 := NULL;
259: END IF;
260: IF (l_optv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
261: l_optv_rec.attribute11 := NULL;
262: END IF;
263: IF (l_optv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
264: l_optv_rec.attribute12 := NULL;

Line 263: IF (l_optv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN

259: END IF;
260: IF (l_optv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
261: l_optv_rec.attribute11 := NULL;
262: END IF;
263: IF (l_optv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
264: l_optv_rec.attribute12 := NULL;
265: END IF;
266: IF (l_optv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
267: l_optv_rec.attribute13 := NULL;

Line 266: IF (l_optv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN

262: END IF;
263: IF (l_optv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
264: l_optv_rec.attribute12 := NULL;
265: END IF;
266: IF (l_optv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
267: l_optv_rec.attribute13 := NULL;
268: END IF;
269: IF (l_optv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
270: l_optv_rec.attribute14 := NULL;

Line 269: IF (l_optv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN

265: END IF;
266: IF (l_optv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
267: l_optv_rec.attribute13 := NULL;
268: END IF;
269: IF (l_optv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
270: l_optv_rec.attribute14 := NULL;
271: END IF;
272: IF (l_optv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
273: l_optv_rec.attribute15 := NULL;

Line 272: IF (l_optv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN

268: END IF;
269: IF (l_optv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
270: l_optv_rec.attribute14 := NULL;
271: END IF;
272: IF (l_optv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
273: l_optv_rec.attribute15 := NULL;
274: END IF;
275: IF (l_optv_rec.created_by = OKC_API.G_MISS_NUM) THEN
276: l_optv_rec.created_by := NULL;

Line 275: IF (l_optv_rec.created_by = OKC_API.G_MISS_NUM) THEN

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

Line 278: IF (l_optv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

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

Line 281: IF (l_optv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

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

Line 284: IF (l_optv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

280: END IF;
281: IF (l_optv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
282: l_optv_rec.last_updated_by := NULL;
283: END IF;
284: IF (l_optv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
285: l_optv_rec.last_update_date := NULL;
286: END IF;
287: IF (l_optv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
288: l_optv_rec.last_update_login := NULL;

Line 287: IF (l_optv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

283: END IF;
284: IF (l_optv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
285: l_optv_rec.last_update_date := NULL;
286: END IF;
287: IF (l_optv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
288: l_optv_rec.last_update_login := NULL;
289: END IF;
290: RETURN(l_optv_rec);
291: END null_out_defaults;

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

311: PROCEDURE Validate_Id (
312: p_optv_rec IN optv_rec_type,
313: x_return_status OUT NOCOPY VARCHAR2
314: ) IS
315: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
316: BEGIN
317: IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
318: p_optv_rec.id IS NULL
319: THEN

Line 317: IF p_optv_rec.id = OKC_API.G_MISS_NUM OR

313: x_return_status OUT NOCOPY VARCHAR2
314: ) IS
315: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
316: BEGIN
317: IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
318: p_optv_rec.id IS NULL
319: THEN
320: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
321: x_return_status := OKC_API.G_RET_STS_ERROR;

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

316: BEGIN
317: IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
318: p_optv_rec.id IS NULL
319: THEN
320: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
321: x_return_status := OKC_API.G_RET_STS_ERROR;
322: END IF;
323: EXCEPTION
324: WHEN OTHERS THEN

Line 321: x_return_status := OKC_API.G_RET_STS_ERROR;

317: IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
318: p_optv_rec.id IS NULL
319: THEN
320: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
321: x_return_status := OKC_API.G_RET_STS_ERROR;
322: END IF;
323: EXCEPTION
324: WHEN OTHERS THEN
325: OKC_API.set_message(p_app_name =>G_APP_NAME,

Line 325: OKC_API.set_message(p_app_name =>G_APP_NAME,

321: x_return_status := OKC_API.G_RET_STS_ERROR;
322: END IF;
323: EXCEPTION
324: WHEN OTHERS THEN
325: OKC_API.set_message(p_app_name =>G_APP_NAME,
326: p_msg_name =>G_UNEXPECTED_ERROR,
327: p_token1 =>G_SQL_SQLCODE_TOKEN,
328: p_token1_value =>SQLCODE,
329: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 331: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

327: p_token1 =>G_SQL_SQLCODE_TOKEN,
328: p_token1_value =>SQLCODE,
329: p_token2 =>G_SQL_SQLERRM_TOKEN,
330: p_token2_value =>SQLERRM);
331: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
332:
333: END Validate_Id;
334: -----end of Validate_Id------------------------
335:

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

348: PROCEDURE Validate_Object_Version_Number (
349: p_optv_rec IN optv_rec_type,
350: x_return_status OUT NOCOPY VARCHAR2
351: ) IS
352: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
353: BEGIN
354: IF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
355: p_optv_rec.object_version_number IS NULL
356: THEN

Line 354: IF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR

350: x_return_status OUT NOCOPY VARCHAR2
351: ) IS
352: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
353: BEGIN
354: IF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
355: p_optv_rec.object_version_number IS NULL
356: THEN
357: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
358: x_return_status := OKC_API.G_RET_STS_ERROR;

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

353: BEGIN
354: IF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
355: p_optv_rec.object_version_number IS NULL
356: THEN
357: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
358: x_return_status := OKC_API.G_RET_STS_ERROR;
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN

Line 358: x_return_status := OKC_API.G_RET_STS_ERROR;

354: IF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
355: p_optv_rec.object_version_number IS NULL
356: THEN
357: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
358: x_return_status := OKC_API.G_RET_STS_ERROR;
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: OKC_API.set_message(p_app_name =>G_APP_NAME,

Line 362: OKC_API.set_message(p_app_name =>G_APP_NAME,

358: x_return_status := OKC_API.G_RET_STS_ERROR;
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: OKC_API.set_message(p_app_name =>G_APP_NAME,
363: p_msg_name =>G_UNEXPECTED_ERROR,
364: p_token1 =>G_SQL_SQLCODE_TOKEN,
365: p_token1_value =>SQLCODE,
366: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 368: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

364: p_token1 =>G_SQL_SQLCODE_TOKEN,
365: p_token1_value =>SQLCODE,
366: p_token2 =>G_SQL_SQLERRM_TOKEN,
367: p_token2_value =>SQLERRM);
368: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
369:
370: END Validate_Object_Version_Number;
371: ------end of Validate_Object_Version_Number-----------------------------------
372:

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

386: PROCEDURE Validate_Name(
387: p_optv_rec IN OUT NOCOPY optv_rec_type,
388: x_return_status OUT NOCOPY VARCHAR2
389: ) IS
390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
391: BEGIN
392: IF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
393: p_optv_rec.name IS NULL
394: THEN

Line 392: IF p_optv_rec.name = OKC_API.G_MISS_CHAR OR

388: x_return_status OUT NOCOPY VARCHAR2
389: ) IS
390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
391: BEGIN
392: IF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
393: p_optv_rec.name IS NULL
394: THEN
395: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
396: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 395: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

391: BEGIN
392: IF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
393: p_optv_rec.name IS NULL
394: THEN
395: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
396: x_return_status := OKC_API.G_RET_STS_ERROR;
397: END IF;
398: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
399: EXCEPTION

Line 396: x_return_status := OKC_API.G_RET_STS_ERROR;

392: IF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
393: p_optv_rec.name IS NULL
394: THEN
395: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
396: x_return_status := OKC_API.G_RET_STS_ERROR;
397: END IF;
398: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
399: EXCEPTION
400: WHEN OTHERS THEN

Line 401: OKC_API.set_message(p_app_name =>G_APP_NAME,

397: END IF;
398: p_optv_rec.name := Okl_Accounting_Util.okl_upper(p_optv_rec.name);
399: EXCEPTION
400: WHEN OTHERS THEN
401: OKC_API.set_message(p_app_name =>G_APP_NAME,
402: p_msg_name =>G_UNEXPECTED_ERROR,
403: p_token1 =>G_SQL_SQLCODE_TOKEN,
404: p_token1_value =>SQLCODE,
405: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 407: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

403: p_token1 =>G_SQL_SQLCODE_TOKEN,
404: p_token1_value =>SQLCODE,
405: p_token2 =>G_SQL_SQLERRM_TOKEN,
406: p_token2_value =>SQLERRM);
407: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
408:
409: END Validate_Name;
410: ------end of Validate_Name-----------------------------------
411:

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

424: PROCEDURE Validate_From_Date(
425: p_optv_rec IN optv_rec_type,
426: x_return_status OUT NOCOPY VARCHAR2
427: ) IS
428: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
429: BEGIN
430: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = OKC_API.G_MISS_DATE
431: THEN
432: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'from_date');

Line 430: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = OKC_API.G_MISS_DATE

426: x_return_status OUT NOCOPY VARCHAR2
427: ) IS
428: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
429: BEGIN
430: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = OKC_API.G_MISS_DATE
431: THEN
432: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'from_date');
433: x_return_status := OKC_API.G_RET_STS_ERROR;
434: END IF;

Line 432: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'from_date');

428: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
429: BEGIN
430: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = OKC_API.G_MISS_DATE
431: THEN
432: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'from_date');
433: x_return_status := OKC_API.G_RET_STS_ERROR;
434: END IF;
435: EXCEPTION
436: WHEN OTHERS THEN

Line 433: x_return_status := OKC_API.G_RET_STS_ERROR;

429: BEGIN
430: IF p_optv_rec.from_date IS NULL OR p_optv_rec.from_date = OKC_API.G_MISS_DATE
431: THEN
432: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'from_date');
433: x_return_status := OKC_API.G_RET_STS_ERROR;
434: END IF;
435: EXCEPTION
436: WHEN OTHERS THEN
437: OKC_API.set_message(p_app_name =>G_APP_NAME,

Line 437: OKC_API.set_message(p_app_name =>G_APP_NAME,

433: x_return_status := OKC_API.G_RET_STS_ERROR;
434: END IF;
435: EXCEPTION
436: WHEN OTHERS THEN
437: OKC_API.set_message(p_app_name =>G_APP_NAME,
438: p_msg_name =>G_UNEXPECTED_ERROR,
439: p_token1 =>G_SQL_SQLCODE_TOKEN,
440: p_token1_value =>SQLCODE,
441: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 443: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

439: p_token1 =>G_SQL_SQLCODE_TOKEN,
440: p_token1_value =>SQLCODE,
441: p_token2 =>G_SQL_SQLERRM_TOKEN,
442: p_token2_value =>SQLERRM);
443: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
444:
445: END Validate_From_Date;
446: ------end of Validate_From_Date-----------------------------------
447: ---------------------------------------------------------------------------

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

459:
460: PROCEDURE Validate_To_Date(p_optv_rec IN optv_rec_type,
461: x_return_status OUT NOCOPY VARCHAR2)IS
462:
463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
464:
465: BEGIN
466: -- initialize return status
467: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 467: x_return_status := OKC_API.G_RET_STS_SUCCESS;

463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
464:
465: BEGIN
466: -- initialize return status
467: x_return_status := OKC_API.G_RET_STS_SUCCESS;
468:
469: -- check for data before processing
470: IF (p_optv_rec.TO_DATE IS NOT NULL) AND
471: (p_optv_rec.TO_DATE < p_optv_rec.from_date) THEN

Line 472: OKC_API.SET_MESSAGE(p_app_name => 'OKL'

468:
469: -- check for data before processing
470: IF (p_optv_rec.TO_DATE IS NOT NULL) AND
471: (p_optv_rec.TO_DATE < p_optv_rec.from_date) THEN
472: OKC_API.SET_MESSAGE(p_app_name => 'OKL'
473: ,p_msg_name => g_to_date_error
474: ,p_token1 => g_col_name_token
475: ,p_token1_value => 'to_date');
476: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 476: x_return_status := OKC_API.G_RET_STS_ERROR;

472: OKC_API.SET_MESSAGE(p_app_name => 'OKL'
473: ,p_msg_name => g_to_date_error
474: ,p_token1 => g_col_name_token
475: ,p_token1_value => 'to_date');
476: x_return_status := OKC_API.G_RET_STS_ERROR;
477: RAISE G_EXCEPTION_HALT_VALIDATION;
478: END IF;
479:
480: EXCEPTION

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

484: NULL;
485:
486: WHEN OTHERS THEN
487: -- store SQL error message on message stack for caller
488: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
489: p_msg_name => g_unexpected_error,
490: p_token1 => g_sql_sqlcode_token,
491: p_token1_value => SQLCODE,
492: p_token2 => g_sql_sqlerrm_token,

Line 496: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

492: p_token2 => g_sql_sqlerrm_token,
493: p_token2_value => SQLERRM);
494:
495: -- notify caller of an UNEXPECTED error
496: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
497:
498: END Validate_To_Date;
499: ------end of Validate_To_Date-----------------------------------
500:

Line 533: OKC_API.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME','Okl_Options_V');

529: BEGIN
530: OPEN okl_options_unique (p_optv_rec.name);
531: FETCH okl_options_unique INTO l_unique_key;
532: IF okl_options_unique%FOUND THEN
533: OKC_API.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME','Okl_Options_V');
534: x_return_status := OKC_API.G_RET_STS_ERROR;
535: ELSE
536: x_return_status := OKC_API.G_RET_STS_SUCCESS;
537: END IF;

Line 534: x_return_status := OKC_API.G_RET_STS_ERROR;

530: OPEN okl_options_unique (p_optv_rec.name);
531: FETCH okl_options_unique INTO l_unique_key;
532: IF okl_options_unique%FOUND THEN
533: OKC_API.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME','Okl_Options_V');
534: x_return_status := OKC_API.G_RET_STS_ERROR;
535: ELSE
536: x_return_status := OKC_API.G_RET_STS_SUCCESS;
537: END IF;
538: CLOSE okl_options_unique;

Line 536: x_return_status := OKC_API.G_RET_STS_SUCCESS;

532: IF okl_options_unique%FOUND THEN
533: OKC_API.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME','Okl_Options_V');
534: x_return_status := OKC_API.G_RET_STS_ERROR;
535: ELSE
536: x_return_status := OKC_API.G_RET_STS_SUCCESS;
537: END IF;
538: CLOSE okl_options_unique;
539:
540: EXCEPTION

Line 542: OKC_API.set_message(p_app_name =>G_APP_NAME,

538: CLOSE okl_options_unique;
539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: OKC_API.set_message(p_app_name =>G_APP_NAME,
543: p_msg_name =>G_UNEXPECTED_ERROR,
544: p_token1 =>G_SQL_SQLCODE_TOKEN,
545: p_token1_value =>SQLCODE,
546: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 548: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

544: p_token1 =>G_SQL_SQLCODE_TOKEN,
545: p_token1_value =>SQLCODE,
546: p_token2 =>G_SQL_SQLERRM_TOKEN,
547: p_token2_value =>SQLERRM);
548: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
549:
550: END Validate_Unique_Key;
551:
552: -----END OF VALIDATE UNIQUE KEY-------------------------

Line 570: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

566:
567: FUNCTION Validate_Attributes(
568: p_optv_rec IN OUT NOCOPY optv_rec_type
569: ) RETURN VARCHAR IS
570: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
571: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
572:
573:
574: BEGIN

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

567: FUNCTION Validate_Attributes(
568: p_optv_rec IN OUT NOCOPY optv_rec_type
569: ) RETURN VARCHAR IS
570: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
571: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
572:
573:
574: BEGIN
575: ---- CHECK FOR ID-------------------------

Line 577: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

573:
574: BEGIN
575: ---- CHECK FOR ID-------------------------
576: Validate_Id (p_optv_rec, x_return_status);
577: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
578: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
579: -- need to leave
580: l_return_status := x_return_status;
581: RAISE G_EXCEPTION_HALT_VALIDATION;

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

574: BEGIN
575: ---- CHECK FOR ID-------------------------
576: Validate_Id (p_optv_rec, x_return_status);
577: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
578: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
579: -- need to leave
580: l_return_status := x_return_status;
581: RAISE G_EXCEPTION_HALT_VALIDATION;
582: ELSE

Line 589: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

585: END IF;
586:
587: --------CHECK FOR VERSION NUMBER------------------
588: Validate_Object_Version_Number (p_optv_rec, x_return_status);
589: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
590: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
591: -- need to leave
592: l_return_status := x_return_status;
593: RAISE G_EXCEPTION_HALT_VALIDATION;

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

586:
587: --------CHECK FOR VERSION NUMBER------------------
588: Validate_Object_Version_Number (p_optv_rec, x_return_status);
589: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
590: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
591: -- need to leave
592: l_return_status := x_return_status;
593: RAISE G_EXCEPTION_HALT_VALIDATION;
594: ELSE

Line 601: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

597: END IF;
598:
599: --------CHECK FOR NAME------------------
600: Validate_Name (p_optv_rec, x_return_status);
601: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
602: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
603: -- need to leave
604: l_return_status := x_return_status;
605: RAISE G_EXCEPTION_HALT_VALIDATION;

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

598:
599: --------CHECK FOR NAME------------------
600: Validate_Name (p_optv_rec, x_return_status);
601: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
602: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
603: -- need to leave
604: l_return_status := x_return_status;
605: RAISE G_EXCEPTION_HALT_VALIDATION;
606: ELSE

Line 613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

609: END IF;
610:
611: -----CHECK FOR FROM_DATE----------------------------
612: Validate_From_Date (p_optv_rec, x_return_status);
613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
614: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
615: -- need to leave
616: l_return_status := x_return_status;
617: RAISE G_EXCEPTION_HALT_VALIDATION;

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

610:
611: -----CHECK FOR FROM_DATE----------------------------
612: Validate_From_Date (p_optv_rec, x_return_status);
613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
614: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
615: -- need to leave
616: l_return_status := x_return_status;
617: RAISE G_EXCEPTION_HALT_VALIDATION;
618: ELSE

Line 632: OKC_API.set_message(p_app_name =>G_APP_NAME,

628: NULL;
629: RETURN (l_return_status);
630:
631: WHEN OTHERS THEN
632: OKC_API.set_message(p_app_name =>G_APP_NAME,
633: p_msg_name =>G_UNEXPECTED_ERROR,
634: p_token1 =>G_SQL_SQLCODE_TOKEN,
635: p_token1_value =>SQLCODE,
636: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 638: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

634: p_token1 =>G_SQL_SQLCODE_TOKEN,
635: p_token1_value =>SQLCODE,
636: p_token2 =>G_SQL_SQLERRM_TOKEN,
637: p_token2_value =>SQLERRM);
638: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
639: RETURN(l_return_status);
640:
641: END Validate_Attributes;
642:

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

657:
658: FUNCTION Validate_Record(
659: p_optv_rec IN optv_rec_type
660: ) RETURN VARCHAR IS
661: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
662: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
663:
664:
665: BEGIN

Line 662: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

658: FUNCTION Validate_Record(
659: p_optv_rec IN optv_rec_type
660: ) RETURN VARCHAR IS
661: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
662: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
663:
664:
665: BEGIN
666:

Line 669: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

665: BEGIN
666:
667: --------CHECK FOR UNIQUE KEY------------------
668: Validate_Unique_Key (p_optv_rec, x_return_status);
669: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
670: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
671: -- need to leave
672: l_return_status := x_return_status;
673: RAISE G_EXCEPTION_HALT_VALIDATION;

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

666:
667: --------CHECK FOR UNIQUE KEY------------------
668: Validate_Unique_Key (p_optv_rec, x_return_status);
669: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
670: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
671: -- need to leave
672: l_return_status := x_return_status;
673: RAISE G_EXCEPTION_HALT_VALIDATION;
674: ELSE

Line 680: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

676: END IF;
677: END IF;
678: -----CHECK FOR TO_DATE----------------------------
679: Validate_To_Date (p_optv_rec, x_return_status);
680: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
682: -- need to leave
683: l_return_status := x_return_status;
684: RAISE G_EXCEPTION_HALT_VALIDATION;

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

677: END IF;
678: -----CHECK FOR TO_DATE----------------------------
679: Validate_To_Date (p_optv_rec, x_return_status);
680: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
682: -- need to leave
683: l_return_status := x_return_status;
684: RAISE G_EXCEPTION_HALT_VALIDATION;
685: ELSE

Line 700: OKC_API.set_message(p_app_name =>G_APP_NAME,

696: NULL;
697: RETURN (l_return_status);
698:
699: WHEN OTHERS THEN
700: OKC_API.set_message(p_app_name =>G_APP_NAME,
701: p_msg_name =>G_UNEXPECTED_ERROR,
702: p_token1 =>G_SQL_SQLCODE_TOKEN,
703: p_token1_value =>SQLCODE,
704: p_token2 =>G_SQL_SQLERRM_TOKEN,

Line 706: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

702: p_token1 =>G_SQL_SQLCODE_TOKEN,
703: p_token1_value =>SQLCODE,
704: p_token2 =>G_SQL_SQLERRM_TOKEN,
705: p_token2_value =>SQLERRM);
706: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
707: RETURN(l_return_status);
708:
709: END Validate_Record;
710:

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

714:
715: -- FUNCTION Validate_Attributes (
716: -- p_optv_rec IN p_optv_rec_type
717: -- ) RETURN VARCHAR2 IS
718: -- l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
719: -- BEGIN
720: -- IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
721: -- p_optv_rec.id IS NULL
722: -- THEN

Line 720: -- IF p_optv_rec.id = OKC_API.G_MISS_NUM OR

716: -- p_optv_rec IN p_optv_rec_type
717: -- ) RETURN VARCHAR2 IS
718: -- l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
719: -- BEGIN
720: -- IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
721: -- p_optv_rec.id IS NULL
722: -- THEN
723: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
724: -- l_return_status := OKC_API.G_RET_STS_ERROR;

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

719: -- BEGIN
720: -- IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
721: -- p_optv_rec.id IS NULL
722: -- THEN
723: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
724: -- l_return_status := OKC_API.G_RET_STS_ERROR;
725: -- ELSIF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
726: -- p_optv_rec.object_version_number IS NULL
727: -- THEN

Line 724: -- l_return_status := OKC_API.G_RET_STS_ERROR;

720: -- IF p_optv_rec.id = OKC_API.G_MISS_NUM OR
721: -- p_optv_rec.id IS NULL
722: -- THEN
723: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
724: -- l_return_status := OKC_API.G_RET_STS_ERROR;
725: -- ELSIF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
726: -- p_optv_rec.object_version_number IS NULL
727: -- THEN
728: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 725: -- ELSIF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR

721: -- p_optv_rec.id IS NULL
722: -- THEN
723: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
724: -- l_return_status := OKC_API.G_RET_STS_ERROR;
725: -- ELSIF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
726: -- p_optv_rec.object_version_number IS NULL
727: -- THEN
728: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
729: -- l_return_status := OKC_API.G_RET_STS_ERROR;

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

724: -- l_return_status := OKC_API.G_RET_STS_ERROR;
725: -- ELSIF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
726: -- p_optv_rec.object_version_number IS NULL
727: -- THEN
728: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
729: -- l_return_status := OKC_API.G_RET_STS_ERROR;
730: -- ELSIF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
731: -- p_optv_rec.name IS NULL
732: -- THEN

Line 729: -- l_return_status := OKC_API.G_RET_STS_ERROR;

725: -- ELSIF p_optv_rec.object_version_number = OKC_API.G_MISS_NUM OR
726: -- p_optv_rec.object_version_number IS NULL
727: -- THEN
728: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
729: -- l_return_status := OKC_API.G_RET_STS_ERROR;
730: -- ELSIF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
731: -- p_optv_rec.name IS NULL
732: -- THEN
733: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

Line 730: -- ELSIF p_optv_rec.name = OKC_API.G_MISS_CHAR OR

726: -- p_optv_rec.object_version_number IS NULL
727: -- THEN
728: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
729: -- l_return_status := OKC_API.G_RET_STS_ERROR;
730: -- ELSIF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
731: -- p_optv_rec.name IS NULL
732: -- THEN
733: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
734: -- l_return_status := OKC_API.G_RET_STS_ERROR;

Line 733: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

729: -- l_return_status := OKC_API.G_RET_STS_ERROR;
730: -- ELSIF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
731: -- p_optv_rec.name IS NULL
732: -- THEN
733: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
734: -- l_return_status := OKC_API.G_RET_STS_ERROR;
735: -- END IF;
736: -- RETURN(l_return_status);
737: -- END Validate_Attributes;

Line 734: -- l_return_status := OKC_API.G_RET_STS_ERROR;

730: -- ELSIF p_optv_rec.name = OKC_API.G_MISS_CHAR OR
731: -- p_optv_rec.name IS NULL
732: -- THEN
733: -- OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
734: -- l_return_status := OKC_API.G_RET_STS_ERROR;
735: -- END IF;
736: -- RETURN(l_return_status);
737: -- END Validate_Attributes;
738:

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

744: ---------------------------------------
745: -- FUNCTION Validate_Record (
746: -- p_optv_rec IN optv_rec_type
747: -- ) RETURN VARCHAR2 IS
748: -- l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
749: -- l_primary_key OKL_OPTIONS.ID%TYPE;
750: -- l_unique_key OKL_OPTIONS.NAME%TYPE;
751: -- RETURN (l_return_status);
752: -- END Validate_Record;

Line 833: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

829: -- validate_row for:OKL_OPTIONS_V --
830: ------------------------------------
831: PROCEDURE validate_row(
832: p_api_version IN NUMBER,
833: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2,
837: p_optv_rec IN optv_rec_type) IS

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

837: p_optv_rec IN optv_rec_type) IS
838:
839: l_api_version CONSTANT NUMBER := 1;
840: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
842: l_optv_rec optv_rec_type := p_optv_rec;
843: l_opt_rec opt_rec_type;
844: BEGIN
845: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
842: l_optv_rec optv_rec_type := p_optv_rec;
843: l_opt_rec opt_rec_type;
844: BEGIN
845: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
846: G_PKG_NAME,
847: p_init_msg_list,
848: l_api_version,
849: p_api_version,

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

848: l_api_version,
849: p_api_version,
850: '_PVT',
851: x_return_status);
852: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
855: RAISE OKC_API.G_EXCEPTION_ERROR;
856: END IF;

Line 853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

849: p_api_version,
850: '_PVT',
851: x_return_status);
852: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
855: RAISE OKC_API.G_EXCEPTION_ERROR;
856: END IF;
857: --- Validate all non-missing attributes (Item Level Validation)

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

850: '_PVT',
851: x_return_status);
852: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
855: RAISE OKC_API.G_EXCEPTION_ERROR;
856: END IF;
857: --- Validate all non-missing attributes (Item Level Validation)
858: l_return_status := Validate_Attributes(l_optv_rec);

Line 855: RAISE OKC_API.G_EXCEPTION_ERROR;

851: x_return_status);
852: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
855: RAISE OKC_API.G_EXCEPTION_ERROR;
856: END IF;
857: --- Validate all non-missing attributes (Item Level Validation)
858: l_return_status := Validate_Attributes(l_optv_rec);
859: --- If any errors happen abort API

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

856: END IF;
857: --- Validate all non-missing attributes (Item Level Validation)
858: l_return_status := Validate_Attributes(l_optv_rec);
859: --- If any errors happen abort API
860: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;

Line 861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

857: --- Validate all non-missing attributes (Item Level Validation)
858: l_return_status := Validate_Attributes(l_optv_rec);
859: --- If any errors happen abort API
860: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;
865: l_return_status := Validate_Record(l_optv_rec);

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

858: l_return_status := Validate_Attributes(l_optv_rec);
859: --- If any errors happen abort API
860: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;
865: l_return_status := Validate_Record(l_optv_rec);
866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 863: RAISE OKC_API.G_EXCEPTION_ERROR;

859: --- If any errors happen abort API
860: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;
865: l_return_status := Validate_Record(l_optv_rec);
866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;
865: l_return_status := Validate_Record(l_optv_rec);
866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_ERROR;
870: END IF;

Line 867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

863: RAISE OKC_API.G_EXCEPTION_ERROR;
864: END IF;
865: l_return_status := Validate_Record(l_optv_rec);
866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_ERROR;
870: END IF;
871: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

864: END IF;
865: l_return_status := Validate_Record(l_optv_rec);
866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_ERROR;
870: END IF;
871: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
872: EXCEPTION

Line 869: RAISE OKC_API.G_EXCEPTION_ERROR;

865: l_return_status := Validate_Record(l_optv_rec);
866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_ERROR;
870: END IF;
871: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
872: EXCEPTION
873: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_ERROR;
870: END IF;
871: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
872: EXCEPTION
873: WHEN OKC_API.G_EXCEPTION_ERROR THEN
874: x_return_status := OKC_API.HANDLE_EXCEPTIONS
875: (

Line 873: WHEN OKC_API.G_EXCEPTION_ERROR THEN

869: RAISE OKC_API.G_EXCEPTION_ERROR;
870: END IF;
871: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
872: EXCEPTION
873: WHEN OKC_API.G_EXCEPTION_ERROR THEN
874: x_return_status := OKC_API.HANDLE_EXCEPTIONS
875: (
876: l_api_name,
877: G_PKG_NAME,

Line 874: x_return_status := OKC_API.HANDLE_EXCEPTIONS

870: END IF;
871: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
872: EXCEPTION
873: WHEN OKC_API.G_EXCEPTION_ERROR THEN
874: x_return_status := OKC_API.HANDLE_EXCEPTIONS
875: (
876: l_api_name,
877: G_PKG_NAME,
878: 'OKC_API.G_RET_STS_ERROR',

Line 878: 'OKC_API.G_RET_STS_ERROR',

874: x_return_status := OKC_API.HANDLE_EXCEPTIONS
875: (
876: l_api_name,
877: G_PKG_NAME,
878: 'OKC_API.G_RET_STS_ERROR',
879: x_msg_count,
880: x_msg_data,
881: '_PVT'
882: );

Line 883: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

879: x_msg_count,
880: x_msg_data,
881: '_PVT'
882: );
883: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
884: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
885: (
886: l_api_name,
887: G_PKG_NAME,

Line 884: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

880: x_msg_data,
881: '_PVT'
882: );
883: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
884: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
885: (
886: l_api_name,
887: G_PKG_NAME,
888: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 888: 'OKC_API.G_RET_STS_UNEXP_ERROR',

884: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
885: (
886: l_api_name,
887: G_PKG_NAME,
888: 'OKC_API.G_RET_STS_UNEXP_ERROR',
889: x_msg_count,
890: x_msg_data,
891: '_PVT'
892: );

Line 894: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

890: x_msg_data,
891: '_PVT'
892: );
893: WHEN OTHERS THEN
894: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
895: (
896: l_api_name,
897: G_PKG_NAME,
898: 'OTHERS',

Line 909: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

905: -- PL/SQL TBL validate_row for:OPTV_TBL --
906: ------------------------------------------
907: PROCEDURE validate_row(
908: p_api_version IN NUMBER,
909: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2,
913: p_optv_tbl IN optv_tbl_type) IS

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

913: p_optv_tbl IN optv_tbl_type) IS
914:
915: l_api_version CONSTANT NUMBER := 1;
916: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
918: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
919: i NUMBER := 0;
920: BEGIN
921: OKC_API.init_msg_list(p_init_msg_list);

Line 918: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS

914:
915: l_api_version CONSTANT NUMBER := 1;
916: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
918: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
919: i NUMBER := 0;
920: BEGIN
921: OKC_API.init_msg_list(p_init_msg_list);
922: -- Make sure PL/SQL table has records in it before passing

Line 921: OKC_API.init_msg_list(p_init_msg_list);

917: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
918: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
919: i NUMBER := 0;
920: BEGIN
921: OKC_API.init_msg_list(p_init_msg_list);
922: -- Make sure PL/SQL table has records in it before passing
923: IF (p_optv_tbl.COUNT > 0) THEN
924: i := p_optv_tbl.FIRST;
925: LOOP

Line 928: p_init_msg_list => OKC_API.G_FALSE,

924: i := p_optv_tbl.FIRST;
925: LOOP
926: validate_row (
927: p_api_version => p_api_version,
928: p_init_msg_list => OKC_API.G_FALSE,
929: x_return_status => x_return_status,
930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data,
932: p_optv_rec => p_optv_tbl(i));

Line 934: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data,
932: p_optv_rec => p_optv_tbl(i));
933: -- TCHGS: Store the highest degree of error
934: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
935: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
936: l_overall_status := x_return_status;
937: END IF;
938: END IF;

Line 935: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

931: x_msg_data => x_msg_data,
932: p_optv_rec => p_optv_tbl(i));
933: -- TCHGS: Store the highest degree of error
934: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
935: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
936: l_overall_status := x_return_status;
937: END IF;
938: END IF;
939: EXIT WHEN (i = p_optv_tbl.LAST);

Line 946: WHEN OKC_API.G_EXCEPTION_ERROR THEN

942: --TCHGS: return overall status
943: x_return_status := l_overall_status;
944: END IF;
945: EXCEPTION
946: WHEN OKC_API.G_EXCEPTION_ERROR THEN
947: x_return_status := OKC_API.HANDLE_EXCEPTIONS
948: (
949: l_api_name,
950: G_PKG_NAME,

Line 947: x_return_status := OKC_API.HANDLE_EXCEPTIONS

943: x_return_status := l_overall_status;
944: END IF;
945: EXCEPTION
946: WHEN OKC_API.G_EXCEPTION_ERROR THEN
947: x_return_status := OKC_API.HANDLE_EXCEPTIONS
948: (
949: l_api_name,
950: G_PKG_NAME,
951: 'OKC_API.G_RET_STS_ERROR',

Line 951: 'OKC_API.G_RET_STS_ERROR',

947: x_return_status := OKC_API.HANDLE_EXCEPTIONS
948: (
949: l_api_name,
950: G_PKG_NAME,
951: 'OKC_API.G_RET_STS_ERROR',
952: x_msg_count,
953: x_msg_data,
954: '_PVT'
955: );

Line 956: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

952: x_msg_count,
953: x_msg_data,
954: '_PVT'
955: );
956: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
957: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,

Line 957: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

953: x_msg_data,
954: '_PVT'
955: );
956: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
957: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,
961: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 961: 'OKC_API.G_RET_STS_UNEXP_ERROR',

957: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,
961: 'OKC_API.G_RET_STS_UNEXP_ERROR',
962: x_msg_count,
963: x_msg_data,
964: '_PVT'
965: );

Line 967: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

963: x_msg_data,
964: '_PVT'
965: );
966: WHEN OTHERS THEN
967: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
968: (
969: l_api_name,
970: G_PKG_NAME,
971: 'OTHERS',

Line 985: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

981: --------------------------------
982: -- insert_row for:OKL_OPTIONS --
983: --------------------------------
984: PROCEDURE insert_row(
985: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
986: x_return_status OUT NOCOPY VARCHAR2,
987: x_msg_count OUT NOCOPY NUMBER,
988: x_msg_data OUT NOCOPY VARCHAR2,
989: p_opt_rec IN opt_rec_type,

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

990: x_opt_rec OUT NOCOPY opt_rec_type) IS
991:
992: l_api_version CONSTANT NUMBER := 1;
993: l_api_name CONSTANT VARCHAR2(30) := 'OPTIONS_insert_row';
994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
995: l_opt_rec opt_rec_type := p_opt_rec;
996: l_def_opt_rec opt_rec_type;
997: ------------------------------------
998: -- Set_Attributes for:OKL_OPTIONS --

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

1000: FUNCTION Set_Attributes (
1001: p_opt_rec IN opt_rec_type,
1002: x_opt_rec OUT NOCOPY opt_rec_type
1003: ) RETURN VARCHAR2 IS
1004: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1005: BEGIN
1006: x_opt_rec := p_opt_rec;
1007: RETURN(l_return_status);
1008: END Set_Attributes;

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

1006: x_opt_rec := p_opt_rec;
1007: RETURN(l_return_status);
1008: END Set_Attributes;
1009: BEGIN
1010: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1011: p_init_msg_list,
1012: '_PVT',
1013: x_return_status);
1014: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1010: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1011: p_init_msg_list,
1012: '_PVT',
1013: x_return_status);
1014: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;

Line 1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1011: p_init_msg_list,
1012: '_PVT',
1013: x_return_status);
1014: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;
1019: --- Setting item attributes

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

1012: '_PVT',
1013: x_return_status);
1014: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;
1019: --- Setting item attributes
1020: l_return_status := Set_Attributes(

Line 1017: RAISE OKC_API.G_EXCEPTION_ERROR;

1013: x_return_status);
1014: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1016: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1017: RAISE OKC_API.G_EXCEPTION_ERROR;
1018: END IF;
1019: --- Setting item attributes
1020: l_return_status := Set_Attributes(
1021: p_opt_rec, -- IN

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

1020: l_return_status := Set_Attributes(
1021: p_opt_rec, -- IN
1022: l_opt_rec); -- OUT
1023: --- If any errors happen abort API
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;

Line 1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1021: p_opt_rec, -- IN
1022: l_opt_rec); -- OUT
1023: --- If any errors happen abort API
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: INSERT INTO OKL_OPTIONS(

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

1022: l_opt_rec); -- OUT
1023: --- If any errors happen abort API
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: INSERT INTO OKL_OPTIONS(
1030: id,

Line 1027: RAISE OKC_API.G_EXCEPTION_ERROR;

1023: --- If any errors happen abort API
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: INSERT INTO OKL_OPTIONS(
1030: id,
1031: name,

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

1083: l_opt_rec.last_update_date,
1084: l_opt_rec.last_update_login);
1085: -- Set OUT values
1086: x_opt_rec := l_opt_rec;
1087: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1088: EXCEPTION
1089: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1090: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1091: (

Line 1089: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1085: -- Set OUT values
1086: x_opt_rec := l_opt_rec;
1087: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1088: EXCEPTION
1089: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1090: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,

Line 1090: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1086: x_opt_rec := l_opt_rec;
1087: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1088: EXCEPTION
1089: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1090: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,
1094: 'OKC_API.G_RET_STS_ERROR',

Line 1094: 'OKC_API.G_RET_STS_ERROR',

1090: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,
1094: 'OKC_API.G_RET_STS_ERROR',
1095: x_msg_count,
1096: x_msg_data,
1097: '_PVT'
1098: );

Line 1099: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1095: x_msg_count,
1096: x_msg_data,
1097: '_PVT'
1098: );
1099: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1100: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1101: (
1102: l_api_name,
1103: G_PKG_NAME,

Line 1100: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1096: x_msg_data,
1097: '_PVT'
1098: );
1099: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1100: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1101: (
1102: l_api_name,
1103: G_PKG_NAME,
1104: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1104: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1100: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1101: (
1102: l_api_name,
1103: G_PKG_NAME,
1104: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1105: x_msg_count,
1106: x_msg_data,
1107: '_PVT'
1108: );

Line 1110: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1106: x_msg_data,
1107: '_PVT'
1108: );
1109: WHEN OTHERS THEN
1110: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1111: (
1112: l_api_name,
1113: G_PKG_NAME,
1114: 'OTHERS',

Line 1125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1121: -- insert_row for:OKL_OPTIONS_V --
1122: ----------------------------------
1123: PROCEDURE insert_row(
1124: p_api_version IN NUMBER,
1125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_optv_rec IN optv_rec_type,

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

1130: x_optv_rec OUT NOCOPY optv_rec_type) IS
1131:
1132: l_api_version CONSTANT NUMBER := 1;
1133: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1134: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1135: l_optv_rec optv_rec_type;
1136: l_def_optv_rec optv_rec_type;
1137: l_opt_rec opt_rec_type;
1138: lx_opt_rec opt_rec_type;

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

1157: FUNCTION Set_Attributes (
1158: p_optv_rec IN optv_rec_type,
1159: x_optv_rec OUT NOCOPY optv_rec_type
1160: ) RETURN VARCHAR2 IS
1161: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1162: BEGIN
1163: x_optv_rec := p_optv_rec;
1164: x_optv_rec.OBJECT_VERSION_NUMBER := 1;
1165: RETURN(l_return_status);

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

1164: x_optv_rec.OBJECT_VERSION_NUMBER := 1;
1165: RETURN(l_return_status);
1166: END Set_Attributes;
1167: BEGIN
1168: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1169: G_PKG_NAME,
1170: p_init_msg_list,
1171: l_api_version,
1172: p_api_version,

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

1171: l_api_version,
1172: p_api_version,
1173: '_PVT',
1174: x_return_status);
1175: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;

Line 1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1172: p_api_version,
1173: '_PVT',
1174: x_return_status);
1175: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;
1180: l_optv_rec := null_out_defaults(p_optv_rec);

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

1173: '_PVT',
1174: x_return_status);
1175: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;
1180: l_optv_rec := null_out_defaults(p_optv_rec);
1181: -- Set primary key value

Line 1178: RAISE OKC_API.G_EXCEPTION_ERROR;

1174: x_return_status);
1175: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;
1180: l_optv_rec := null_out_defaults(p_optv_rec);
1181: -- Set primary key value
1182: l_optv_rec.ID := get_seq_id;

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

1184: l_return_status := Set_Attributes(
1185: l_optv_rec, -- IN
1186: l_def_optv_rec); -- OUT
1187: --- If any errors happen abort API
1188: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_ERROR;
1192: END IF;

Line 1189: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1185: l_optv_rec, -- IN
1186: l_def_optv_rec); -- OUT
1187: --- If any errors happen abort API
1188: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_ERROR;
1192: END IF;
1193: l_def_optv_rec := fill_who_columns(l_def_optv_rec);

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

1186: l_def_optv_rec); -- OUT
1187: --- If any errors happen abort API
1188: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_ERROR;
1192: END IF;
1193: l_def_optv_rec := fill_who_columns(l_def_optv_rec);
1194: --- Validate all non-missing attributes (Item Level Validation)

Line 1191: RAISE OKC_API.G_EXCEPTION_ERROR;

1187: --- If any errors happen abort API
1188: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_ERROR;
1192: END IF;
1193: l_def_optv_rec := fill_who_columns(l_def_optv_rec);
1194: --- Validate all non-missing attributes (Item Level Validation)
1195: l_return_status := Validate_Attributes(l_def_optv_rec);

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

1193: l_def_optv_rec := fill_who_columns(l_def_optv_rec);
1194: --- Validate all non-missing attributes (Item Level Validation)
1195: l_return_status := Validate_Attributes(l_def_optv_rec);
1196: --- If any errors happen abort API
1197: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_ERROR;
1201: END IF;

Line 1198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1194: --- Validate all non-missing attributes (Item Level Validation)
1195: l_return_status := Validate_Attributes(l_def_optv_rec);
1196: --- If any errors happen abort API
1197: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_ERROR;
1201: END IF;
1202: l_return_status := Validate_Record(l_def_optv_rec);

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

1195: l_return_status := Validate_Attributes(l_def_optv_rec);
1196: --- If any errors happen abort API
1197: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_ERROR;
1201: END IF;
1202: l_return_status := Validate_Record(l_def_optv_rec);
1203: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1200: RAISE OKC_API.G_EXCEPTION_ERROR;

1196: --- If any errors happen abort API
1197: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_ERROR;
1201: END IF;
1202: l_return_status := Validate_Record(l_def_optv_rec);
1203: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_ERROR;
1201: END IF;
1202: l_return_status := Validate_Record(l_def_optv_rec);
1203: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1206: RAISE OKC_API.G_EXCEPTION_ERROR;
1207: END IF;

Line 1204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1200: RAISE OKC_API.G_EXCEPTION_ERROR;
1201: END IF;
1202: l_return_status := Validate_Record(l_def_optv_rec);
1203: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1206: RAISE OKC_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: --------------------------------------

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

1201: END IF;
1202: l_return_status := Validate_Record(l_def_optv_rec);
1203: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1206: RAISE OKC_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: --------------------------------------
1209: -- Move VIEW record to "Child" records

Line 1206: RAISE OKC_API.G_EXCEPTION_ERROR;

1202: l_return_status := Validate_Record(l_def_optv_rec);
1203: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1206: RAISE OKC_API.G_EXCEPTION_ERROR;
1207: END IF;
1208: --------------------------------------
1209: -- Move VIEW record to "Child" records
1210: --------------------------------------

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

1219: x_msg_data,
1220: l_opt_rec,
1221: lx_opt_rec
1222: );
1223: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: END IF;

Line 1224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1220: l_opt_rec,
1221: lx_opt_rec
1222: );
1223: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: migrate(lx_opt_rec, l_def_optv_rec);

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

1221: lx_opt_rec
1222: );
1223: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: migrate(lx_opt_rec, l_def_optv_rec);
1229: -- Set OUT values

Line 1226: RAISE OKC_API.G_EXCEPTION_ERROR;

1222: );
1223: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: migrate(lx_opt_rec, l_def_optv_rec);
1229: -- Set OUT values
1230: x_optv_rec := l_def_optv_rec;

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

1227: END IF;
1228: migrate(lx_opt_rec, l_def_optv_rec);
1229: -- Set OUT values
1230: x_optv_rec := l_def_optv_rec;
1231: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1232: EXCEPTION
1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (

Line 1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1229: -- Set OUT values
1230: x_optv_rec := l_def_optv_rec;
1231: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1232: EXCEPTION
1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,

Line 1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1230: x_optv_rec := l_def_optv_rec;
1231: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1232: EXCEPTION
1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OKC_API.G_RET_STS_ERROR',

Line 1238: 'OKC_API.G_RET_STS_ERROR',

1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OKC_API.G_RET_STS_ERROR',
1239: x_msg_count,
1240: x_msg_data,
1241: '_PVT'
1242: );

Line 1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1239: x_msg_count,
1240: x_msg_data,
1241: '_PVT'
1242: );
1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1244: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,

Line 1244: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1240: x_msg_data,
1241: '_PVT'
1242: );
1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1244: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,
1248: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1248: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1244: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,
1248: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1249: x_msg_count,
1250: x_msg_data,
1251: '_PVT'
1252: );

Line 1254: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1250: x_msg_data,
1251: '_PVT'
1252: );
1253: WHEN OTHERS THEN
1254: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1255: (
1256: l_api_name,
1257: G_PKG_NAME,
1258: 'OTHERS',

Line 1269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1265: -- PL/SQL TBL insert_row for:OPTV_TBL --
1266: ----------------------------------------
1267: PROCEDURE insert_row(
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1270: x_return_status OUT NOCOPY VARCHAR2,
1271: x_msg_count OUT NOCOPY NUMBER,
1272: x_msg_data OUT NOCOPY VARCHAR2,
1273: p_optv_tbl IN optv_tbl_type,

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

1274: x_optv_tbl OUT NOCOPY optv_tbl_type) IS
1275:
1276: l_api_version CONSTANT NUMBER := 1;
1277: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1279: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
1280: i NUMBER := 0;
1281: BEGIN
1282: OKC_API.init_msg_list(p_init_msg_list);

Line 1279: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS

1275:
1276: l_api_version CONSTANT NUMBER := 1;
1277: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1279: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
1280: i NUMBER := 0;
1281: BEGIN
1282: OKC_API.init_msg_list(p_init_msg_list);
1283: -- Make sure PL/SQL table has records in it before passing

Line 1282: OKC_API.init_msg_list(p_init_msg_list);

1278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1279: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
1280: i NUMBER := 0;
1281: BEGIN
1282: OKC_API.init_msg_list(p_init_msg_list);
1283: -- Make sure PL/SQL table has records in it before passing
1284: IF (p_optv_tbl.COUNT > 0) THEN
1285: i := p_optv_tbl.FIRST;
1286: LOOP

Line 1289: p_init_msg_list => OKC_API.G_FALSE,

1285: i := p_optv_tbl.FIRST;
1286: LOOP
1287: insert_row (
1288: p_api_version => p_api_version,
1289: p_init_msg_list => OKC_API.G_FALSE,
1290: x_return_status => x_return_status,
1291: x_msg_count => x_msg_count,
1292: x_msg_data => x_msg_data,
1293: p_optv_rec => p_optv_tbl(i),

Line 1296: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1292: x_msg_data => x_msg_data,
1293: p_optv_rec => p_optv_tbl(i),
1294: x_optv_rec => x_optv_tbl(i));
1295: -- TCHGS: Store the highest degree of error
1296: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1297: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1298: l_overall_status := x_return_status;
1299: END IF;
1300: END IF;

Line 1297: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

1293: p_optv_rec => p_optv_tbl(i),
1294: x_optv_rec => x_optv_tbl(i));
1295: -- TCHGS: Store the highest degree of error
1296: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1297: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1298: l_overall_status := x_return_status;
1299: END IF;
1300: END IF;
1301: EXIT WHEN (i = p_optv_tbl.LAST);

Line 1308: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1304: --TCHGS: return overall status
1305: x_return_status := l_overall_status;
1306: END IF;
1307: EXCEPTION
1308: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1309: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1310: (
1311: l_api_name,
1312: G_PKG_NAME,

Line 1309: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1305: x_return_status := l_overall_status;
1306: END IF;
1307: EXCEPTION
1308: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1309: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1310: (
1311: l_api_name,
1312: G_PKG_NAME,
1313: 'OKC_API.G_RET_STS_ERROR',

Line 1313: 'OKC_API.G_RET_STS_ERROR',

1309: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1310: (
1311: l_api_name,
1312: G_PKG_NAME,
1313: 'OKC_API.G_RET_STS_ERROR',
1314: x_msg_count,
1315: x_msg_data,
1316: '_PVT'
1317: );

Line 1318: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1319: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1315: x_msg_data,
1316: '_PVT'
1317: );
1318: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1319: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1320: (
1321: l_api_name,
1322: G_PKG_NAME,
1323: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1323: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1329: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1325: x_msg_data,
1326: '_PVT'
1327: );
1328: WHEN OTHERS THEN
1329: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,
1333: 'OTHERS',

Line 1347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1343: ------------------------------
1344: -- lock_row for:OKL_OPTIONS --
1345: ------------------------------
1346: PROCEDURE lock_row(
1347: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1348: x_return_status OUT NOCOPY VARCHAR2,
1349: x_msg_count OUT NOCOPY NUMBER,
1350: x_msg_data OUT NOCOPY VARCHAR2,
1351: p_opt_rec IN opt_rec_type) IS

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

1364: FROM OKL_OPTIONS
1365: WHERE ID = p_opt_rec.id;
1366: l_api_version CONSTANT NUMBER := 1;
1367: l_api_name CONSTANT VARCHAR2(30) := 'OPTIONS_lock_row';
1368: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1369: l_object_version_number OKL_OPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1370: lc_object_version_number OKL_OPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1371: l_row_notfound BOOLEAN := FALSE;
1372: lc_row_notfound BOOLEAN := FALSE;

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

1370: lc_object_version_number OKL_OPTIONS.OBJECT_VERSION_NUMBER%TYPE;
1371: l_row_notfound BOOLEAN := FALSE;
1372: lc_row_notfound BOOLEAN := FALSE;
1373: BEGIN
1374: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1375: p_init_msg_list,
1376: '_PVT',
1377: x_return_status);
1378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1374: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1375: p_init_msg_list,
1376: '_PVT',
1377: x_return_status);
1378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1381: RAISE OKC_API.G_EXCEPTION_ERROR;
1382: END IF;

Line 1379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1375: p_init_msg_list,
1376: '_PVT',
1377: x_return_status);
1378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1381: RAISE OKC_API.G_EXCEPTION_ERROR;
1382: END IF;
1383: BEGIN

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

1376: '_PVT',
1377: x_return_status);
1378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1381: RAISE OKC_API.G_EXCEPTION_ERROR;
1382: END IF;
1383: BEGIN
1384: OPEN lock_csr(p_opt_rec);

Line 1381: RAISE OKC_API.G_EXCEPTION_ERROR;

1377: x_return_status);
1378: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1380: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1381: RAISE OKC_API.G_EXCEPTION_ERROR;
1382: END IF;
1383: BEGIN
1384: OPEN lock_csr(p_opt_rec);
1385: FETCH lock_csr INTO l_object_version_number;

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

1389: WHEN E_Resource_Busy THEN
1390: IF (lock_csr%ISOPEN) THEN
1391: CLOSE lock_csr;
1392: END IF;
1393: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1394: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1395: END;
1396:
1397: IF ( l_row_notfound ) THEN

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

1400: lc_row_notfound := lchk_csr%NOTFOUND;
1401: CLOSE lchk_csr;
1402: END IF;
1403: IF (lc_row_notfound) THEN
1404: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1405: RAISE OKC_API.G_EXCEPTION_ERROR;
1406: ELSIF lc_object_version_number > p_opt_rec.object_version_number THEN
1407: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1408: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1405: RAISE OKC_API.G_EXCEPTION_ERROR;

1401: CLOSE lchk_csr;
1402: END IF;
1403: IF (lc_row_notfound) THEN
1404: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1405: RAISE OKC_API.G_EXCEPTION_ERROR;
1406: ELSIF lc_object_version_number > p_opt_rec.object_version_number THEN
1407: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: ELSIF lc_object_version_number <> p_opt_rec.object_version_number THEN

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

1403: IF (lc_row_notfound) THEN
1404: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1405: RAISE OKC_API.G_EXCEPTION_ERROR;
1406: ELSIF lc_object_version_number > p_opt_rec.object_version_number THEN
1407: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: ELSIF lc_object_version_number <> p_opt_rec.object_version_number THEN
1410: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1411: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1408: RAISE OKC_API.G_EXCEPTION_ERROR;

1404: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1405: RAISE OKC_API.G_EXCEPTION_ERROR;
1406: ELSIF lc_object_version_number > p_opt_rec.object_version_number THEN
1407: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: ELSIF lc_object_version_number <> p_opt_rec.object_version_number THEN
1410: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: ELSIF lc_object_version_number = -1 THEN

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

1406: ELSIF lc_object_version_number > p_opt_rec.object_version_number THEN
1407: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: ELSIF lc_object_version_number <> p_opt_rec.object_version_number THEN
1410: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: ELSIF lc_object_version_number = -1 THEN
1413: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1414: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1411: RAISE OKC_API.G_EXCEPTION_ERROR;

1407: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1408: RAISE OKC_API.G_EXCEPTION_ERROR;
1409: ELSIF lc_object_version_number <> p_opt_rec.object_version_number THEN
1410: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: ELSIF lc_object_version_number = -1 THEN
1413: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;

Line 1413: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1409: ELSIF lc_object_version_number <> p_opt_rec.object_version_number THEN
1410: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: ELSIF lc_object_version_number = -1 THEN
1413: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;
1416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1417: EXCEPTION

Line 1414: RAISE OKC_API.G_EXCEPTION_ERROR;

1410: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: ELSIF lc_object_version_number = -1 THEN
1413: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;
1416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1417: EXCEPTION
1418: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1412: ELSIF lc_object_version_number = -1 THEN
1413: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;
1416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1417: EXCEPTION
1418: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1419: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1420: (

Line 1418: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1414: RAISE OKC_API.G_EXCEPTION_ERROR;
1415: END IF;
1416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1417: EXCEPTION
1418: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1419: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1420: (
1421: l_api_name,
1422: G_PKG_NAME,

Line 1419: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1415: END IF;
1416: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1417: EXCEPTION
1418: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1419: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1420: (
1421: l_api_name,
1422: G_PKG_NAME,
1423: 'OKC_API.G_RET_STS_ERROR',

Line 1423: 'OKC_API.G_RET_STS_ERROR',

1419: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1420: (
1421: l_api_name,
1422: G_PKG_NAME,
1423: 'OKC_API.G_RET_STS_ERROR',
1424: x_msg_count,
1425: x_msg_data,
1426: '_PVT'
1427: );

Line 1428: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1424: x_msg_count,
1425: x_msg_data,
1426: '_PVT'
1427: );
1428: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1429: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,

Line 1429: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1425: x_msg_data,
1426: '_PVT'
1427: );
1428: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1429: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,
1433: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1433: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1429: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,
1433: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1434: x_msg_count,
1435: x_msg_data,
1436: '_PVT'
1437: );

Line 1439: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1435: x_msg_data,
1436: '_PVT'
1437: );
1438: WHEN OTHERS THEN
1439: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1440: (
1441: l_api_name,
1442: G_PKG_NAME,
1443: 'OTHERS',

Line 1454: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1450: -- lock_row for:OKL_OPTIONS_V --
1451: --------------------------------
1452: PROCEDURE lock_row(
1453: p_api_version IN NUMBER,
1454: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1455: x_return_status OUT NOCOPY VARCHAR2,
1456: x_msg_count OUT NOCOPY NUMBER,
1457: x_msg_data OUT NOCOPY VARCHAR2,
1458: p_optv_rec IN optv_rec_type) IS

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

1458: p_optv_rec IN optv_rec_type) IS
1459:
1460: l_api_version CONSTANT NUMBER := 1;
1461: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1463: l_opt_rec opt_rec_type;
1464: BEGIN
1465: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1466: G_PKG_NAME,

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

1461: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1463: l_opt_rec opt_rec_type;
1464: BEGIN
1465: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1466: G_PKG_NAME,
1467: p_init_msg_list,
1468: l_api_version,
1469: p_api_version,

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

1468: l_api_version,
1469: p_api_version,
1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;

Line 1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1469: p_api_version,
1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------

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

1470: '_PVT',
1471: x_return_status);
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------
1478: -- Move VIEW record to "Child" records

Line 1475: RAISE OKC_API.G_EXCEPTION_ERROR;

1471: x_return_status);
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------
1478: -- Move VIEW record to "Child" records
1479: --------------------------------------

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

1487: x_msg_count,
1488: x_msg_data,
1489: l_opt_rec
1490: );
1491: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1494: RAISE OKC_API.G_EXCEPTION_ERROR;
1495: END IF;

Line 1492: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1488: x_msg_data,
1489: l_opt_rec
1490: );
1491: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1494: RAISE OKC_API.G_EXCEPTION_ERROR;
1495: END IF;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1489: l_opt_rec
1490: );
1491: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1494: RAISE OKC_API.G_EXCEPTION_ERROR;
1495: END IF;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1497: EXCEPTION

Line 1494: RAISE OKC_API.G_EXCEPTION_ERROR;

1490: );
1491: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1494: RAISE OKC_API.G_EXCEPTION_ERROR;
1495: END IF;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1492: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1494: RAISE OKC_API.G_EXCEPTION_ERROR;
1495: END IF;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1500: (

Line 1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1494: RAISE OKC_API.G_EXCEPTION_ERROR;
1495: END IF;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1500: (
1501: l_api_name,
1502: G_PKG_NAME,

Line 1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1495: END IF;
1496: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1500: (
1501: l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_ERROR',

Line 1503: 'OKC_API.G_RET_STS_ERROR',

1499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1500: (
1501: l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_ERROR',
1504: x_msg_count,
1505: x_msg_data,
1506: '_PVT'
1507: );

Line 1508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1504: x_msg_count,
1505: x_msg_data,
1506: '_PVT'
1507: );
1508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1510: (
1511: l_api_name,
1512: G_PKG_NAME,

Line 1509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1505: x_msg_data,
1506: '_PVT'
1507: );
1508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1510: (
1511: l_api_name,
1512: G_PKG_NAME,
1513: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1513: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1510: (
1511: l_api_name,
1512: G_PKG_NAME,
1513: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1514: x_msg_count,
1515: x_msg_data,
1516: '_PVT'
1517: );

Line 1519: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1515: x_msg_data,
1516: '_PVT'
1517: );
1518: WHEN OTHERS THEN
1519: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1520: (
1521: l_api_name,
1522: G_PKG_NAME,
1523: 'OTHERS',

Line 1534: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1530: -- PL/SQL TBL lock_row for:OPTV_TBL --
1531: --------------------------------------
1532: PROCEDURE lock_row(
1533: p_api_version IN NUMBER,
1534: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1535: x_return_status OUT NOCOPY VARCHAR2,
1536: x_msg_count OUT NOCOPY NUMBER,
1537: x_msg_data OUT NOCOPY VARCHAR2,
1538: p_optv_tbl IN optv_tbl_type) IS

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

1538: p_optv_tbl IN optv_tbl_type) IS
1539:
1540: l_api_version CONSTANT NUMBER := 1;
1541: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1542: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1543: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
1544: i NUMBER := 0;
1545: BEGIN
1546: OKC_API.init_msg_list(p_init_msg_list);

Line 1543: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS

1539:
1540: l_api_version CONSTANT NUMBER := 1;
1541: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1542: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1543: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
1544: i NUMBER := 0;
1545: BEGIN
1546: OKC_API.init_msg_list(p_init_msg_list);
1547: -- Make sure PL/SQL table has records in it before passing

Line 1546: OKC_API.init_msg_list(p_init_msg_list);

1542: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1543: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
1544: i NUMBER := 0;
1545: BEGIN
1546: OKC_API.init_msg_list(p_init_msg_list);
1547: -- Make sure PL/SQL table has records in it before passing
1548: IF (p_optv_tbl.COUNT > 0) THEN
1549: i := p_optv_tbl.FIRST;
1550: LOOP

Line 1553: p_init_msg_list => OKC_API.G_FALSE,

1549: i := p_optv_tbl.FIRST;
1550: LOOP
1551: lock_row (
1552: p_api_version => p_api_version,
1553: p_init_msg_list => OKC_API.G_FALSE,
1554: x_return_status => x_return_status,
1555: x_msg_count => x_msg_count,
1556: x_msg_data => x_msg_data,
1557: p_optv_rec => p_optv_tbl(i));

Line 1559: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1555: x_msg_count => x_msg_count,
1556: x_msg_data => x_msg_data,
1557: p_optv_rec => p_optv_tbl(i));
1558: -- TCHGS: Store the highest degree of error
1559: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1560: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1561: l_overall_status := x_return_status;
1562: END IF;
1563: END IF;

Line 1560: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

1556: x_msg_data => x_msg_data,
1557: p_optv_rec => p_optv_tbl(i));
1558: -- TCHGS: Store the highest degree of error
1559: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1560: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1561: l_overall_status := x_return_status;
1562: END IF;
1563: END IF;
1564: EXIT WHEN (i = p_optv_tbl.LAST);

Line 1571: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1567: --TCHGS: return overall status
1568: x_return_status := l_overall_status;
1569: END IF;
1570: EXCEPTION
1571: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,

Line 1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1568: x_return_status := l_overall_status;
1569: END IF;
1570: EXCEPTION
1571: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,
1576: 'OKC_API.G_RET_STS_ERROR',

Line 1576: 'OKC_API.G_RET_STS_ERROR',

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

Line 1581: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1582: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1578: x_msg_data,
1579: '_PVT'
1580: );
1581: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1582: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1586: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1582: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1587: x_msg_count,
1588: x_msg_data,
1589: '_PVT'
1590: );

Line 1592: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1588: x_msg_data,
1589: '_PVT'
1590: );
1591: WHEN OTHERS THEN
1592: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1593: (
1594: l_api_name,
1595: G_PKG_NAME,
1596: 'OTHERS',

Line 1610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1606: --------------------------------
1607: -- update_row for:OKL_OPTIONS --
1608: --------------------------------
1609: PROCEDURE update_row(
1610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1611: x_return_status OUT NOCOPY VARCHAR2,
1612: x_msg_count OUT NOCOPY NUMBER,
1613: x_msg_data OUT NOCOPY VARCHAR2,
1614: p_opt_rec IN opt_rec_type,

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

1615: x_opt_rec OUT NOCOPY opt_rec_type) IS
1616:
1617: l_api_version CONSTANT NUMBER := 1;
1618: l_api_name CONSTANT VARCHAR2(30) := 'OPTIONS_update_row';
1619: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1620: l_opt_rec opt_rec_type := p_opt_rec;
1621: l_def_opt_rec opt_rec_type;
1622: l_row_notfound BOOLEAN := TRUE;
1623: ----------------------------------

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

1628: x_opt_rec OUT NOCOPY opt_rec_type
1629: ) RETURN VARCHAR2 IS
1630: l_opt_rec opt_rec_type;
1631: l_row_notfound BOOLEAN := TRUE;
1632: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1633: BEGIN
1634: x_opt_rec := p_opt_rec;
1635: -- Get current database values
1636: l_opt_rec := get_rec(p_opt_rec, l_row_notfound);

Line 1638: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1634: x_opt_rec := p_opt_rec;
1635: -- Get current database values
1636: l_opt_rec := get_rec(p_opt_rec, l_row_notfound);
1637: IF (l_row_notfound) THEN
1638: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1639: END IF;
1640: IF (x_opt_rec.id = OKC_API.G_MISS_NUM)
1641: THEN
1642: x_opt_rec.id := l_opt_rec.id;

Line 1640: IF (x_opt_rec.id = OKC_API.G_MISS_NUM)

1636: l_opt_rec := get_rec(p_opt_rec, l_row_notfound);
1637: IF (l_row_notfound) THEN
1638: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1639: END IF;
1640: IF (x_opt_rec.id = OKC_API.G_MISS_NUM)
1641: THEN
1642: x_opt_rec.id := l_opt_rec.id;
1643: END IF;
1644: IF (x_opt_rec.name = OKC_API.G_MISS_CHAR)

Line 1644: IF (x_opt_rec.name = OKC_API.G_MISS_CHAR)

1640: IF (x_opt_rec.id = OKC_API.G_MISS_NUM)
1641: THEN
1642: x_opt_rec.id := l_opt_rec.id;
1643: END IF;
1644: IF (x_opt_rec.name = OKC_API.G_MISS_CHAR)
1645: THEN
1646: x_opt_rec.name := l_opt_rec.name;
1647: END IF;
1648: IF (x_opt_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1648: IF (x_opt_rec.object_version_number = OKC_API.G_MISS_NUM)

1644: IF (x_opt_rec.name = OKC_API.G_MISS_CHAR)
1645: THEN
1646: x_opt_rec.name := l_opt_rec.name;
1647: END IF;
1648: IF (x_opt_rec.object_version_number = OKC_API.G_MISS_NUM)
1649: THEN
1650: x_opt_rec.object_version_number := l_opt_rec.object_version_number;
1651: END IF;
1652: IF (x_opt_rec.description = OKC_API.G_MISS_CHAR)

Line 1652: IF (x_opt_rec.description = OKC_API.G_MISS_CHAR)

1648: IF (x_opt_rec.object_version_number = OKC_API.G_MISS_NUM)
1649: THEN
1650: x_opt_rec.object_version_number := l_opt_rec.object_version_number;
1651: END IF;
1652: IF (x_opt_rec.description = OKC_API.G_MISS_CHAR)
1653: THEN
1654: x_opt_rec.description := l_opt_rec.description;
1655: END IF;
1656: IF (x_opt_rec.from_date = OKC_API.G_MISS_DATE)

Line 1656: IF (x_opt_rec.from_date = OKC_API.G_MISS_DATE)

1652: IF (x_opt_rec.description = OKC_API.G_MISS_CHAR)
1653: THEN
1654: x_opt_rec.description := l_opt_rec.description;
1655: END IF;
1656: IF (x_opt_rec.from_date = OKC_API.G_MISS_DATE)
1657: THEN
1658: x_opt_rec.from_date := l_opt_rec.from_date;
1659: END IF;
1660: IF (x_opt_rec.TO_DATE = OKC_API.G_MISS_DATE)

Line 1660: IF (x_opt_rec.TO_DATE = OKC_API.G_MISS_DATE)

1656: IF (x_opt_rec.from_date = OKC_API.G_MISS_DATE)
1657: THEN
1658: x_opt_rec.from_date := l_opt_rec.from_date;
1659: END IF;
1660: IF (x_opt_rec.TO_DATE = OKC_API.G_MISS_DATE)
1661: THEN
1662: x_opt_rec.TO_DATE := l_opt_rec.TO_DATE;
1663: END IF;
1664: IF (x_opt_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 1664: IF (x_opt_rec.attribute_category = OKC_API.G_MISS_CHAR)

1660: IF (x_opt_rec.TO_DATE = OKC_API.G_MISS_DATE)
1661: THEN
1662: x_opt_rec.TO_DATE := l_opt_rec.TO_DATE;
1663: END IF;
1664: IF (x_opt_rec.attribute_category = OKC_API.G_MISS_CHAR)
1665: THEN
1666: x_opt_rec.attribute_category := l_opt_rec.attribute_category;
1667: END IF;
1668: IF (x_opt_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 1668: IF (x_opt_rec.attribute1 = OKC_API.G_MISS_CHAR)

1664: IF (x_opt_rec.attribute_category = OKC_API.G_MISS_CHAR)
1665: THEN
1666: x_opt_rec.attribute_category := l_opt_rec.attribute_category;
1667: END IF;
1668: IF (x_opt_rec.attribute1 = OKC_API.G_MISS_CHAR)
1669: THEN
1670: x_opt_rec.attribute1 := l_opt_rec.attribute1;
1671: END IF;
1672: IF (x_opt_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 1672: IF (x_opt_rec.attribute2 = OKC_API.G_MISS_CHAR)

1668: IF (x_opt_rec.attribute1 = OKC_API.G_MISS_CHAR)
1669: THEN
1670: x_opt_rec.attribute1 := l_opt_rec.attribute1;
1671: END IF;
1672: IF (x_opt_rec.attribute2 = OKC_API.G_MISS_CHAR)
1673: THEN
1674: x_opt_rec.attribute2 := l_opt_rec.attribute2;
1675: END IF;
1676: IF (x_opt_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 1676: IF (x_opt_rec.attribute3 = OKC_API.G_MISS_CHAR)

1672: IF (x_opt_rec.attribute2 = OKC_API.G_MISS_CHAR)
1673: THEN
1674: x_opt_rec.attribute2 := l_opt_rec.attribute2;
1675: END IF;
1676: IF (x_opt_rec.attribute3 = OKC_API.G_MISS_CHAR)
1677: THEN
1678: x_opt_rec.attribute3 := l_opt_rec.attribute3;
1679: END IF;
1680: IF (x_opt_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 1680: IF (x_opt_rec.attribute4 = OKC_API.G_MISS_CHAR)

1676: IF (x_opt_rec.attribute3 = OKC_API.G_MISS_CHAR)
1677: THEN
1678: x_opt_rec.attribute3 := l_opt_rec.attribute3;
1679: END IF;
1680: IF (x_opt_rec.attribute4 = OKC_API.G_MISS_CHAR)
1681: THEN
1682: x_opt_rec.attribute4 := l_opt_rec.attribute4;
1683: END IF;
1684: IF (x_opt_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 1684: IF (x_opt_rec.attribute5 = OKC_API.G_MISS_CHAR)

1680: IF (x_opt_rec.attribute4 = OKC_API.G_MISS_CHAR)
1681: THEN
1682: x_opt_rec.attribute4 := l_opt_rec.attribute4;
1683: END IF;
1684: IF (x_opt_rec.attribute5 = OKC_API.G_MISS_CHAR)
1685: THEN
1686: x_opt_rec.attribute5 := l_opt_rec.attribute5;
1687: END IF;
1688: IF (x_opt_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 1688: IF (x_opt_rec.attribute6 = OKC_API.G_MISS_CHAR)

1684: IF (x_opt_rec.attribute5 = OKC_API.G_MISS_CHAR)
1685: THEN
1686: x_opt_rec.attribute5 := l_opt_rec.attribute5;
1687: END IF;
1688: IF (x_opt_rec.attribute6 = OKC_API.G_MISS_CHAR)
1689: THEN
1690: x_opt_rec.attribute6 := l_opt_rec.attribute6;
1691: END IF;
1692: IF (x_opt_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 1692: IF (x_opt_rec.attribute7 = OKC_API.G_MISS_CHAR)

1688: IF (x_opt_rec.attribute6 = OKC_API.G_MISS_CHAR)
1689: THEN
1690: x_opt_rec.attribute6 := l_opt_rec.attribute6;
1691: END IF;
1692: IF (x_opt_rec.attribute7 = OKC_API.G_MISS_CHAR)
1693: THEN
1694: x_opt_rec.attribute7 := l_opt_rec.attribute7;
1695: END IF;
1696: IF (x_opt_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 1696: IF (x_opt_rec.attribute8 = OKC_API.G_MISS_CHAR)

1692: IF (x_opt_rec.attribute7 = OKC_API.G_MISS_CHAR)
1693: THEN
1694: x_opt_rec.attribute7 := l_opt_rec.attribute7;
1695: END IF;
1696: IF (x_opt_rec.attribute8 = OKC_API.G_MISS_CHAR)
1697: THEN
1698: x_opt_rec.attribute8 := l_opt_rec.attribute8;
1699: END IF;
1700: IF (x_opt_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 1700: IF (x_opt_rec.attribute9 = OKC_API.G_MISS_CHAR)

1696: IF (x_opt_rec.attribute8 = OKC_API.G_MISS_CHAR)
1697: THEN
1698: x_opt_rec.attribute8 := l_opt_rec.attribute8;
1699: END IF;
1700: IF (x_opt_rec.attribute9 = OKC_API.G_MISS_CHAR)
1701: THEN
1702: x_opt_rec.attribute9 := l_opt_rec.attribute9;
1703: END IF;
1704: IF (x_opt_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 1704: IF (x_opt_rec.attribute10 = OKC_API.G_MISS_CHAR)

1700: IF (x_opt_rec.attribute9 = OKC_API.G_MISS_CHAR)
1701: THEN
1702: x_opt_rec.attribute9 := l_opt_rec.attribute9;
1703: END IF;
1704: IF (x_opt_rec.attribute10 = OKC_API.G_MISS_CHAR)
1705: THEN
1706: x_opt_rec.attribute10 := l_opt_rec.attribute10;
1707: END IF;
1708: IF (x_opt_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 1708: IF (x_opt_rec.attribute11 = OKC_API.G_MISS_CHAR)

1704: IF (x_opt_rec.attribute10 = OKC_API.G_MISS_CHAR)
1705: THEN
1706: x_opt_rec.attribute10 := l_opt_rec.attribute10;
1707: END IF;
1708: IF (x_opt_rec.attribute11 = OKC_API.G_MISS_CHAR)
1709: THEN
1710: x_opt_rec.attribute11 := l_opt_rec.attribute11;
1711: END IF;
1712: IF (x_opt_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 1712: IF (x_opt_rec.attribute12 = OKC_API.G_MISS_CHAR)

1708: IF (x_opt_rec.attribute11 = OKC_API.G_MISS_CHAR)
1709: THEN
1710: x_opt_rec.attribute11 := l_opt_rec.attribute11;
1711: END IF;
1712: IF (x_opt_rec.attribute12 = OKC_API.G_MISS_CHAR)
1713: THEN
1714: x_opt_rec.attribute12 := l_opt_rec.attribute12;
1715: END IF;
1716: IF (x_opt_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 1716: IF (x_opt_rec.attribute13 = OKC_API.G_MISS_CHAR)

1712: IF (x_opt_rec.attribute12 = OKC_API.G_MISS_CHAR)
1713: THEN
1714: x_opt_rec.attribute12 := l_opt_rec.attribute12;
1715: END IF;
1716: IF (x_opt_rec.attribute13 = OKC_API.G_MISS_CHAR)
1717: THEN
1718: x_opt_rec.attribute13 := l_opt_rec.attribute13;
1719: END IF;
1720: IF (x_opt_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 1720: IF (x_opt_rec.attribute14 = OKC_API.G_MISS_CHAR)

1716: IF (x_opt_rec.attribute13 = OKC_API.G_MISS_CHAR)
1717: THEN
1718: x_opt_rec.attribute13 := l_opt_rec.attribute13;
1719: END IF;
1720: IF (x_opt_rec.attribute14 = OKC_API.G_MISS_CHAR)
1721: THEN
1722: x_opt_rec.attribute14 := l_opt_rec.attribute14;
1723: END IF;
1724: IF (x_opt_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 1724: IF (x_opt_rec.attribute15 = OKC_API.G_MISS_CHAR)

1720: IF (x_opt_rec.attribute14 = OKC_API.G_MISS_CHAR)
1721: THEN
1722: x_opt_rec.attribute14 := l_opt_rec.attribute14;
1723: END IF;
1724: IF (x_opt_rec.attribute15 = OKC_API.G_MISS_CHAR)
1725: THEN
1726: x_opt_rec.attribute15 := l_opt_rec.attribute15;
1727: END IF;
1728: IF (x_opt_rec.created_by = OKC_API.G_MISS_NUM)

Line 1728: IF (x_opt_rec.created_by = OKC_API.G_MISS_NUM)

1724: IF (x_opt_rec.attribute15 = OKC_API.G_MISS_CHAR)
1725: THEN
1726: x_opt_rec.attribute15 := l_opt_rec.attribute15;
1727: END IF;
1728: IF (x_opt_rec.created_by = OKC_API.G_MISS_NUM)
1729: THEN
1730: x_opt_rec.created_by := l_opt_rec.created_by;
1731: END IF;
1732: IF (x_opt_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1732: IF (x_opt_rec.creation_date = OKC_API.G_MISS_DATE)

1728: IF (x_opt_rec.created_by = OKC_API.G_MISS_NUM)
1729: THEN
1730: x_opt_rec.created_by := l_opt_rec.created_by;
1731: END IF;
1732: IF (x_opt_rec.creation_date = OKC_API.G_MISS_DATE)
1733: THEN
1734: x_opt_rec.creation_date := l_opt_rec.creation_date;
1735: END IF;
1736: IF (x_opt_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1736: IF (x_opt_rec.last_updated_by = OKC_API.G_MISS_NUM)

1732: IF (x_opt_rec.creation_date = OKC_API.G_MISS_DATE)
1733: THEN
1734: x_opt_rec.creation_date := l_opt_rec.creation_date;
1735: END IF;
1736: IF (x_opt_rec.last_updated_by = OKC_API.G_MISS_NUM)
1737: THEN
1738: x_opt_rec.last_updated_by := l_opt_rec.last_updated_by;
1739: END IF;
1740: IF (x_opt_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1740: IF (x_opt_rec.last_update_date = OKC_API.G_MISS_DATE)

1736: IF (x_opt_rec.last_updated_by = OKC_API.G_MISS_NUM)
1737: THEN
1738: x_opt_rec.last_updated_by := l_opt_rec.last_updated_by;
1739: END IF;
1740: IF (x_opt_rec.last_update_date = OKC_API.G_MISS_DATE)
1741: THEN
1742: x_opt_rec.last_update_date := l_opt_rec.last_update_date;
1743: END IF;
1744: IF (x_opt_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1744: IF (x_opt_rec.last_update_login = OKC_API.G_MISS_NUM)

1740: IF (x_opt_rec.last_update_date = OKC_API.G_MISS_DATE)
1741: THEN
1742: x_opt_rec.last_update_date := l_opt_rec.last_update_date;
1743: END IF;
1744: IF (x_opt_rec.last_update_login = OKC_API.G_MISS_NUM)
1745: THEN
1746: x_opt_rec.last_update_login := l_opt_rec.last_update_login;
1747: END IF;
1748: RETURN(l_return_status);

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

1753: FUNCTION Set_Attributes (
1754: p_opt_rec IN opt_rec_type,
1755: x_opt_rec OUT NOCOPY opt_rec_type
1756: ) RETURN VARCHAR2 IS
1757: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1758: BEGIN
1759: x_opt_rec := p_opt_rec;
1760: RETURN(l_return_status);
1761: END Set_Attributes;

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

1759: x_opt_rec := p_opt_rec;
1760: RETURN(l_return_status);
1761: END Set_Attributes;
1762: BEGIN
1763: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1764: p_init_msg_list,
1765: '_PVT',
1766: x_return_status);
1767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

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

Line 1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1770: RAISE OKC_API.G_EXCEPTION_ERROR;

1766: x_return_status);
1767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1770: RAISE OKC_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: --- Setting item attributes
1773: l_return_status := Set_Attributes(
1774: p_opt_rec, -- IN

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

1773: l_return_status := Set_Attributes(
1774: p_opt_rec, -- IN
1775: l_opt_rec); -- OUT
1776: --- If any errors happen abort API
1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1780: RAISE OKC_API.G_EXCEPTION_ERROR;
1781: END IF;

Line 1778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1774: p_opt_rec, -- IN
1775: l_opt_rec); -- OUT
1776: --- If any errors happen abort API
1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1780: RAISE OKC_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);

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

1775: l_opt_rec); -- OUT
1776: --- If any errors happen abort API
1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1780: RAISE OKC_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);
1783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1780: RAISE OKC_API.G_EXCEPTION_ERROR;

1776: --- If any errors happen abort API
1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1779: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1780: RAISE OKC_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);
1783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1779: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1780: RAISE OKC_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);
1783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;

Line 1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1780: RAISE OKC_API.G_EXCEPTION_ERROR;
1781: END IF;
1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);
1783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: UPDATE OKL_OPTIONS

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

1781: END IF;
1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);
1783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: UPDATE OKL_OPTIONS
1789: SET NAME = l_def_opt_rec.name,

Line 1786: RAISE OKC_API.G_EXCEPTION_ERROR;

1782: l_return_status := populate_new_record(l_opt_rec, l_def_opt_rec);
1783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: UPDATE OKL_OPTIONS
1789: SET NAME = l_def_opt_rec.name,
1790: OBJECT_VERSION_NUMBER = l_def_opt_rec.object_version_number,

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

1814: LAST_UPDATE_LOGIN = l_def_opt_rec.last_update_login
1815: WHERE ID = l_def_opt_rec.id;
1816:
1817: x_opt_rec := l_def_opt_rec;
1818: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1819: EXCEPTION
1820: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1822: (

Line 1820: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1816:
1817: x_opt_rec := l_def_opt_rec;
1818: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1819: EXCEPTION
1820: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1822: (
1823: l_api_name,
1824: G_PKG_NAME,

Line 1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1817: x_opt_rec := l_def_opt_rec;
1818: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1819: EXCEPTION
1820: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1822: (
1823: l_api_name,
1824: G_PKG_NAME,
1825: 'OKC_API.G_RET_STS_ERROR',

Line 1825: 'OKC_API.G_RET_STS_ERROR',

1821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1822: (
1823: l_api_name,
1824: G_PKG_NAME,
1825: 'OKC_API.G_RET_STS_ERROR',
1826: x_msg_count,
1827: x_msg_data,
1828: '_PVT'
1829: );

Line 1830: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1826: x_msg_count,
1827: x_msg_data,
1828: '_PVT'
1829: );
1830: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1831: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,

Line 1831: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1827: x_msg_data,
1828: '_PVT'
1829: );
1830: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1831: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,
1835: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1835: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1831: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,
1835: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1836: x_msg_count,
1837: x_msg_data,
1838: '_PVT'
1839: );

Line 1841: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1837: x_msg_data,
1838: '_PVT'
1839: );
1840: WHEN OTHERS THEN
1841: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1842: (
1843: l_api_name,
1844: G_PKG_NAME,
1845: 'OTHERS',

Line 1856: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1852: -- update_row for:OKL_OPTIONS_V --
1853: ----------------------------------
1854: PROCEDURE update_row(
1855: p_api_version IN NUMBER,
1856: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1857: x_return_status OUT NOCOPY VARCHAR2,
1858: x_msg_count OUT NOCOPY NUMBER,
1859: x_msg_data OUT NOCOPY VARCHAR2,
1860: p_optv_rec IN optv_rec_type,

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

1861: x_optv_rec OUT NOCOPY optv_rec_type) IS
1862:
1863: l_api_version CONSTANT NUMBER := 1;
1864: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1865: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1866: l_optv_rec optv_rec_type := p_optv_rec;
1867: l_def_optv_rec optv_rec_type;
1868: l_opt_rec opt_rec_type;
1869: lx_opt_rec opt_rec_type;

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

1888: x_optv_rec OUT NOCOPY optv_rec_type
1889: ) RETURN VARCHAR2 IS
1890: l_optv_rec optv_rec_type;
1891: l_row_notfound BOOLEAN := TRUE;
1892: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1893: BEGIN
1894: x_optv_rec := p_optv_rec;
1895: -- Get current database values
1896: l_optv_rec := get_rec(p_optv_rec, l_row_notfound);

Line 1898: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1894: x_optv_rec := p_optv_rec;
1895: -- Get current database values
1896: l_optv_rec := get_rec(p_optv_rec, l_row_notfound);
1897: IF (l_row_notfound) THEN
1898: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1899: END IF;
1900: IF (x_optv_rec.id = OKC_API.G_MISS_NUM)
1901: THEN
1902: x_optv_rec.id := l_optv_rec.id;

Line 1900: IF (x_optv_rec.id = OKC_API.G_MISS_NUM)

1896: l_optv_rec := get_rec(p_optv_rec, l_row_notfound);
1897: IF (l_row_notfound) THEN
1898: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1899: END IF;
1900: IF (x_optv_rec.id = OKC_API.G_MISS_NUM)
1901: THEN
1902: x_optv_rec.id := l_optv_rec.id;
1903: END IF;
1904: IF (x_optv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1904: IF (x_optv_rec.object_version_number = OKC_API.G_MISS_NUM)

1900: IF (x_optv_rec.id = OKC_API.G_MISS_NUM)
1901: THEN
1902: x_optv_rec.id := l_optv_rec.id;
1903: END IF;
1904: IF (x_optv_rec.object_version_number = OKC_API.G_MISS_NUM)
1905: THEN
1906: x_optv_rec.object_version_number := l_optv_rec.object_version_number;
1907: END IF;
1908: IF (x_optv_rec.name = OKC_API.G_MISS_CHAR)

Line 1908: IF (x_optv_rec.name = OKC_API.G_MISS_CHAR)

1904: IF (x_optv_rec.object_version_number = OKC_API.G_MISS_NUM)
1905: THEN
1906: x_optv_rec.object_version_number := l_optv_rec.object_version_number;
1907: END IF;
1908: IF (x_optv_rec.name = OKC_API.G_MISS_CHAR)
1909: THEN
1910: x_optv_rec.name := l_optv_rec.name;
1911: END IF;
1912: IF (x_optv_rec.description = OKC_API.G_MISS_CHAR)

Line 1912: IF (x_optv_rec.description = OKC_API.G_MISS_CHAR)

1908: IF (x_optv_rec.name = OKC_API.G_MISS_CHAR)
1909: THEN
1910: x_optv_rec.name := l_optv_rec.name;
1911: END IF;
1912: IF (x_optv_rec.description = OKC_API.G_MISS_CHAR)
1913: THEN
1914: x_optv_rec.description := l_optv_rec.description;
1915: END IF;
1916: IF (x_optv_rec.from_date = OKC_API.G_MISS_DATE)

Line 1916: IF (x_optv_rec.from_date = OKC_API.G_MISS_DATE)

1912: IF (x_optv_rec.description = OKC_API.G_MISS_CHAR)
1913: THEN
1914: x_optv_rec.description := l_optv_rec.description;
1915: END IF;
1916: IF (x_optv_rec.from_date = OKC_API.G_MISS_DATE)
1917: THEN
1918: x_optv_rec.from_date := l_optv_rec.from_date;
1919: END IF;
1920: IF (x_optv_rec.TO_DATE = OKC_API.G_MISS_DATE)

Line 1920: IF (x_optv_rec.TO_DATE = OKC_API.G_MISS_DATE)

1916: IF (x_optv_rec.from_date = OKC_API.G_MISS_DATE)
1917: THEN
1918: x_optv_rec.from_date := l_optv_rec.from_date;
1919: END IF;
1920: IF (x_optv_rec.TO_DATE = OKC_API.G_MISS_DATE)
1921: THEN
1922: x_optv_rec.TO_DATE := l_optv_rec.TO_DATE;
1923: END IF;
1924: IF (x_optv_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 1924: IF (x_optv_rec.attribute_category = OKC_API.G_MISS_CHAR)

1920: IF (x_optv_rec.TO_DATE = OKC_API.G_MISS_DATE)
1921: THEN
1922: x_optv_rec.TO_DATE := l_optv_rec.TO_DATE;
1923: END IF;
1924: IF (x_optv_rec.attribute_category = OKC_API.G_MISS_CHAR)
1925: THEN
1926: x_optv_rec.attribute_category := l_optv_rec.attribute_category;
1927: END IF;
1928: IF (x_optv_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 1928: IF (x_optv_rec.attribute1 = OKC_API.G_MISS_CHAR)

1924: IF (x_optv_rec.attribute_category = OKC_API.G_MISS_CHAR)
1925: THEN
1926: x_optv_rec.attribute_category := l_optv_rec.attribute_category;
1927: END IF;
1928: IF (x_optv_rec.attribute1 = OKC_API.G_MISS_CHAR)
1929: THEN
1930: x_optv_rec.attribute1 := l_optv_rec.attribute1;
1931: END IF;
1932: IF (x_optv_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 1932: IF (x_optv_rec.attribute2 = OKC_API.G_MISS_CHAR)

1928: IF (x_optv_rec.attribute1 = OKC_API.G_MISS_CHAR)
1929: THEN
1930: x_optv_rec.attribute1 := l_optv_rec.attribute1;
1931: END IF;
1932: IF (x_optv_rec.attribute2 = OKC_API.G_MISS_CHAR)
1933: THEN
1934: x_optv_rec.attribute2 := l_optv_rec.attribute2;
1935: END IF;
1936: IF (x_optv_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 1936: IF (x_optv_rec.attribute3 = OKC_API.G_MISS_CHAR)

1932: IF (x_optv_rec.attribute2 = OKC_API.G_MISS_CHAR)
1933: THEN
1934: x_optv_rec.attribute2 := l_optv_rec.attribute2;
1935: END IF;
1936: IF (x_optv_rec.attribute3 = OKC_API.G_MISS_CHAR)
1937: THEN
1938: x_optv_rec.attribute3 := l_optv_rec.attribute3;
1939: END IF;
1940: IF (x_optv_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 1940: IF (x_optv_rec.attribute4 = OKC_API.G_MISS_CHAR)

1936: IF (x_optv_rec.attribute3 = OKC_API.G_MISS_CHAR)
1937: THEN
1938: x_optv_rec.attribute3 := l_optv_rec.attribute3;
1939: END IF;
1940: IF (x_optv_rec.attribute4 = OKC_API.G_MISS_CHAR)
1941: THEN
1942: x_optv_rec.attribute4 := l_optv_rec.attribute4;
1943: END IF;
1944: IF (x_optv_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 1944: IF (x_optv_rec.attribute5 = OKC_API.G_MISS_CHAR)

1940: IF (x_optv_rec.attribute4 = OKC_API.G_MISS_CHAR)
1941: THEN
1942: x_optv_rec.attribute4 := l_optv_rec.attribute4;
1943: END IF;
1944: IF (x_optv_rec.attribute5 = OKC_API.G_MISS_CHAR)
1945: THEN
1946: x_optv_rec.attribute5 := l_optv_rec.attribute5;
1947: END IF;
1948: IF (x_optv_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 1948: IF (x_optv_rec.attribute6 = OKC_API.G_MISS_CHAR)

1944: IF (x_optv_rec.attribute5 = OKC_API.G_MISS_CHAR)
1945: THEN
1946: x_optv_rec.attribute5 := l_optv_rec.attribute5;
1947: END IF;
1948: IF (x_optv_rec.attribute6 = OKC_API.G_MISS_CHAR)
1949: THEN
1950: x_optv_rec.attribute6 := l_optv_rec.attribute6;
1951: END IF;
1952: IF (x_optv_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 1952: IF (x_optv_rec.attribute7 = OKC_API.G_MISS_CHAR)

1948: IF (x_optv_rec.attribute6 = OKC_API.G_MISS_CHAR)
1949: THEN
1950: x_optv_rec.attribute6 := l_optv_rec.attribute6;
1951: END IF;
1952: IF (x_optv_rec.attribute7 = OKC_API.G_MISS_CHAR)
1953: THEN
1954: x_optv_rec.attribute7 := l_optv_rec.attribute7;
1955: END IF;
1956: IF (x_optv_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 1956: IF (x_optv_rec.attribute8 = OKC_API.G_MISS_CHAR)

1952: IF (x_optv_rec.attribute7 = OKC_API.G_MISS_CHAR)
1953: THEN
1954: x_optv_rec.attribute7 := l_optv_rec.attribute7;
1955: END IF;
1956: IF (x_optv_rec.attribute8 = OKC_API.G_MISS_CHAR)
1957: THEN
1958: x_optv_rec.attribute8 := l_optv_rec.attribute8;
1959: END IF;
1960: IF (x_optv_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 1960: IF (x_optv_rec.attribute9 = OKC_API.G_MISS_CHAR)

1956: IF (x_optv_rec.attribute8 = OKC_API.G_MISS_CHAR)
1957: THEN
1958: x_optv_rec.attribute8 := l_optv_rec.attribute8;
1959: END IF;
1960: IF (x_optv_rec.attribute9 = OKC_API.G_MISS_CHAR)
1961: THEN
1962: x_optv_rec.attribute9 := l_optv_rec.attribute9;
1963: END IF;
1964: IF (x_optv_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 1964: IF (x_optv_rec.attribute10 = OKC_API.G_MISS_CHAR)

1960: IF (x_optv_rec.attribute9 = OKC_API.G_MISS_CHAR)
1961: THEN
1962: x_optv_rec.attribute9 := l_optv_rec.attribute9;
1963: END IF;
1964: IF (x_optv_rec.attribute10 = OKC_API.G_MISS_CHAR)
1965: THEN
1966: x_optv_rec.attribute10 := l_optv_rec.attribute10;
1967: END IF;
1968: IF (x_optv_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 1968: IF (x_optv_rec.attribute11 = OKC_API.G_MISS_CHAR)

1964: IF (x_optv_rec.attribute10 = OKC_API.G_MISS_CHAR)
1965: THEN
1966: x_optv_rec.attribute10 := l_optv_rec.attribute10;
1967: END IF;
1968: IF (x_optv_rec.attribute11 = OKC_API.G_MISS_CHAR)
1969: THEN
1970: x_optv_rec.attribute11 := l_optv_rec.attribute11;
1971: END IF;
1972: IF (x_optv_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 1972: IF (x_optv_rec.attribute12 = OKC_API.G_MISS_CHAR)

1968: IF (x_optv_rec.attribute11 = OKC_API.G_MISS_CHAR)
1969: THEN
1970: x_optv_rec.attribute11 := l_optv_rec.attribute11;
1971: END IF;
1972: IF (x_optv_rec.attribute12 = OKC_API.G_MISS_CHAR)
1973: THEN
1974: x_optv_rec.attribute12 := l_optv_rec.attribute12;
1975: END IF;
1976: IF (x_optv_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 1976: IF (x_optv_rec.attribute13 = OKC_API.G_MISS_CHAR)

1972: IF (x_optv_rec.attribute12 = OKC_API.G_MISS_CHAR)
1973: THEN
1974: x_optv_rec.attribute12 := l_optv_rec.attribute12;
1975: END IF;
1976: IF (x_optv_rec.attribute13 = OKC_API.G_MISS_CHAR)
1977: THEN
1978: x_optv_rec.attribute13 := l_optv_rec.attribute13;
1979: END IF;
1980: IF (x_optv_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 1980: IF (x_optv_rec.attribute14 = OKC_API.G_MISS_CHAR)

1976: IF (x_optv_rec.attribute13 = OKC_API.G_MISS_CHAR)
1977: THEN
1978: x_optv_rec.attribute13 := l_optv_rec.attribute13;
1979: END IF;
1980: IF (x_optv_rec.attribute14 = OKC_API.G_MISS_CHAR)
1981: THEN
1982: x_optv_rec.attribute14 := l_optv_rec.attribute14;
1983: END IF;
1984: IF (x_optv_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 1984: IF (x_optv_rec.attribute15 = OKC_API.G_MISS_CHAR)

1980: IF (x_optv_rec.attribute14 = OKC_API.G_MISS_CHAR)
1981: THEN
1982: x_optv_rec.attribute14 := l_optv_rec.attribute14;
1983: END IF;
1984: IF (x_optv_rec.attribute15 = OKC_API.G_MISS_CHAR)
1985: THEN
1986: x_optv_rec.attribute15 := l_optv_rec.attribute15;
1987: END IF;
1988: IF (x_optv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1988: IF (x_optv_rec.created_by = OKC_API.G_MISS_NUM)

1984: IF (x_optv_rec.attribute15 = OKC_API.G_MISS_CHAR)
1985: THEN
1986: x_optv_rec.attribute15 := l_optv_rec.attribute15;
1987: END IF;
1988: IF (x_optv_rec.created_by = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_optv_rec.created_by := l_optv_rec.created_by;
1991: END IF;
1992: IF (x_optv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1992: IF (x_optv_rec.creation_date = OKC_API.G_MISS_DATE)

1988: IF (x_optv_rec.created_by = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_optv_rec.created_by := l_optv_rec.created_by;
1991: END IF;
1992: IF (x_optv_rec.creation_date = OKC_API.G_MISS_DATE)
1993: THEN
1994: x_optv_rec.creation_date := l_optv_rec.creation_date;
1995: END IF;
1996: IF (x_optv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1996: IF (x_optv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1992: IF (x_optv_rec.creation_date = OKC_API.G_MISS_DATE)
1993: THEN
1994: x_optv_rec.creation_date := l_optv_rec.creation_date;
1995: END IF;
1996: IF (x_optv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1997: THEN
1998: x_optv_rec.last_updated_by := l_optv_rec.last_updated_by;
1999: END IF;
2000: IF (x_optv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2000: IF (x_optv_rec.last_update_date = OKC_API.G_MISS_DATE)

1996: IF (x_optv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1997: THEN
1998: x_optv_rec.last_updated_by := l_optv_rec.last_updated_by;
1999: END IF;
2000: IF (x_optv_rec.last_update_date = OKC_API.G_MISS_DATE)
2001: THEN
2002: x_optv_rec.last_update_date := l_optv_rec.last_update_date;
2003: END IF;
2004: IF (x_optv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2004: IF (x_optv_rec.last_update_login = OKC_API.G_MISS_NUM)

2000: IF (x_optv_rec.last_update_date = OKC_API.G_MISS_DATE)
2001: THEN
2002: x_optv_rec.last_update_date := l_optv_rec.last_update_date;
2003: END IF;
2004: IF (x_optv_rec.last_update_login = OKC_API.G_MISS_NUM)
2005: THEN
2006: x_optv_rec.last_update_login := l_optv_rec.last_update_login;
2007: END IF;
2008: RETURN(l_return_status);

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

2013: FUNCTION Set_Attributes (
2014: p_optv_rec IN optv_rec_type,
2015: x_optv_rec OUT NOCOPY optv_rec_type
2016: ) RETURN VARCHAR2 IS
2017: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2018: BEGIN
2019: x_optv_rec := p_optv_rec;
2020: x_optv_rec.OBJECT_VERSION_NUMBER := NVL(x_optv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2021: RETURN(l_return_status);

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

2020: x_optv_rec.OBJECT_VERSION_NUMBER := NVL(x_optv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2021: RETURN(l_return_status);
2022: END Set_Attributes;
2023: BEGIN
2024: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2025: G_PKG_NAME,
2026: p_init_msg_list,
2027: l_api_version,
2028: p_api_version,

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

2027: l_api_version,
2028: p_api_version,
2029: '_PVT',
2030: x_return_status);
2031: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2033: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2034: RAISE OKC_API.G_EXCEPTION_ERROR;
2035: END IF;

Line 2032: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2028: p_api_version,
2029: '_PVT',
2030: x_return_status);
2031: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2033: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2034: RAISE OKC_API.G_EXCEPTION_ERROR;
2035: END IF;
2036: --- Setting item attributes

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

2029: '_PVT',
2030: x_return_status);
2031: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2033: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2034: RAISE OKC_API.G_EXCEPTION_ERROR;
2035: END IF;
2036: --- Setting item attributes
2037: l_return_status := Set_Attributes(

Line 2034: RAISE OKC_API.G_EXCEPTION_ERROR;

2030: x_return_status);
2031: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2033: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2034: RAISE OKC_API.G_EXCEPTION_ERROR;
2035: END IF;
2036: --- Setting item attributes
2037: l_return_status := Set_Attributes(
2038: p_optv_rec, -- IN

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

2037: l_return_status := Set_Attributes(
2038: p_optv_rec, -- IN
2039: l_optv_rec); -- OUT
2040: --- If any errors happen abort API
2041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;

Line 2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2038: p_optv_rec, -- IN
2039: l_optv_rec); -- OUT
2040: --- If any errors happen abort API
2041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);

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

2039: l_optv_rec); -- OUT
2040: --- If any errors happen abort API
2041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);
2047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2044: RAISE OKC_API.G_EXCEPTION_ERROR;

2040: --- If any errors happen abort API
2041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);
2047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);
2047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2050: RAISE OKC_API.G_EXCEPTION_ERROR;
2051: END IF;

Line 2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2044: RAISE OKC_API.G_EXCEPTION_ERROR;
2045: END IF;
2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);
2047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2050: RAISE OKC_API.G_EXCEPTION_ERROR;
2051: END IF;
2052: l_def_optv_rec := fill_who_columns(l_def_optv_rec);

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

2045: END IF;
2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);
2047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2050: RAISE OKC_API.G_EXCEPTION_ERROR;
2051: END IF;
2052: l_def_optv_rec := fill_who_columns(l_def_optv_rec);
2053: --- Validate all non-missing attributes (Item Level Validation)

Line 2050: RAISE OKC_API.G_EXCEPTION_ERROR;

2046: l_return_status := populate_new_record(l_optv_rec, l_def_optv_rec);
2047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2050: RAISE OKC_API.G_EXCEPTION_ERROR;
2051: END IF;
2052: l_def_optv_rec := fill_who_columns(l_def_optv_rec);
2053: --- Validate all non-missing attributes (Item Level Validation)
2054: l_return_status := Validate_Attributes(l_def_optv_rec);

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

2052: l_def_optv_rec := fill_who_columns(l_def_optv_rec);
2053: --- Validate all non-missing attributes (Item Level Validation)
2054: l_return_status := Validate_Attributes(l_def_optv_rec);
2055: --- If any errors happen abort API
2056: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2059: RAISE OKC_API.G_EXCEPTION_ERROR;
2060: END IF;

Line 2057: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2053: --- Validate all non-missing attributes (Item Level Validation)
2054: l_return_status := Validate_Attributes(l_def_optv_rec);
2055: --- If any errors happen abort API
2056: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2059: RAISE OKC_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_return_status := Validate_Record(l_def_optv_rec);

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

2054: l_return_status := Validate_Attributes(l_def_optv_rec);
2055: --- If any errors happen abort API
2056: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2059: RAISE OKC_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_return_status := Validate_Record(l_def_optv_rec);
2062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2059: RAISE OKC_API.G_EXCEPTION_ERROR;

2055: --- If any errors happen abort API
2056: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2059: RAISE OKC_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_return_status := Validate_Record(l_def_optv_rec);
2062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2058: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2059: RAISE OKC_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_return_status := Validate_Record(l_def_optv_rec);
2062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_ERROR;
2066: END IF;

Line 2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2059: RAISE OKC_API.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_return_status := Validate_Record(l_def_optv_rec);
2062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_ERROR;
2066: END IF;
2067:

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

2060: END IF;
2061: l_return_status := Validate_Record(l_def_optv_rec);
2062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_ERROR;
2066: END IF;
2067:
2068: --------------------------------------

Line 2065: RAISE OKC_API.G_EXCEPTION_ERROR;

2061: l_return_status := Validate_Record(l_def_optv_rec);
2062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_ERROR;
2066: END IF;
2067:
2068: --------------------------------------
2069: -- Move VIEW record to "Child" records

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

2079: x_msg_data,
2080: l_opt_rec,
2081: lx_opt_rec
2082: );
2083: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;

Line 2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2080: l_opt_rec,
2081: lx_opt_rec
2082: );
2083: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: migrate(lx_opt_rec, l_def_optv_rec);

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

2081: lx_opt_rec
2082: );
2083: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: migrate(lx_opt_rec, l_def_optv_rec);
2089: x_optv_rec := l_def_optv_rec;

Line 2086: RAISE OKC_API.G_EXCEPTION_ERROR;

2082: );
2083: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: migrate(lx_opt_rec, l_def_optv_rec);
2089: x_optv_rec := l_def_optv_rec;
2090: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: migrate(lx_opt_rec, l_def_optv_rec);
2089: x_optv_rec := l_def_optv_rec;
2090: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2091: EXCEPTION
2092: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2093: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2094: (

Line 2092: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2088: migrate(lx_opt_rec, l_def_optv_rec);
2089: x_optv_rec := l_def_optv_rec;
2090: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2091: EXCEPTION
2092: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2093: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2094: (
2095: l_api_name,
2096: G_PKG_NAME,

Line 2093: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2089: x_optv_rec := l_def_optv_rec;
2090: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2091: EXCEPTION
2092: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2093: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2094: (
2095: l_api_name,
2096: G_PKG_NAME,
2097: 'OKC_API.G_RET_STS_ERROR',

Line 2097: 'OKC_API.G_RET_STS_ERROR',

2093: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2094: (
2095: l_api_name,
2096: G_PKG_NAME,
2097: 'OKC_API.G_RET_STS_ERROR',
2098: x_msg_count,
2099: x_msg_data,
2100: '_PVT'
2101: );

Line 2102: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2098: x_msg_count,
2099: x_msg_data,
2100: '_PVT'
2101: );
2102: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2103: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,

Line 2103: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2099: x_msg_data,
2100: '_PVT'
2101: );
2102: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2103: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,
2107: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2107: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2103: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,
2107: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2108: x_msg_count,
2109: x_msg_data,
2110: '_PVT'
2111: );

Line 2113: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2109: x_msg_data,
2110: '_PVT'
2111: );
2112: WHEN OTHERS THEN
2113: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,
2117: 'OTHERS',

Line 2128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2124: -- PL/SQL TBL update_row for:OPTV_TBL --
2125: ----------------------------------------
2126: PROCEDURE update_row(
2127: p_api_version IN NUMBER,
2128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2129: x_return_status OUT NOCOPY VARCHAR2,
2130: x_msg_count OUT NOCOPY NUMBER,
2131: x_msg_data OUT NOCOPY VARCHAR2,
2132: p_optv_tbl IN optv_tbl_type,

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

2133: x_optv_tbl OUT NOCOPY optv_tbl_type) IS
2134:
2135: l_api_version CONSTANT NUMBER := 1;
2136: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
2139: i NUMBER := 0;
2140: BEGIN
2141: OKC_API.init_msg_list(p_init_msg_list);

Line 2138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS

2134:
2135: l_api_version CONSTANT NUMBER := 1;
2136: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
2139: i NUMBER := 0;
2140: BEGIN
2141: OKC_API.init_msg_list(p_init_msg_list);
2142: -- Make sure PL/SQL table has records in it before passing

Line 2141: OKC_API.init_msg_list(p_init_msg_list);

2137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
2139: i NUMBER := 0;
2140: BEGIN
2141: OKC_API.init_msg_list(p_init_msg_list);
2142: -- Make sure PL/SQL table has records in it before passing
2143: IF (p_optv_tbl.COUNT > 0) THEN
2144: i := p_optv_tbl.FIRST;
2145: LOOP

Line 2148: p_init_msg_list => OKC_API.G_FALSE,

2144: i := p_optv_tbl.FIRST;
2145: LOOP
2146: update_row (
2147: p_api_version => p_api_version,
2148: p_init_msg_list => OKC_API.G_FALSE,
2149: x_return_status => x_return_status,
2150: x_msg_count => x_msg_count,
2151: x_msg_data => x_msg_data,
2152: p_optv_rec => p_optv_tbl(i),

Line 2155: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2151: x_msg_data => x_msg_data,
2152: p_optv_rec => p_optv_tbl(i),
2153: x_optv_rec => x_optv_tbl(i));
2154: -- TCHGS: Store the highest degree of error
2155: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2156: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2157: l_overall_status := x_return_status;
2158: END IF;
2159: END IF;

Line 2156: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2152: p_optv_rec => p_optv_tbl(i),
2153: x_optv_rec => x_optv_tbl(i));
2154: -- TCHGS: Store the highest degree of error
2155: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2156: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2157: l_overall_status := x_return_status;
2158: END IF;
2159: END IF;
2160: EXIT WHEN (i = p_optv_tbl.LAST);

Line 2167: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2163: --TCHGS: return overall status
2164: x_return_status := l_overall_status;
2165: END IF;
2166: EXCEPTION
2167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2169: (
2170: l_api_name,
2171: G_PKG_NAME,

Line 2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2164: x_return_status := l_overall_status;
2165: END IF;
2166: EXCEPTION
2167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2169: (
2170: l_api_name,
2171: G_PKG_NAME,
2172: 'OKC_API.G_RET_STS_ERROR',

Line 2172: 'OKC_API.G_RET_STS_ERROR',

2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2169: (
2170: l_api_name,
2171: G_PKG_NAME,
2172: 'OKC_API.G_RET_STS_ERROR',
2173: x_msg_count,
2174: x_msg_data,
2175: '_PVT'
2176: );

Line 2177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2173: x_msg_count,
2174: x_msg_data,
2175: '_PVT'
2176: );
2177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2179: (
2180: l_api_name,
2181: G_PKG_NAME,

Line 2178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2174: x_msg_data,
2175: '_PVT'
2176: );
2177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2179: (
2180: l_api_name,
2181: G_PKG_NAME,
2182: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2182: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2179: (
2180: l_api_name,
2181: G_PKG_NAME,
2182: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2183: x_msg_count,
2184: x_msg_data,
2185: '_PVT'
2186: );

Line 2188: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2184: x_msg_data,
2185: '_PVT'
2186: );
2187: WHEN OTHERS THEN
2188: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2189: (
2190: l_api_name,
2191: G_PKG_NAME,
2192: 'OTHERS',

Line 2206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2202: --------------------------------
2203: -- delete_row for:OKL_OPTIONS --
2204: --------------------------------
2205: PROCEDURE delete_row(
2206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2207: x_return_status OUT NOCOPY VARCHAR2,
2208: x_msg_count OUT NOCOPY NUMBER,
2209: x_msg_data OUT NOCOPY VARCHAR2,
2210: p_opt_rec IN opt_rec_type) IS

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

2210: p_opt_rec IN opt_rec_type) IS
2211:
2212: l_api_version CONSTANT NUMBER := 1;
2213: l_api_name CONSTANT VARCHAR2(30) := 'OPTIONS_delete_row';
2214: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2215: l_opt_rec opt_rec_type:= p_opt_rec;
2216: l_row_notfound BOOLEAN := TRUE;
2217: BEGIN
2218: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2214: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2215: l_opt_rec opt_rec_type:= p_opt_rec;
2216: l_row_notfound BOOLEAN := TRUE;
2217: BEGIN
2218: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2219: p_init_msg_list,
2220: '_PVT',
2221: x_return_status);
2222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2218: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2219: p_init_msg_list,
2220: '_PVT',
2221: x_return_status);
2222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_ERROR;
2226: END IF;

Line 2223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2219: p_init_msg_list,
2220: '_PVT',
2221: x_return_status);
2222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_ERROR;
2226: END IF;
2227: DELETE FROM OKL_OPTIONS

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

2220: '_PVT',
2221: x_return_status);
2222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_ERROR;
2226: END IF;
2227: DELETE FROM OKL_OPTIONS
2228: WHERE ID = l_opt_rec.id;

Line 2225: RAISE OKC_API.G_EXCEPTION_ERROR;

2221: x_return_status);
2222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_ERROR;
2226: END IF;
2227: DELETE FROM OKL_OPTIONS
2228: WHERE ID = l_opt_rec.id;
2229:

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

2226: END IF;
2227: DELETE FROM OKL_OPTIONS
2228: WHERE ID = l_opt_rec.id;
2229:
2230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2231: EXCEPTION
2232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2234: (

Line 2232: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2228: WHERE ID = l_opt_rec.id;
2229:
2230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2231: EXCEPTION
2232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2234: (
2235: l_api_name,
2236: G_PKG_NAME,

Line 2233: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2229:
2230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2231: EXCEPTION
2232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2234: (
2235: l_api_name,
2236: G_PKG_NAME,
2237: 'OKC_API.G_RET_STS_ERROR',

Line 2237: 'OKC_API.G_RET_STS_ERROR',

2233: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2234: (
2235: l_api_name,
2236: G_PKG_NAME,
2237: 'OKC_API.G_RET_STS_ERROR',
2238: x_msg_count,
2239: x_msg_data,
2240: '_PVT'
2241: );

Line 2242: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2238: x_msg_count,
2239: x_msg_data,
2240: '_PVT'
2241: );
2242: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2243: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2244: (
2245: l_api_name,
2246: G_PKG_NAME,

Line 2243: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2239: x_msg_data,
2240: '_PVT'
2241: );
2242: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2243: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2244: (
2245: l_api_name,
2246: G_PKG_NAME,
2247: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2247: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2243: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2244: (
2245: l_api_name,
2246: G_PKG_NAME,
2247: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2248: x_msg_count,
2249: x_msg_data,
2250: '_PVT'
2251: );

Line 2253: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2249: x_msg_data,
2250: '_PVT'
2251: );
2252: WHEN OTHERS THEN
2253: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2254: (
2255: l_api_name,
2256: G_PKG_NAME,
2257: 'OTHERS',

Line 2268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2264: -- delete_row for:OKL_OPTIONS_V --
2265: ----------------------------------
2266: PROCEDURE delete_row(
2267: p_api_version IN NUMBER,
2268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2269: x_return_status OUT NOCOPY VARCHAR2,
2270: x_msg_count OUT NOCOPY NUMBER,
2271: x_msg_data OUT NOCOPY VARCHAR2,
2272: p_optv_rec IN optv_rec_type) IS

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

2272: p_optv_rec IN optv_rec_type) IS
2273:
2274: l_api_version CONSTANT NUMBER := 1;
2275: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2276: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2277: l_optv_rec optv_rec_type := p_optv_rec;
2278: l_opt_rec opt_rec_type;
2279: BEGIN
2280: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2276: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2277: l_optv_rec optv_rec_type := p_optv_rec;
2278: l_opt_rec opt_rec_type;
2279: BEGIN
2280: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2281: G_PKG_NAME,
2282: p_init_msg_list,
2283: l_api_version,
2284: p_api_version,

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

2283: l_api_version,
2284: p_api_version,
2285: '_PVT',
2286: x_return_status);
2287: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2289: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_ERROR;
2291: END IF;

Line 2288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2284: p_api_version,
2285: '_PVT',
2286: x_return_status);
2287: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2289: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_ERROR;
2291: END IF;
2292: --------------------------------------

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

2285: '_PVT',
2286: x_return_status);
2287: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2289: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_ERROR;
2291: END IF;
2292: --------------------------------------
2293: -- Move VIEW record to "Child" records

Line 2290: RAISE OKC_API.G_EXCEPTION_ERROR;

2286: x_return_status);
2287: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2289: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_ERROR;
2291: END IF;
2292: --------------------------------------
2293: -- Move VIEW record to "Child" records
2294: --------------------------------------

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

2302: x_msg_count,
2303: x_msg_data,
2304: l_opt_rec
2305: );
2306: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2309: RAISE OKC_API.G_EXCEPTION_ERROR;
2310: END IF;

Line 2307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2303: x_msg_data,
2304: l_opt_rec
2305: );
2306: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2309: RAISE OKC_API.G_EXCEPTION_ERROR;
2310: END IF;
2311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2304: l_opt_rec
2305: );
2306: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2309: RAISE OKC_API.G_EXCEPTION_ERROR;
2310: END IF;
2311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2312: EXCEPTION

Line 2309: RAISE OKC_API.G_EXCEPTION_ERROR;

2305: );
2306: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2309: RAISE OKC_API.G_EXCEPTION_ERROR;
2310: END IF;
2311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2312: EXCEPTION
2313: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2309: RAISE OKC_API.G_EXCEPTION_ERROR;
2310: END IF;
2311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2312: EXCEPTION
2313: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2315: (

Line 2313: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2309: RAISE OKC_API.G_EXCEPTION_ERROR;
2310: END IF;
2311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2312: EXCEPTION
2313: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2315: (
2316: l_api_name,
2317: G_PKG_NAME,

Line 2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2310: END IF;
2311: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2312: EXCEPTION
2313: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2315: (
2316: l_api_name,
2317: G_PKG_NAME,
2318: 'OKC_API.G_RET_STS_ERROR',

Line 2318: 'OKC_API.G_RET_STS_ERROR',

2314: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2315: (
2316: l_api_name,
2317: G_PKG_NAME,
2318: 'OKC_API.G_RET_STS_ERROR',
2319: x_msg_count,
2320: x_msg_data,
2321: '_PVT'
2322: );

Line 2323: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2319: x_msg_count,
2320: x_msg_data,
2321: '_PVT'
2322: );
2323: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2324: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2325: (
2326: l_api_name,
2327: G_PKG_NAME,

Line 2324: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2320: x_msg_data,
2321: '_PVT'
2322: );
2323: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2324: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2325: (
2326: l_api_name,
2327: G_PKG_NAME,
2328: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2328: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2324: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2325: (
2326: l_api_name,
2327: G_PKG_NAME,
2328: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2329: x_msg_count,
2330: x_msg_data,
2331: '_PVT'
2332: );

Line 2334: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2330: x_msg_data,
2331: '_PVT'
2332: );
2333: WHEN OTHERS THEN
2334: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2335: (
2336: l_api_name,
2337: G_PKG_NAME,
2338: 'OTHERS',

Line 2349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2345: -- PL/SQL TBL delete_row for:OPTV_TBL --
2346: ----------------------------------------
2347: PROCEDURE delete_row(
2348: p_api_version IN NUMBER,
2349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2350: x_return_status OUT NOCOPY VARCHAR2,
2351: x_msg_count OUT NOCOPY NUMBER,
2352: x_msg_data OUT NOCOPY VARCHAR2,
2353: p_optv_tbl IN optv_tbl_type) IS

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

2353: p_optv_tbl IN optv_tbl_type) IS
2354:
2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2358: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
2359: i NUMBER := 0;
2360: BEGIN
2361: OKC_API.init_msg_list(p_init_msg_list);

Line 2358: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS

2354:
2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2358: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
2359: i NUMBER := 0;
2360: BEGIN
2361: OKC_API.init_msg_list(p_init_msg_list);
2362: -- Make sure PL/SQL table has records in it before passing

Line 2361: OKC_API.init_msg_list(p_init_msg_list);

2357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2358: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS; --TCHGS
2359: i NUMBER := 0;
2360: BEGIN
2361: OKC_API.init_msg_list(p_init_msg_list);
2362: -- Make sure PL/SQL table has records in it before passing
2363: IF (p_optv_tbl.COUNT > 0) THEN
2364: i := p_optv_tbl.FIRST;
2365: LOOP

Line 2368: p_init_msg_list => OKC_API.G_FALSE,

2364: i := p_optv_tbl.FIRST;
2365: LOOP
2366: delete_row (
2367: p_api_version => p_api_version,
2368: p_init_msg_list => OKC_API.G_FALSE,
2369: x_return_status => x_return_status,
2370: x_msg_count => x_msg_count,
2371: x_msg_data => x_msg_data,
2372: p_optv_rec => p_optv_tbl(i));

Line 2374: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2370: x_msg_count => x_msg_count,
2371: x_msg_data => x_msg_data,
2372: p_optv_rec => p_optv_tbl(i));
2373: -- TCHGS: Store the highest degree of error
2374: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2375: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2376: l_overall_status := x_return_status;
2377: END IF;
2378: END IF;

Line 2375: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2371: x_msg_data => x_msg_data,
2372: p_optv_rec => p_optv_tbl(i));
2373: -- TCHGS: Store the highest degree of error
2374: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2375: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2376: l_overall_status := x_return_status;
2377: END IF;
2378: END IF;
2379: EXIT WHEN (i = p_optv_tbl.LAST);

Line 2386: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2382: --TCHGS: return overall status
2383: x_return_status := l_overall_status;
2384: END IF;
2385: EXCEPTION
2386: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,

Line 2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2383: x_return_status := l_overall_status;
2384: END IF;
2385: EXCEPTION
2386: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,
2391: 'OKC_API.G_RET_STS_ERROR',

Line 2391: 'OKC_API.G_RET_STS_ERROR',

2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,
2391: 'OKC_API.G_RET_STS_ERROR',
2392: x_msg_count,
2393: x_msg_data,
2394: '_PVT'
2395: );

Line 2396: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2392: x_msg_count,
2393: x_msg_data,
2394: '_PVT'
2395: );
2396: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2397: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2398: (
2399: l_api_name,
2400: G_PKG_NAME,

Line 2397: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2393: x_msg_data,
2394: '_PVT'
2395: );
2396: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2397: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2398: (
2399: l_api_name,
2400: G_PKG_NAME,
2401: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2401: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2397: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2398: (
2399: l_api_name,
2400: G_PKG_NAME,
2401: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2402: x_msg_count,
2403: x_msg_data,
2404: '_PVT'
2405: );

Line 2407: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2403: x_msg_data,
2404: '_PVT'
2405: );
2406: WHEN OTHERS THEN
2407: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2408: (
2409: l_api_name,
2410: G_PKG_NAME,
2411: 'OTHERS',