APPS.OKL_SRS_PVT dependencies on OKC_API

Line 220: IF (l_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR) THEN

216: p_srsv_rec IN srsv_rec_type
217: ) RETURN srsv_rec_type IS
218: l_srsv_rec srsv_rec_type := p_srsv_rec;
219: BEGIN
220: IF (l_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR) THEN
221: l_srsv_rec.stream_type_name := NULL;
222: END IF;
223: IF (l_srsv_rec.index_number = OKC_API.G_MISS_NUM) THEN
224: l_srsv_rec.index_number := NULL;

Line 223: IF (l_srsv_rec.index_number = OKC_API.G_MISS_NUM) THEN

219: BEGIN
220: IF (l_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR) THEN
221: l_srsv_rec.stream_type_name := NULL;
222: END IF;
223: IF (l_srsv_rec.index_number = OKC_API.G_MISS_NUM) THEN
224: l_srsv_rec.index_number := NULL;
225: END IF;
226: IF (l_srsv_rec.activity_type = OKC_API.G_MISS_CHAR) THEN
227: l_srsv_rec.activity_type := NULL;

Line 226: IF (l_srsv_rec.activity_type = OKC_API.G_MISS_CHAR) THEN

222: END IF;
223: IF (l_srsv_rec.index_number = OKC_API.G_MISS_NUM) THEN
224: l_srsv_rec.index_number := NULL;
225: END IF;
226: IF (l_srsv_rec.activity_type = OKC_API.G_MISS_CHAR) THEN
227: l_srsv_rec.activity_type := NULL;
228: END IF;
229: IF (l_srsv_rec.sequence_number = OKC_API.G_MISS_NUM) THEN
230: l_srsv_rec.sequence_number := NULL;

Line 229: IF (l_srsv_rec.sequence_number = OKC_API.G_MISS_NUM) THEN

225: END IF;
226: IF (l_srsv_rec.activity_type = OKC_API.G_MISS_CHAR) THEN
227: l_srsv_rec.activity_type := NULL;
228: END IF;
229: IF (l_srsv_rec.sequence_number = OKC_API.G_MISS_NUM) THEN
230: l_srsv_rec.sequence_number := NULL;
231: END IF;
232: IF (l_srsv_rec.stream_interface_attribute01 = OKC_API.G_MISS_CHAR) THEN
233: l_srsv_rec.stream_interface_attribute01 := NULL;

Line 232: IF (l_srsv_rec.stream_interface_attribute01 = OKC_API.G_MISS_CHAR) THEN

228: END IF;
229: IF (l_srsv_rec.sequence_number = OKC_API.G_MISS_NUM) THEN
230: l_srsv_rec.sequence_number := NULL;
231: END IF;
232: IF (l_srsv_rec.stream_interface_attribute01 = OKC_API.G_MISS_CHAR) THEN
233: l_srsv_rec.stream_interface_attribute01 := NULL;
234: END IF;
235: IF (l_srsv_rec.stream_interface_attribute02 = OKC_API.G_MISS_CHAR) THEN
236: l_srsv_rec.stream_interface_attribute02 := NULL;

Line 235: IF (l_srsv_rec.stream_interface_attribute02 = OKC_API.G_MISS_CHAR) THEN

231: END IF;
232: IF (l_srsv_rec.stream_interface_attribute01 = OKC_API.G_MISS_CHAR) THEN
233: l_srsv_rec.stream_interface_attribute01 := NULL;
234: END IF;
235: IF (l_srsv_rec.stream_interface_attribute02 = OKC_API.G_MISS_CHAR) THEN
236: l_srsv_rec.stream_interface_attribute02 := NULL;
237: END IF;
238: IF (l_srsv_rec.stream_interface_attribute03 = OKC_API.G_MISS_CHAR) THEN
239: l_srsv_rec.stream_interface_attribute03 := NULL;

Line 238: IF (l_srsv_rec.stream_interface_attribute03 = OKC_API.G_MISS_CHAR) THEN

234: END IF;
235: IF (l_srsv_rec.stream_interface_attribute02 = OKC_API.G_MISS_CHAR) THEN
236: l_srsv_rec.stream_interface_attribute02 := NULL;
237: END IF;
238: IF (l_srsv_rec.stream_interface_attribute03 = OKC_API.G_MISS_CHAR) THEN
239: l_srsv_rec.stream_interface_attribute03 := NULL;
240: END IF;
241: IF (l_srsv_rec.stream_interface_attribute04 = OKC_API.G_MISS_CHAR) THEN
242: l_srsv_rec.stream_interface_attribute04 := NULL;

Line 241: IF (l_srsv_rec.stream_interface_attribute04 = OKC_API.G_MISS_CHAR) THEN

237: END IF;
238: IF (l_srsv_rec.stream_interface_attribute03 = OKC_API.G_MISS_CHAR) THEN
239: l_srsv_rec.stream_interface_attribute03 := NULL;
240: END IF;
241: IF (l_srsv_rec.stream_interface_attribute04 = OKC_API.G_MISS_CHAR) THEN
242: l_srsv_rec.stream_interface_attribute04 := NULL;
243: END IF;
244: IF (l_srsv_rec.stream_interface_attribute05 = OKC_API.G_MISS_CHAR) THEN
245: l_srsv_rec.stream_interface_attribute05 := NULL;

Line 244: IF (l_srsv_rec.stream_interface_attribute05 = OKC_API.G_MISS_CHAR) THEN

240: END IF;
241: IF (l_srsv_rec.stream_interface_attribute04 = OKC_API.G_MISS_CHAR) THEN
242: l_srsv_rec.stream_interface_attribute04 := NULL;
243: END IF;
244: IF (l_srsv_rec.stream_interface_attribute05 = OKC_API.G_MISS_CHAR) THEN
245: l_srsv_rec.stream_interface_attribute05 := NULL;
246: END IF;
247: IF (l_srsv_rec.stream_interface_attribute06 = OKC_API.G_MISS_CHAR) THEN
248: l_srsv_rec.stream_interface_attribute06 := NULL;

Line 247: IF (l_srsv_rec.stream_interface_attribute06 = OKC_API.G_MISS_CHAR) THEN

243: END IF;
244: IF (l_srsv_rec.stream_interface_attribute05 = OKC_API.G_MISS_CHAR) THEN
245: l_srsv_rec.stream_interface_attribute05 := NULL;
246: END IF;
247: IF (l_srsv_rec.stream_interface_attribute06 = OKC_API.G_MISS_CHAR) THEN
248: l_srsv_rec.stream_interface_attribute06 := NULL;
249: END IF;
250: IF (l_srsv_rec.stream_interface_attribute07 = OKC_API.G_MISS_CHAR) THEN
251: l_srsv_rec.stream_interface_attribute07 := NULL;

Line 250: IF (l_srsv_rec.stream_interface_attribute07 = OKC_API.G_MISS_CHAR) THEN

246: END IF;
247: IF (l_srsv_rec.stream_interface_attribute06 = OKC_API.G_MISS_CHAR) THEN
248: l_srsv_rec.stream_interface_attribute06 := NULL;
249: END IF;
250: IF (l_srsv_rec.stream_interface_attribute07 = OKC_API.G_MISS_CHAR) THEN
251: l_srsv_rec.stream_interface_attribute07 := NULL;
252: END IF;
253: IF (l_srsv_rec.stream_interface_attribute08 = OKC_API.G_MISS_CHAR) THEN
254: l_srsv_rec.stream_interface_attribute08 := NULL;

Line 253: IF (l_srsv_rec.stream_interface_attribute08 = OKC_API.G_MISS_CHAR) THEN

249: END IF;
250: IF (l_srsv_rec.stream_interface_attribute07 = OKC_API.G_MISS_CHAR) THEN
251: l_srsv_rec.stream_interface_attribute07 := NULL;
252: END IF;
253: IF (l_srsv_rec.stream_interface_attribute08 = OKC_API.G_MISS_CHAR) THEN
254: l_srsv_rec.stream_interface_attribute08 := NULL;
255: END IF;
256: IF (l_srsv_rec.stream_interface_attribute09 = OKC_API.G_MISS_CHAR) THEN
257: l_srsv_rec.stream_interface_attribute09 := NULL;

Line 256: IF (l_srsv_rec.stream_interface_attribute09 = OKC_API.G_MISS_CHAR) THEN

252: END IF;
253: IF (l_srsv_rec.stream_interface_attribute08 = OKC_API.G_MISS_CHAR) THEN
254: l_srsv_rec.stream_interface_attribute08 := NULL;
255: END IF;
256: IF (l_srsv_rec.stream_interface_attribute09 = OKC_API.G_MISS_CHAR) THEN
257: l_srsv_rec.stream_interface_attribute09 := NULL;
258: END IF;
259: IF (l_srsv_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR) THEN
260: l_srsv_rec.stream_interface_attribute10 := NULL;

Line 259: IF (l_srsv_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR) THEN

255: END IF;
256: IF (l_srsv_rec.stream_interface_attribute09 = OKC_API.G_MISS_CHAR) THEN
257: l_srsv_rec.stream_interface_attribute09 := NULL;
258: END IF;
259: IF (l_srsv_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR) THEN
260: l_srsv_rec.stream_interface_attribute10 := NULL;
261: END IF;
262: IF (l_srsv_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR) THEN
263: l_srsv_rec.stream_interface_attribute11 := NULL;

Line 262: IF (l_srsv_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR) THEN

258: END IF;
259: IF (l_srsv_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR) THEN
260: l_srsv_rec.stream_interface_attribute10 := NULL;
261: END IF;
262: IF (l_srsv_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR) THEN
263: l_srsv_rec.stream_interface_attribute11 := NULL;
264: END IF;
265: IF (l_srsv_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR) THEN
266: l_srsv_rec.stream_interface_attribute12 := NULL;

Line 265: IF (l_srsv_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR) THEN

261: END IF;
262: IF (l_srsv_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR) THEN
263: l_srsv_rec.stream_interface_attribute11 := NULL;
264: END IF;
265: IF (l_srsv_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR) THEN
266: l_srsv_rec.stream_interface_attribute12 := NULL;
267: END IF;
268: IF (l_srsv_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR) THEN
269: l_srsv_rec.stream_interface_attribute13 := NULL;

Line 268: IF (l_srsv_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR) THEN

264: END IF;
265: IF (l_srsv_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR) THEN
266: l_srsv_rec.stream_interface_attribute12 := NULL;
267: END IF;
268: IF (l_srsv_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR) THEN
269: l_srsv_rec.stream_interface_attribute13 := NULL;
270: END IF;
271: IF (l_srsv_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR) THEN
272: l_srsv_rec.stream_interface_attribute14 := NULL;

Line 271: IF (l_srsv_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR) THEN

267: END IF;
268: IF (l_srsv_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR) THEN
269: l_srsv_rec.stream_interface_attribute13 := NULL;
270: END IF;
271: IF (l_srsv_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR) THEN
272: l_srsv_rec.stream_interface_attribute14 := NULL;
273: END IF;
274: IF (l_srsv_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR) THEN
275: l_srsv_rec.stream_interface_attribute15 := NULL;

Line 274: IF (l_srsv_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR) THEN

270: END IF;
271: IF (l_srsv_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR) THEN
272: l_srsv_rec.stream_interface_attribute14 := NULL;
273: END IF;
274: IF (l_srsv_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR) THEN
275: l_srsv_rec.stream_interface_attribute15 := NULL;
276: END IF;
277:
278: IF (l_srsv_rec.sre_date = OKC_API.G_MISS_DATE) THEN

Line 278: IF (l_srsv_rec.sre_date = OKC_API.G_MISS_DATE) THEN

274: IF (l_srsv_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR) THEN
275: l_srsv_rec.stream_interface_attribute15 := NULL;
276: END IF;
277:
278: IF (l_srsv_rec.sre_date = OKC_API.G_MISS_DATE) THEN
279: l_srsv_rec.sre_date := NULL;
280: END IF;
281: IF (l_srsv_rec.amount = OKC_API.G_MISS_NUM) THEN
282: l_srsv_rec.amount := NULL;

Line 281: IF (l_srsv_rec.amount = OKC_API.G_MISS_NUM) THEN

277:
278: IF (l_srsv_rec.sre_date = OKC_API.G_MISS_DATE) THEN
279: l_srsv_rec.sre_date := NULL;
280: END IF;
281: IF (l_srsv_rec.amount = OKC_API.G_MISS_NUM) THEN
282: l_srsv_rec.amount := NULL;
283: END IF;
284: IF (l_srsv_rec.sir_id = OKC_API.G_MISS_NUM) THEN
285: l_srsv_rec.sir_id := NULL;

Line 284: IF (l_srsv_rec.sir_id = OKC_API.G_MISS_NUM) THEN

280: END IF;
281: IF (l_srsv_rec.amount = OKC_API.G_MISS_NUM) THEN
282: l_srsv_rec.amount := NULL;
283: END IF;
284: IF (l_srsv_rec.sir_id = OKC_API.G_MISS_NUM) THEN
285: l_srsv_rec.sir_id := NULL;
286: END IF;
287: IF (l_srsv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
288: l_srsv_rec.object_version_number := NULL;

Line 287: IF (l_srsv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

283: END IF;
284: IF (l_srsv_rec.sir_id = OKC_API.G_MISS_NUM) THEN
285: l_srsv_rec.sir_id := NULL;
286: END IF;
287: IF (l_srsv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
288: l_srsv_rec.object_version_number := NULL;
289: END IF;
290: IF (l_srsv_rec.created_by = OKC_API.G_MISS_NUM) THEN
291: l_srsv_rec.created_by := NULL;

Line 290: IF (l_srsv_rec.created_by = OKC_API.G_MISS_NUM) THEN

286: END IF;
287: IF (l_srsv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
288: l_srsv_rec.object_version_number := NULL;
289: END IF;
290: IF (l_srsv_rec.created_by = OKC_API.G_MISS_NUM) THEN
291: l_srsv_rec.created_by := NULL;
292: END IF;
293: IF (l_srsv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
294: l_srsv_rec.last_updated_by := NULL;

Line 293: IF (l_srsv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

289: END IF;
290: IF (l_srsv_rec.created_by = OKC_API.G_MISS_NUM) THEN
291: l_srsv_rec.created_by := NULL;
292: END IF;
293: IF (l_srsv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
294: l_srsv_rec.last_updated_by := NULL;
295: END IF;
296: IF (l_srsv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
297: l_srsv_rec.creation_date := NULL;

Line 296: IF (l_srsv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

292: END IF;
293: IF (l_srsv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
294: l_srsv_rec.last_updated_by := NULL;
295: END IF;
296: IF (l_srsv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
297: l_srsv_rec.creation_date := NULL;
298: END IF;
299: IF (l_srsv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
300: l_srsv_rec.last_update_date := NULL;

Line 299: IF (l_srsv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

295: END IF;
296: IF (l_srsv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
297: l_srsv_rec.creation_date := NULL;
298: END IF;
299: IF (l_srsv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
300: l_srsv_rec.last_update_date := NULL;
301: END IF;
302: IF (l_srsv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
303: l_srsv_rec.last_update_login := NULL;

Line 302: IF (l_srsv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

298: END IF;
299: IF (l_srsv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
300: l_srsv_rec.last_update_date := NULL;
301: END IF;
302: IF (l_srsv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
303: l_srsv_rec.last_update_login := NULL;
304: END IF;
305: RETURN(l_srsv_rec);
306: END null_out_defaults;

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

314: -------------------------------------------------
315: FUNCTION Validate_Attributes (
316: p_srsv_rec IN srsv_rec_type
317: ) RETURN VARCHAR2 IS
318: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
319: BEGIN
320: IF p_srsv_rec.id = OKC_API.G_MISS_NUM OR
321: p_srsv_rec.id IS NULL
322: THEN

Line 320: IF p_srsv_rec.id = OKC_API.G_MISS_NUM OR

316: p_srsv_rec IN srsv_rec_type
317: ) RETURN VARCHAR2 IS
318: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
319: BEGIN
320: IF p_srsv_rec.id = OKC_API.G_MISS_NUM OR
321: p_srsv_rec.id IS NULL
322: THEN
323: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
324: l_return_status := OKC_API.G_RET_STS_ERROR;

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

319: BEGIN
320: IF p_srsv_rec.id = OKC_API.G_MISS_NUM OR
321: p_srsv_rec.id IS NULL
322: THEN
323: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
324: l_return_status := OKC_API.G_RET_STS_ERROR;
325: ELSIF p_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR OR
326: p_srsv_rec.stream_type_name IS NULL
327: THEN

Line 324: l_return_status := OKC_API.G_RET_STS_ERROR;

320: IF p_srsv_rec.id = OKC_API.G_MISS_NUM OR
321: p_srsv_rec.id IS NULL
322: THEN
323: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
324: l_return_status := OKC_API.G_RET_STS_ERROR;
325: ELSIF p_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR OR
326: p_srsv_rec.stream_type_name IS NULL
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stream_type_name');

Line 325: ELSIF p_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR OR

321: p_srsv_rec.id IS NULL
322: THEN
323: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
324: l_return_status := OKC_API.G_RET_STS_ERROR;
325: ELSIF p_srsv_rec.stream_type_name = OKC_API.G_MISS_CHAR OR
326: p_srsv_rec.stream_type_name IS NULL
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stream_type_name');
329: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stream_type_name');

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

Line 329: l_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 330: ELSIF p_srsv_rec.sir_id = OKC_API.G_MISS_NUM OR

326: p_srsv_rec.stream_type_name IS NULL
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stream_type_name');
329: l_return_status := OKC_API.G_RET_STS_ERROR;
330: ELSIF p_srsv_rec.sir_id = OKC_API.G_MISS_NUM OR
331: p_srsv_rec.sir_id IS NULL
332: THEN
333: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
334: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 333: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');

329: l_return_status := OKC_API.G_RET_STS_ERROR;
330: ELSIF p_srsv_rec.sir_id = OKC_API.G_MISS_NUM OR
331: p_srsv_rec.sir_id IS NULL
332: THEN
333: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
334: l_return_status := OKC_API.G_RET_STS_ERROR;
335: ELSIF p_srsv_rec.object_version_number = OKC_API.G_MISS_NUM OR
336: p_srsv_rec.object_version_number IS NULL
337: THEN

Line 334: l_return_status := OKC_API.G_RET_STS_ERROR;

330: ELSIF p_srsv_rec.sir_id = OKC_API.G_MISS_NUM OR
331: p_srsv_rec.sir_id IS NULL
332: THEN
333: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
334: l_return_status := OKC_API.G_RET_STS_ERROR;
335: ELSIF p_srsv_rec.object_version_number = OKC_API.G_MISS_NUM OR
336: p_srsv_rec.object_version_number IS NULL
337: THEN
338: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 335: ELSIF p_srsv_rec.object_version_number = OKC_API.G_MISS_NUM OR

331: p_srsv_rec.sir_id IS NULL
332: THEN
333: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
334: l_return_status := OKC_API.G_RET_STS_ERROR;
335: ELSIF p_srsv_rec.object_version_number = OKC_API.G_MISS_NUM OR
336: p_srsv_rec.object_version_number IS NULL
337: THEN
338: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
339: l_return_status := OKC_API.G_RET_STS_ERROR;

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

334: l_return_status := OKC_API.G_RET_STS_ERROR;
335: ELSIF p_srsv_rec.object_version_number = OKC_API.G_MISS_NUM OR
336: p_srsv_rec.object_version_number IS NULL
337: THEN
338: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
339: l_return_status := OKC_API.G_RET_STS_ERROR;
340: END IF;
341: RETURN(l_return_status);
342: END Validate_Attributes;

Line 339: l_return_status := OKC_API.G_RET_STS_ERROR;

335: ELSIF p_srsv_rec.object_version_number = OKC_API.G_MISS_NUM OR
336: p_srsv_rec.object_version_number IS NULL
337: THEN
338: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
339: l_return_status := OKC_API.G_RET_STS_ERROR;
340: END IF;
341: RETURN(l_return_status);
342: END Validate_Attributes;
343: */

Line 368: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

364: ) IS
365:
366: BEGIN
367: -- initialize return status
368: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
369:
370: IF p_srsv_rec.id = Okc_Api.G_MISS_NUM OR
371: p_srsv_rec.id IS NULL
372: THEN

Line 370: IF p_srsv_rec.id = Okc_Api.G_MISS_NUM OR

366: BEGIN
367: -- initialize return status
368: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
369:
370: IF p_srsv_rec.id = Okc_Api.G_MISS_NUM OR
371: p_srsv_rec.id IS NULL
372: THEN
373: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
374: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 373: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

369:
370: IF p_srsv_rec.id = Okc_Api.G_MISS_NUM OR
371: p_srsv_rec.id IS NULL
372: THEN
373: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
374: x_return_status := Okc_Api.G_RET_STS_ERROR;
375: RAISE G_EXCEPTION_HALT_VALIDATION;
376: END IF;
377:

Line 374: x_return_status := Okc_Api.G_RET_STS_ERROR;

370: IF p_srsv_rec.id = Okc_Api.G_MISS_NUM OR
371: p_srsv_rec.id IS NULL
372: THEN
373: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
374: x_return_status := Okc_Api.G_RET_STS_ERROR;
375: RAISE G_EXCEPTION_HALT_VALIDATION;
376: END IF;
377:
378: EXCEPTION

Line 386: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

382: NULL;
383:
384: WHEN OTHERS THEN
385: -- store SQL error message on message stack for caller
386: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
387: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
388: ,p_token1 => G_OKL_SQLCODE_TOKEN
389: ,p_token1_value => SQLCODE
390: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 394: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

390: ,p_token2 => G_OKL_SQLERRM_TOKEN
391: ,p_token2_value => SQLERRM);
392:
393: -- notify caller of an UNEXPECTED error
394: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
395:
396: END Validate_Id;
397:
398: ---------------------------------------------------------------------------

Line 418: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

414:
415: BEGIN
416:
417: -- initialize return status
418: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
419:
420: IF p_srsv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
421: p_srsv_rec.object_version_number IS NULL
422: THEN

Line 420: IF p_srsv_rec.object_version_number = Okc_Api.G_MISS_NUM OR

416:
417: -- initialize return status
418: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
419:
420: IF p_srsv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
421: p_srsv_rec.object_version_number IS NULL
422: THEN
423: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
424: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 423: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

419:
420: IF p_srsv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
421: p_srsv_rec.object_version_number IS NULL
422: THEN
423: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
424: x_return_status := Okc_Api.G_RET_STS_ERROR;
425: RAISE G_EXCEPTION_HALT_VALIDATION;
426: END IF;
427:

Line 424: x_return_status := Okc_Api.G_RET_STS_ERROR;

420: IF p_srsv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
421: p_srsv_rec.object_version_number IS NULL
422: THEN
423: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
424: x_return_status := Okc_Api.G_RET_STS_ERROR;
425: RAISE G_EXCEPTION_HALT_VALIDATION;
426: END IF;
427:
428: EXCEPTION

Line 436: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

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

Line 444: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

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

Line 467: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

463: ) IS
464:
465: BEGIN
466: -- initialize return status
467: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
468:
469: IF p_srsv_rec.index_number = Okc_Api.G_MISS_NUM OR
470: p_srsv_rec.index_number IS NULL
471: THEN

Line 469: IF p_srsv_rec.index_number = Okc_Api.G_MISS_NUM OR

465: BEGIN
466: -- initialize return status
467: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
468:
469: IF p_srsv_rec.index_number = Okc_Api.G_MISS_NUM OR
470: p_srsv_rec.index_number IS NULL
471: THEN
472: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'index_number');
473: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 472: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'index_number');

468:
469: IF p_srsv_rec.index_number = Okc_Api.G_MISS_NUM OR
470: p_srsv_rec.index_number IS NULL
471: THEN
472: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'index_number');
473: x_return_status := Okc_Api.G_RET_STS_ERROR;
474: RAISE G_EXCEPTION_HALT_VALIDATION;
475: END IF;
476:

Line 473: x_return_status := Okc_Api.G_RET_STS_ERROR;

469: IF p_srsv_rec.index_number = Okc_Api.G_MISS_NUM OR
470: p_srsv_rec.index_number IS NULL
471: THEN
472: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'index_number');
473: x_return_status := Okc_Api.G_RET_STS_ERROR;
474: RAISE G_EXCEPTION_HALT_VALIDATION;
475: END IF;
476:
477: EXCEPTION

Line 485: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

481: NULL;
482:
483: WHEN OTHERS THEN
484: -- store SQL error message on message stack for caller
485: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
486: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
487: ,p_token1 => G_OKL_SQLCODE_TOKEN
488: ,p_token1_value => SQLCODE
489: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 493: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

489: ,p_token2 => G_OKL_SQLERRM_TOKEN
490: ,p_token2_value => SQLERRM);
491:
492: -- notify caller of an UNEXPECTED error
493: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
494:
495: END Validate_Index_Number;
496:
497: ---------------------------------------------------------------------------

Line 516: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

512: ) IS
513:
514: BEGIN
515: -- initialize return status
516: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
517:
518: IF p_srsv_rec.Sre_Date = Okc_Api.G_MISS_DATE OR
519: p_srsv_rec.Sre_Date IS NULL
520: THEN

Line 518: IF p_srsv_rec.Sre_Date = Okc_Api.G_MISS_DATE OR

514: BEGIN
515: -- initialize return status
516: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
517:
518: IF p_srsv_rec.Sre_Date = Okc_Api.G_MISS_DATE OR
519: p_srsv_rec.Sre_Date IS NULL
520: THEN
521: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Sre_Date');
522: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 521: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Sre_Date');

517:
518: IF p_srsv_rec.Sre_Date = Okc_Api.G_MISS_DATE OR
519: p_srsv_rec.Sre_Date IS NULL
520: THEN
521: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Sre_Date');
522: x_return_status := Okc_Api.G_RET_STS_ERROR;
523: RAISE G_EXCEPTION_HALT_VALIDATION;
524: END IF;
525:

Line 522: x_return_status := Okc_Api.G_RET_STS_ERROR;

518: IF p_srsv_rec.Sre_Date = Okc_Api.G_MISS_DATE OR
519: p_srsv_rec.Sre_Date IS NULL
520: THEN
521: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Sre_Date');
522: x_return_status := Okc_Api.G_RET_STS_ERROR;
523: RAISE G_EXCEPTION_HALT_VALIDATION;
524: END IF;
525:
526: EXCEPTION

Line 534: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

530: NULL;
531:
532: WHEN OTHERS THEN
533: -- store SQL error message on message stack for caller
534: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
535: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
536: ,p_token1 => G_OKL_SQLCODE_TOKEN
537: ,p_token1_value => SQLCODE
538: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 542: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

538: ,p_token2 => G_OKL_SQLERRM_TOKEN
539: ,p_token2_value => SQLERRM);
540:
541: -- notify caller of an UNEXPECTED error
542: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
543:
544: END Validate_Sre_Date;
545:
546: ---------------------------------------------------------------------------

Line 565: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

561: ) IS
562:
563: BEGIN
564: -- initialize return status
565: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
566:
567: IF p_srsv_rec.Amount = Okc_Api.G_MISS_NUM OR
568: p_srsv_rec.Amount IS NULL
569: THEN

Line 567: IF p_srsv_rec.Amount = Okc_Api.G_MISS_NUM OR

563: BEGIN
564: -- initialize return status
565: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
566:
567: IF p_srsv_rec.Amount = Okc_Api.G_MISS_NUM OR
568: p_srsv_rec.Amount IS NULL
569: THEN
570: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Amount');
571: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 570: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Amount');

566:
567: IF p_srsv_rec.Amount = Okc_Api.G_MISS_NUM OR
568: p_srsv_rec.Amount IS NULL
569: THEN
570: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Amount');
571: x_return_status := Okc_Api.G_RET_STS_ERROR;
572: RAISE G_EXCEPTION_HALT_VALIDATION;
573: END IF;
574:

Line 571: x_return_status := Okc_Api.G_RET_STS_ERROR;

567: IF p_srsv_rec.Amount = Okc_Api.G_MISS_NUM OR
568: p_srsv_rec.Amount IS NULL
569: THEN
570: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Amount');
571: x_return_status := Okc_Api.G_RET_STS_ERROR;
572: RAISE G_EXCEPTION_HALT_VALIDATION;
573: END IF;
574:
575: EXCEPTION

Line 583: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

579: NULL;
580:
581: WHEN OTHERS THEN
582: -- store SQL error message on message stack for caller
583: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
584: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
585: ,p_token1 => G_OKL_SQLCODE_TOKEN
586: ,p_token1_value => SQLCODE
587: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 591: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

587: ,p_token2 => G_OKL_SQLERRM_TOKEN
588: ,p_token2_value => SQLERRM);
589:
590: -- notify caller of an UNEXPECTED error
591: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
592:
593: END Validate_Amount;
594:
595: ---------------------------------------------------------------------------

Line 615: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

611:
612: BEGIN
613:
614: -- initialize return status
615: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
616:
617: IF p_srsv_rec.Stream_Type_Name = Okc_Api.G_MISS_CHAR OR
618: p_srsv_rec.Stream_Type_Name IS NULL
619: THEN

Line 617: IF p_srsv_rec.Stream_Type_Name = Okc_Api.G_MISS_CHAR OR

613:
614: -- initialize return status
615: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
616:
617: IF p_srsv_rec.Stream_Type_Name = Okc_Api.G_MISS_CHAR OR
618: p_srsv_rec.Stream_Type_Name IS NULL
619: THEN
620: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Stream_Type_Name');
621: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 620: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Stream_Type_Name');

616:
617: IF p_srsv_rec.Stream_Type_Name = Okc_Api.G_MISS_CHAR OR
618: p_srsv_rec.Stream_Type_Name IS NULL
619: THEN
620: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Stream_Type_Name');
621: x_return_status := Okc_Api.G_RET_STS_ERROR;
622: RAISE G_EXCEPTION_HALT_VALIDATION;
623: END IF;
624:

Line 621: x_return_status := Okc_Api.G_RET_STS_ERROR;

617: IF p_srsv_rec.Stream_Type_Name = Okc_Api.G_MISS_CHAR OR
618: p_srsv_rec.Stream_Type_Name IS NULL
619: THEN
620: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Stream_Type_Name');
621: x_return_status := Okc_Api.G_RET_STS_ERROR;
622: RAISE G_EXCEPTION_HALT_VALIDATION;
623: END IF;
624:
625: EXCEPTION

Line 633: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

629: NULL;
630:
631: WHEN OTHERS THEN
632: -- store SQL error message on message stack for caller
633: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
634: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
635: ,p_token1 => G_OKL_SQLCODE_TOKEN
636: ,p_token1_value => SQLCODE
637: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 641: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

637: ,p_token2 => G_OKL_SQLERRM_TOKEN
638: ,p_token2_value => SQLERRM);
639:
640: -- notify caller of an UNEXPECTED error
641: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
642:
643: END Validate_Stream_Type_Name;
644:
645: ---------------------------------------------------------------------------

Line 674: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

670:
671: BEGIN
672:
673: -- initialize return status
674: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
675:
676: IF p_srsv_rec.sir_id = Okc_Api.G_MISS_NUM OR
677: p_srsv_rec.sir_id IS NULL
678: THEN

Line 676: IF p_srsv_rec.sir_id = Okc_Api.G_MISS_NUM OR

672:
673: -- initialize return status
674: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
675:
676: IF p_srsv_rec.sir_id = Okc_Api.G_MISS_NUM OR
677: p_srsv_rec.sir_id IS NULL
678: THEN
679: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
680: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 679: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');

675:
676: IF p_srsv_rec.sir_id = Okc_Api.G_MISS_NUM OR
677: p_srsv_rec.sir_id IS NULL
678: THEN
679: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
680: x_return_status := Okc_Api.G_RET_STS_ERROR;
681: RAISE G_EXCEPTION_HALT_VALIDATION;
682: END IF;
683:

Line 680: x_return_status := Okc_Api.G_RET_STS_ERROR;

676: IF p_srsv_rec.sir_id = Okc_Api.G_MISS_NUM OR
677: p_srsv_rec.sir_id IS NULL
678: THEN
679: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sir_id');
680: x_return_status := Okc_Api.G_RET_STS_ERROR;
681: RAISE G_EXCEPTION_HALT_VALIDATION;
682: END IF;
683:
684: OPEN okl_sirv_pk_csr(p_srsv_rec.sir_id);

Line 690: Okc_Api.set_message(G_OKC_APP,G_INVALID_VALUE,G_COL_NAME_TOKEN,'sir_id');

686: l_row_not_found := okl_sirv_pk_csr%NOTFOUND;
687: CLOSE okl_sirv_pk_csr;
688:
689: IF l_row_not_found THEN
690: Okc_Api.set_message(G_OKC_APP,G_INVALID_VALUE,G_COL_NAME_TOKEN,'sir_id');
691: x_return_status := Okc_Api.G_RET_STS_ERROR;
692: END IF;
693:
694: EXCEPTION

Line 691: x_return_status := Okc_Api.G_RET_STS_ERROR;

687: CLOSE okl_sirv_pk_csr;
688:
689: IF l_row_not_found THEN
690: Okc_Api.set_message(G_OKC_APP,G_INVALID_VALUE,G_COL_NAME_TOKEN,'sir_id');
691: x_return_status := Okc_Api.G_RET_STS_ERROR;
692: END IF;
693:
694: EXCEPTION
695: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 702: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

698: NULL;
699:
700: WHEN OTHERS THEN
701: -- store SQL error message on message stack for caller
702: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
703: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
704: ,p_token1 => G_OKL_SQLCODE_TOKEN
705: ,p_token1_value => SQLCODE
706: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 710: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

706: ,p_token2 => G_OKL_SQLERRM_TOKEN
707: ,p_token2_value => SQLERRM);
708:
709: -- notify caller of an UNEXPECTED error
710: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
711:
712: -- verify that the cursor was closed
713: IF okl_sirv_pk_csr%ISOPEN THEN
714: CLOSE okl_sirv_pk_csr;

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

732: FUNCTION Validate_Attributes (
733: p_srsv_rec IN srsv_rec_type
734: ) RETURN VARCHAR2 IS
735:
736: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
737: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
738: BEGIN
739: -- call each column-level validation
740:

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

733: p_srsv_rec IN srsv_rec_type
734: ) RETURN VARCHAR2 IS
735:
736: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
737: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
738: BEGIN
739: -- call each column-level validation
740:
741: -- Validate_Id

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

739: -- call each column-level validation
740:
741: -- Validate_Id
742: Validate_Id(p_srsv_rec, x_return_status);
743: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
744: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
745: -- need to exit
746: l_return_status := x_return_status;
747: RAISE G_EXCEPTION_HALT_VALIDATION;

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

740:
741: -- Validate_Id
742: Validate_Id(p_srsv_rec, x_return_status);
743: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
744: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
745: -- need to exit
746: l_return_status := x_return_status;
747: RAISE G_EXCEPTION_HALT_VALIDATION;
748: ELSE

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

752: END IF;
753:
754: -- Validate_Object_Version_Number
755: Validate_Object_Version_Number(p_srsv_rec, x_return_status);
756: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
758: -- need to exit
759: l_return_status := x_return_status;
760: RAISE G_EXCEPTION_HALT_VALIDATION;

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

753:
754: -- Validate_Object_Version_Number
755: Validate_Object_Version_Number(p_srsv_rec, x_return_status);
756: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
758: -- need to exit
759: l_return_status := x_return_status;
760: RAISE G_EXCEPTION_HALT_VALIDATION;
761: ELSE

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

765: END IF;
766:
767: -- Validate_Stream_Type_Name
768: Validate_Stream_Type_Name(p_srsv_rec, x_return_status);
769: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
770: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
771: -- need to exit
772: l_return_status := x_return_status;
773: RAISE G_EXCEPTION_HALT_VALIDATION;

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

766:
767: -- Validate_Stream_Type_Name
768: Validate_Stream_Type_Name(p_srsv_rec, x_return_status);
769: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
770: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
771: -- need to exit
772: l_return_status := x_return_status;
773: RAISE G_EXCEPTION_HALT_VALIDATION;
774: ELSE

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

778: END IF;
779:
780: -- Validate_Sre_Date
781: Validate_Sre_Date(p_srsv_rec, x_return_status);
782: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
783: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
784: -- need to exit
785: l_return_status := x_return_status;
786: RAISE G_EXCEPTION_HALT_VALIDATION;

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

779:
780: -- Validate_Sre_Date
781: Validate_Sre_Date(p_srsv_rec, x_return_status);
782: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
783: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
784: -- need to exit
785: l_return_status := x_return_status;
786: RAISE G_EXCEPTION_HALT_VALIDATION;
787: ELSE

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

791: END IF;
792:
793: -- Validate_Amount
794: Validate_Amount(p_srsv_rec, x_return_status);
795: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
796: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
797: -- need to exit
798: l_return_status := x_return_status;
799: RAISE G_EXCEPTION_HALT_VALIDATION;

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

792:
793: -- Validate_Amount
794: Validate_Amount(p_srsv_rec, x_return_status);
795: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
796: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
797: -- need to exit
798: l_return_status := x_return_status;
799: RAISE G_EXCEPTION_HALT_VALIDATION;
800: ELSE

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

804: END IF;
805:
806: -- Validate_Sir_id
807: Validate_Sir_id(p_srsv_rec, x_return_status);
808: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
809: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
810: -- need to exit
811: l_return_status := x_return_status;
812: RAISE G_EXCEPTION_HALT_VALIDATION;

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

805:
806: -- Validate_Sir_id
807: Validate_Sir_id(p_srsv_rec, x_return_status);
808: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
809: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
810: -- need to exit
811: l_return_status := x_return_status;
812: RAISE G_EXCEPTION_HALT_VALIDATION;
813: ELSE

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

824: RETURN (l_return_status);
825:
826: WHEN OTHERS THEN
827: -- store SQL error message on message stack for caller
828: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
829: p_msg_name => G_OKL_UNEXPECTED_ERROR,
830: p_token1 => G_OKL_SQLCODE_TOKEN,
831: p_token1_value => SQLCODE,
832: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 835: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

831: p_token1_value => SQLCODE,
832: p_token2 => G_OKL_SQLERRM_TOKEN,
833: p_token2_value => SQLERRM);
834: -- notify caller of an UNEXPECTED error
835: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
836:
837: RETURN(l_return_status);
838: END Validate_Attributes;
839: -- END change : mvasudev

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

846: ---------------------------------------------
847: FUNCTION Validate_Record (
848: p_srsv_rec IN srsv_rec_type
849: ) RETURN VARCHAR2 IS
850: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
851: BEGIN
852: RETURN (l_return_status);
853: END Validate_Record;
854:

Line 944: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

940: -- validate_row for:OKL_SIF_RET_STRMS_V --
941: ------------------------------------------
942: PROCEDURE validate_row(
943: p_api_version IN NUMBER,
944: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
945: x_return_status OUT NOCOPY VARCHAR2,
946: x_msg_count OUT NOCOPY NUMBER,
947: x_msg_data OUT NOCOPY VARCHAR2,
948: p_srsv_rec IN srsv_rec_type) IS

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

948: p_srsv_rec IN srsv_rec_type) IS
949:
950: l_api_version CONSTANT NUMBER := 1;
951: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
952: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
953: l_srsv_rec srsv_rec_type := p_srsv_rec;
954: l_srs_rec srs_rec_type;
955: BEGIN
956: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

952: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
953: l_srsv_rec srsv_rec_type := p_srsv_rec;
954: l_srs_rec srs_rec_type;
955: BEGIN
956: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
957: G_PKG_NAME,
958: p_init_msg_list,
959: l_api_version,
960: p_api_version,

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

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

Line 964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

960: p_api_version,
961: '_PVT',
962: x_return_status);
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: --- Validate all non-missing attributes (Item Level Validation)

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

961: '_PVT',
962: x_return_status);
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: --- Validate all non-missing attributes (Item Level Validation)
969: l_return_status := Validate_Attributes(l_srsv_rec);

Line 966: RAISE OKC_API.G_EXCEPTION_ERROR;

962: x_return_status);
963: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: --- Validate all non-missing attributes (Item Level Validation)
969: l_return_status := Validate_Attributes(l_srsv_rec);
970: --- If any errors happen abort API

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

967: END IF;
968: --- Validate all non-missing attributes (Item Level Validation)
969: l_return_status := Validate_Attributes(l_srsv_rec);
970: --- If any errors happen abort API
971: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
974: RAISE OKC_API.G_EXCEPTION_ERROR;
975: END IF;

Line 972: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

968: --- Validate all non-missing attributes (Item Level Validation)
969: l_return_status := Validate_Attributes(l_srsv_rec);
970: --- If any errors happen abort API
971: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
974: RAISE OKC_API.G_EXCEPTION_ERROR;
975: END IF;
976: l_return_status := Validate_Record(l_srsv_rec);

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

969: l_return_status := Validate_Attributes(l_srsv_rec);
970: --- If any errors happen abort API
971: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
974: RAISE OKC_API.G_EXCEPTION_ERROR;
975: END IF;
976: l_return_status := Validate_Record(l_srsv_rec);
977: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 974: RAISE OKC_API.G_EXCEPTION_ERROR;

970: --- If any errors happen abort API
971: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
974: RAISE OKC_API.G_EXCEPTION_ERROR;
975: END IF;
976: l_return_status := Validate_Record(l_srsv_rec);
977: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

973: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
974: RAISE OKC_API.G_EXCEPTION_ERROR;
975: END IF;
976: l_return_status := Validate_Record(l_srsv_rec);
977: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;

Line 978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

974: RAISE OKC_API.G_EXCEPTION_ERROR;
975: END IF;
976: l_return_status := Validate_Record(l_srsv_rec);
977: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

975: END IF;
976: l_return_status := Validate_Record(l_srsv_rec);
977: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
983: EXCEPTION

Line 980: RAISE OKC_API.G_EXCEPTION_ERROR;

976: l_return_status := Validate_Record(l_srsv_rec);
977: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
983: EXCEPTION
984: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
983: EXCEPTION
984: WHEN OKC_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (

Line 984: WHEN OKC_API.G_EXCEPTION_ERROR THEN

980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
983: EXCEPTION
984: WHEN OKC_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,

Line 985: x_return_status := OKC_API.HANDLE_EXCEPTIONS

981: END IF;
982: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
983: EXCEPTION
984: WHEN OKC_API.G_EXCEPTION_ERROR THEN
985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,
989: 'OKC_API.G_RET_STS_ERROR',

Line 989: 'OKC_API.G_RET_STS_ERROR',

985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,
989: 'OKC_API.G_RET_STS_ERROR',
990: x_msg_count,
991: x_msg_data,
992: '_PVT'
993: );

Line 994: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

990: x_msg_count,
991: x_msg_data,
992: '_PVT'
993: );
994: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
995: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
996: (
997: l_api_name,
998: G_PKG_NAME,

Line 995: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

991: x_msg_data,
992: '_PVT'
993: );
994: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
995: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
996: (
997: l_api_name,
998: G_PKG_NAME,
999: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 999: 'OKC_API.G_RET_STS_UNEXP_ERROR',

995: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
996: (
997: l_api_name,
998: G_PKG_NAME,
999: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1000: x_msg_count,
1001: x_msg_data,
1002: '_PVT'
1003: );

Line 1005: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1001: x_msg_data,
1002: '_PVT'
1003: );
1004: WHEN OTHERS THEN
1005: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1006: (
1007: l_api_name,
1008: G_PKG_NAME,
1009: 'OTHERS',

Line 1020: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1016: -- PL/SQL TBL validate_row for:SRSV_TBL --
1017: ------------------------------------------
1018: PROCEDURE validate_row(
1019: p_api_version IN NUMBER,
1020: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1021: x_return_status OUT NOCOPY VARCHAR2,
1022: x_msg_count OUT NOCOPY NUMBER,
1023: x_msg_data OUT NOCOPY VARCHAR2,
1024: p_srsv_tbl IN srsv_tbl_type) IS

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

1024: p_srsv_tbl IN srsv_tbl_type) IS
1025:
1026: l_api_version CONSTANT NUMBER := 1;
1027: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1028: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1029: i NUMBER := 0;
1030: -- START change : mvasudev, 09/05/2001
1031: -- Adding OverAll Status Flag
1032: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

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

1028: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1029: i NUMBER := 0;
1030: -- START change : mvasudev, 09/05/2001
1031: -- Adding OverAll Status Flag
1032: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1033: -- END change : mvasudev
1034: BEGIN
1035: OKC_API.init_msg_list(p_init_msg_list);
1036: -- Make sure PL/SQL table has records in it before passing

Line 1035: OKC_API.init_msg_list(p_init_msg_list);

1031: -- Adding OverAll Status Flag
1032: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1033: -- END change : mvasudev
1034: BEGIN
1035: OKC_API.init_msg_list(p_init_msg_list);
1036: -- Make sure PL/SQL table has records in it before passing
1037: IF (p_srsv_tbl.COUNT > 0) THEN
1038: i := p_srsv_tbl.FIRST;
1039: LOOP

Line 1042: p_init_msg_list => OKC_API.G_FALSE,

1038: i := p_srsv_tbl.FIRST;
1039: LOOP
1040: validate_row (
1041: p_api_version => p_api_version,
1042: p_init_msg_list => OKC_API.G_FALSE,
1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data,
1046: p_srsv_rec => p_srsv_tbl(i));

Line 1049: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1045: x_msg_data => x_msg_data,
1046: p_srsv_rec => p_srsv_tbl(i));
1047: -- START change : mvasudev, 09/05/2001
1048: -- store the highest degree of error
1049: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1050: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1051: l_overall_status := x_return_status;
1052: END IF;
1053: END IF;

Line 1050: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1046: p_srsv_rec => p_srsv_tbl(i));
1047: -- START change : mvasudev, 09/05/2001
1048: -- store the highest degree of error
1049: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1050: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1051: l_overall_status := x_return_status;
1052: END IF;
1053: END IF;
1054: -- END change : mvasudev

Line 1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1060: x_return_status := l_overall_status;
1061: -- END change : mvasudev
1062: END IF;
1063: EXCEPTION
1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (
1067: l_api_name,
1068: G_PKG_NAME,

Line 1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1061: -- END change : mvasudev
1062: END IF;
1063: EXCEPTION
1064: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (
1067: l_api_name,
1068: G_PKG_NAME,
1069: 'OKC_API.G_RET_STS_ERROR',

Line 1069: 'OKC_API.G_RET_STS_ERROR',

1065: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1066: (
1067: l_api_name,
1068: G_PKG_NAME,
1069: 'OKC_API.G_RET_STS_ERROR',
1070: x_msg_count,
1071: x_msg_data,
1072: '_PVT'
1073: );

Line 1074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1070: x_msg_count,
1071: x_msg_data,
1072: '_PVT'
1073: );
1074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1076: (
1077: l_api_name,
1078: G_PKG_NAME,

Line 1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1071: x_msg_data,
1072: '_PVT'
1073: );
1074: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1076: (
1077: l_api_name,
1078: G_PKG_NAME,
1079: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1079: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1075: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1076: (
1077: l_api_name,
1078: G_PKG_NAME,
1079: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1080: x_msg_count,
1081: x_msg_data,
1082: '_PVT'
1083: );

Line 1085: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1081: x_msg_data,
1082: '_PVT'
1083: );
1084: WHEN OTHERS THEN
1085: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1086: (
1087: l_api_name,
1088: G_PKG_NAME,
1089: 'OTHERS',

Line 1103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1099: --------------------------------------
1100: -- insert_row for:OKL_SIF_RET_STRMS --
1101: --------------------------------------
1102: PROCEDURE insert_row(
1103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1104: x_return_status OUT NOCOPY VARCHAR2,
1105: x_msg_count OUT NOCOPY NUMBER,
1106: x_msg_data OUT NOCOPY VARCHAR2,
1107: p_srs_rec IN srs_rec_type,

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

1108: x_srs_rec OUT NOCOPY srs_rec_type) IS
1109:
1110: l_api_version CONSTANT NUMBER := 1;
1111: l_api_name CONSTANT VARCHAR2(30) := 'STRMS_insert_row';
1112: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1113: l_srs_rec srs_rec_type := p_srs_rec;
1114: l_def_srs_rec srs_rec_type;
1115: ------------------------------------------
1116: -- Set_Attributes for:OKL_SIF_RET_STRMS --

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

1118: FUNCTION Set_Attributes (
1119: p_srs_rec IN srs_rec_type,
1120: x_srs_rec OUT NOCOPY srs_rec_type
1121: ) RETURN VARCHAR2 IS
1122: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1123: BEGIN
1124: x_srs_rec := p_srs_rec;
1125: RETURN(l_return_status);
1126: END Set_Attributes;

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

1124: x_srs_rec := p_srs_rec;
1125: RETURN(l_return_status);
1126: END Set_Attributes;
1127: BEGIN
1128: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1129: p_init_msg_list,
1130: '_PVT',
1131: x_return_status);
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1128: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1129: p_init_msg_list,
1130: '_PVT',
1131: x_return_status);
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1135: RAISE OKC_API.G_EXCEPTION_ERROR;
1136: END IF;

Line 1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1129: p_init_msg_list,
1130: '_PVT',
1131: x_return_status);
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1135: RAISE OKC_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: --- Setting item attributes

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

1130: '_PVT',
1131: x_return_status);
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1135: RAISE OKC_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: --- Setting item attributes
1138: l_return_status := Set_Attributes(

Line 1135: RAISE OKC_API.G_EXCEPTION_ERROR;

1131: x_return_status);
1132: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1135: RAISE OKC_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: --- Setting item attributes
1138: l_return_status := Set_Attributes(
1139: p_srs_rec, -- IN

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

1138: l_return_status := Set_Attributes(
1139: p_srs_rec, -- IN
1140: l_srs_rec); -- OUT
1141: --- If any errors happen abort API
1142: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_ERROR;
1146: END IF;

Line 1143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1139: p_srs_rec, -- IN
1140: l_srs_rec); -- OUT
1141: --- If any errors happen abort API
1142: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_ERROR;
1146: END IF;
1147:

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

1140: l_srs_rec); -- OUT
1141: --- If any errors happen abort API
1142: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_ERROR;
1146: END IF;
1147:
1148: INSERT INTO OKL_SIF_RET_STRMS(

Line 1145: RAISE OKC_API.G_EXCEPTION_ERROR;

1141: --- If any errors happen abort API
1142: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1145: RAISE OKC_API.G_EXCEPTION_ERROR;
1146: END IF;
1147:
1148: INSERT INTO OKL_SIF_RET_STRMS(
1149: id,

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

1206: l_srs_rec.last_update_date,
1207: l_srs_rec.last_update_login);
1208: -- Set OUT values
1209: x_srs_rec := l_srs_rec;
1210: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1211: EXCEPTION
1212: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1213: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1214: (

Line 1212: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1208: -- Set OUT values
1209: x_srs_rec := l_srs_rec;
1210: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1211: EXCEPTION
1212: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1213: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,
1216: G_PKG_NAME,

Line 1213: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1209: x_srs_rec := l_srs_rec;
1210: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1211: EXCEPTION
1212: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1213: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,
1216: G_PKG_NAME,
1217: 'OKC_API.G_RET_STS_ERROR',

Line 1217: 'OKC_API.G_RET_STS_ERROR',

1213: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,
1216: G_PKG_NAME,
1217: 'OKC_API.G_RET_STS_ERROR',
1218: x_msg_count,
1219: x_msg_data,
1220: '_PVT'
1221: );

Line 1222: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1218: x_msg_count,
1219: x_msg_data,
1220: '_PVT'
1221: );
1222: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1223: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1224: (
1225: l_api_name,
1226: G_PKG_NAME,

Line 1223: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1219: x_msg_data,
1220: '_PVT'
1221: );
1222: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1223: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1224: (
1225: l_api_name,
1226: G_PKG_NAME,
1227: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1227: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1223: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1224: (
1225: l_api_name,
1226: G_PKG_NAME,
1227: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1228: x_msg_count,
1229: x_msg_data,
1230: '_PVT'
1231: );

Line 1233: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1229: x_msg_data,
1230: '_PVT'
1231: );
1232: WHEN OTHERS THEN
1233: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1234: (
1235: l_api_name,
1236: G_PKG_NAME,
1237: 'OTHERS',

Line 1252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1248: ----------------------------------------
1249:
1250: PROCEDURE insert_row(
1251: p_api_version IN NUMBER,
1252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1253: x_return_status OUT NOCOPY VARCHAR2,
1254: x_msg_count OUT NOCOPY NUMBER,
1255: x_msg_data OUT NOCOPY VARCHAR2,
1256: p_srsv_rec IN srsv_rec_type,

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

1257: x_srsv_rec OUT NOCOPY srsv_rec_type) IS
1258:
1259: l_api_version CONSTANT NUMBER := 1;
1260: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1261: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1262: l_srsv_rec srsv_rec_type;
1263: l_def_srsv_rec srsv_rec_type;
1264: l_srs_rec srs_rec_type;
1265: lx_srs_rec srs_rec_type;

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

1285: FUNCTION Set_Attributes (
1286: p_srsv_rec IN srsv_rec_type,
1287: x_srsv_rec OUT NOCOPY srsv_rec_type
1288: ) RETURN VARCHAR2 IS
1289: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1290: BEGIN
1291: x_srsv_rec := p_srsv_rec;
1292: x_srsv_rec.OBJECT_VERSION_NUMBER := 1;
1293: RETURN(l_return_status);

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

1292: x_srsv_rec.OBJECT_VERSION_NUMBER := 1;
1293: RETURN(l_return_status);
1294: END Set_Attributes;
1295: BEGIN
1296: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1297: G_PKG_NAME,
1298: p_init_msg_list,
1299: l_api_version,
1300: p_api_version,

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

1299: l_api_version,
1300: p_api_version,
1301: '_PVT',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;

Line 1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1300: p_api_version,
1301: '_PVT',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: l_srsv_rec := null_out_defaults(p_srsv_rec);

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

1301: '_PVT',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: l_srsv_rec := null_out_defaults(p_srsv_rec);
1309: -- Set primary key value

Line 1306: RAISE OKC_API.G_EXCEPTION_ERROR;

1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: l_srsv_rec := null_out_defaults(p_srsv_rec);
1309: -- Set primary key value
1310: l_srsv_rec.ID := get_seq_id;

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

1312: l_return_status := Set_Attributes(
1313: l_srsv_rec, -- IN
1314: l_def_srsv_rec); -- OUT
1315: --- If any errors happen abort API
1316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: END IF;

Line 1317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1313: l_srsv_rec, -- IN
1314: l_def_srsv_rec); -- OUT
1315: --- If any errors happen abort API
1316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: END IF;
1321: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);

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

1314: l_def_srsv_rec); -- OUT
1315: --- If any errors happen abort API
1316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: END IF;
1321: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
1322: --- Validate all non-missing attributes (Item Level Validation)

Line 1319: RAISE OKC_API.G_EXCEPTION_ERROR;

1315: --- If any errors happen abort API
1316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: END IF;
1321: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
1322: --- Validate all non-missing attributes (Item Level Validation)
1323: l_return_status := Validate_Attributes(l_def_srsv_rec);

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

1321: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
1322: --- Validate all non-missing attributes (Item Level Validation)
1323: l_return_status := Validate_Attributes(l_def_srsv_rec);
1324: --- If any errors happen abort API
1325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;

Line 1326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1322: --- Validate all non-missing attributes (Item Level Validation)
1323: l_return_status := Validate_Attributes(l_def_srsv_rec);
1324: --- If any errors happen abort API
1325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_return_status := Validate_Record(l_def_srsv_rec);

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

1323: l_return_status := Validate_Attributes(l_def_srsv_rec);
1324: --- If any errors happen abort API
1325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_return_status := Validate_Record(l_def_srsv_rec);
1331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1328: RAISE OKC_API.G_EXCEPTION_ERROR;

1324: --- If any errors happen abort API
1325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_return_status := Validate_Record(l_def_srsv_rec);
1331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_return_status := Validate_Record(l_def_srsv_rec);
1331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;

Line 1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1328: RAISE OKC_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_return_status := Validate_Record(l_def_srsv_rec);
1331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;
1336: --------------------------------------

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

1329: END IF;
1330: l_return_status := Validate_Record(l_def_srsv_rec);
1331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;
1336: --------------------------------------
1337: -- Move VIEW record to "Child" records

Line 1334: RAISE OKC_API.G_EXCEPTION_ERROR;

1330: l_return_status := Validate_Record(l_def_srsv_rec);
1331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;
1336: --------------------------------------
1337: -- Move VIEW record to "Child" records
1338: --------------------------------------

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

1347: x_msg_data,
1348: l_srs_rec,
1349: lx_srs_rec
1350: );
1351: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1352: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1353: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_ERROR;
1355: END IF;

Line 1352: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1348: l_srs_rec,
1349: lx_srs_rec
1350: );
1351: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1352: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1353: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_ERROR;
1355: END IF;
1356: migrate(lx_srs_rec, l_def_srsv_rec);

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

1349: lx_srs_rec
1350: );
1351: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1352: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1353: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_ERROR;
1355: END IF;
1356: migrate(lx_srs_rec, l_def_srsv_rec);
1357: -- Set OUT values

Line 1354: RAISE OKC_API.G_EXCEPTION_ERROR;

1350: );
1351: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1352: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1353: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1354: RAISE OKC_API.G_EXCEPTION_ERROR;
1355: END IF;
1356: migrate(lx_srs_rec, l_def_srsv_rec);
1357: -- Set OUT values
1358: x_srsv_rec := l_def_srsv_rec;

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

1355: END IF;
1356: migrate(lx_srs_rec, l_def_srsv_rec);
1357: -- Set OUT values
1358: x_srsv_rec := l_def_srsv_rec;
1359: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1360:
1361: EXCEPTION
1362: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1363: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1362: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1358: x_srsv_rec := l_def_srsv_rec;
1359: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1360:
1361: EXCEPTION
1362: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1363: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,

Line 1363: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1359: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1360:
1361: EXCEPTION
1362: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1363: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,
1367: 'OKC_API.G_RET_STS_ERROR',

Line 1367: 'OKC_API.G_RET_STS_ERROR',

1363: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,
1367: 'OKC_API.G_RET_STS_ERROR',
1368: x_msg_count,
1369: x_msg_data,
1370: '_PVT'
1371: );

Line 1372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1368: x_msg_count,
1369: x_msg_data,
1370: '_PVT'
1371: );
1372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1373: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,

Line 1373: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1369: x_msg_data,
1370: '_PVT'
1371: );
1372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1373: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,
1377: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1377: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1373: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,
1377: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1378: x_msg_count,
1379: x_msg_data,
1380: '_PVT'
1381: );

Line 1383: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1379: x_msg_data,
1380: '_PVT'
1381: );
1382: WHEN OTHERS THEN
1383: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1384: (
1385: l_api_name,
1386: G_PKG_NAME,
1387: 'OTHERS',

Line 1401: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1397: -- PL/SQL TBL insert_row for:SRSV_TBL --
1398: ----------------------------------------
1399: PROCEDURE insert_row(
1400: p_api_version IN NUMBER,
1401: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1402: x_return_status OUT NOCOPY VARCHAR2,
1403: x_msg_count OUT NOCOPY NUMBER,
1404: x_msg_data OUT NOCOPY VARCHAR2,
1405: p_srsv_tbl IN srsv_tbl_type,

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

1406: x_srsv_tbl OUT NOCOPY srsv_tbl_type) IS
1407:
1408: l_api_version CONSTANT NUMBER := 1;
1409: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1410: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1411: i NUMBER := 0;
1412: -- START change : mvasudev, 09/05/2001
1413: -- Adding OverAll Status Flag
1414: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

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

1410: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1411: i NUMBER := 0;
1412: -- START change : mvasudev, 09/05/2001
1413: -- Adding OverAll Status Flag
1414: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1415: -- END change : mvasudev
1416: BEGIN
1417: OKC_API.init_msg_list(p_init_msg_list);
1418: -- Make sure PL/SQL table has records in it before passing

Line 1417: OKC_API.init_msg_list(p_init_msg_list);

1413: -- Adding OverAll Status Flag
1414: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1415: -- END change : mvasudev
1416: BEGIN
1417: OKC_API.init_msg_list(p_init_msg_list);
1418: -- Make sure PL/SQL table has records in it before passing
1419: IF (p_srsv_tbl.COUNT > 0) THEN
1420: i := p_srsv_tbl.FIRST;
1421: LOOP

Line 1424: p_init_msg_list => OKC_API.G_FALSE,

1420: i := p_srsv_tbl.FIRST;
1421: LOOP
1422: insert_row (
1423: p_api_version => p_api_version,
1424: p_init_msg_list => OKC_API.G_FALSE,
1425: x_return_status => x_return_status,
1426: x_msg_count => x_msg_count,
1427: x_msg_data => x_msg_data,
1428: p_srsv_rec => p_srsv_tbl(i),

Line 1432: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1428: p_srsv_rec => p_srsv_tbl(i),
1429: x_srsv_rec => x_srsv_tbl(i));
1430: -- START change : mvasudev, 09/05/2001
1431: -- store the highest degree of error
1432: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1433: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1434: l_overall_status := x_return_status;
1435: END IF;
1436: END IF;

Line 1433: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1429: x_srsv_rec => x_srsv_tbl(i));
1430: -- START change : mvasudev, 09/05/2001
1431: -- store the highest degree of error
1432: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1433: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1434: l_overall_status := x_return_status;
1435: END IF;
1436: END IF;
1437: -- END change : mvasudev

Line 1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1443: x_return_status := l_overall_status;
1444: -- END change : mvasudev
1445: END IF;
1446: EXCEPTION
1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,

Line 1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1444: -- END change : mvasudev
1445: END IF;
1446: EXCEPTION
1447: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,
1452: 'OKC_API.G_RET_STS_ERROR',

Line 1452: 'OKC_API.G_RET_STS_ERROR',

1448: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,
1452: 'OKC_API.G_RET_STS_ERROR',
1453: x_msg_count,
1454: x_msg_data,
1455: '_PVT'
1456: );

Line 1457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1453: x_msg_count,
1454: x_msg_data,
1455: '_PVT'
1456: );
1457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,

Line 1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1454: x_msg_data,
1455: '_PVT'
1456: );
1457: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,
1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1458: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,
1462: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1463: x_msg_count,
1464: x_msg_data,
1465: '_PVT'
1466: );

Line 1468: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1464: x_msg_data,
1465: '_PVT'
1466: );
1467: WHEN OTHERS THEN
1468: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1469: (
1470: l_api_name,
1471: G_PKG_NAME,
1472: 'OTHERS',

Line 1486: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1482: ------------------------------------
1483: -- lock_row for:OKL_SIF_RET_STRMS --
1484: ------------------------------------
1485: PROCEDURE lock_row(
1486: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1487: x_return_status OUT NOCOPY VARCHAR2,
1488: x_msg_count OUT NOCOPY NUMBER,
1489: x_msg_data OUT NOCOPY VARCHAR2,
1490: p_srs_rec IN srs_rec_type) IS

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

1503: FROM OKL_SIF_RET_STRMS
1504: WHERE ID = p_srs_rec.id;
1505: l_api_version CONSTANT NUMBER := 1;
1506: l_api_name CONSTANT VARCHAR2(30) := 'STRMS_lock_row';
1507: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1508: l_object_version_number OKL_SIF_RET_STRMS.OBJECT_VERSION_NUMBER%TYPE;
1509: lc_object_version_number OKL_SIF_RET_STRMS.OBJECT_VERSION_NUMBER%TYPE;
1510: l_row_notfound BOOLEAN := FALSE;
1511: lc_row_notfound BOOLEAN := FALSE;

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

1509: lc_object_version_number OKL_SIF_RET_STRMS.OBJECT_VERSION_NUMBER%TYPE;
1510: l_row_notfound BOOLEAN := FALSE;
1511: lc_row_notfound BOOLEAN := FALSE;
1512: BEGIN
1513: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1514: p_init_msg_list,
1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1513: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1514: p_init_msg_list,
1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;

Line 1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1514: p_init_msg_list,
1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;
1522: BEGIN

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

1515: '_PVT',
1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;
1522: BEGIN
1523: OPEN lock_csr(p_srs_rec);

Line 1520: RAISE OKC_API.G_EXCEPTION_ERROR;

1516: x_return_status);
1517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_ERROR;
1521: END IF;
1522: BEGIN
1523: OPEN lock_csr(p_srs_rec);
1524: FETCH lock_csr INTO l_object_version_number;

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

1528: WHEN E_Resource_Busy THEN
1529: IF (lock_csr%ISOPEN) THEN
1530: CLOSE lock_csr;
1531: END IF;
1532: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1533: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1534: END;
1535:
1536: IF ( l_row_notfound ) THEN

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

1539: lc_row_notfound := lchk_csr%NOTFOUND;
1540: CLOSE lchk_csr;
1541: END IF;
1542: IF (lc_row_notfound) THEN
1543: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1544: RAISE OKC_API.G_EXCEPTION_ERROR;
1545: ELSIF lc_object_version_number > p_srs_rec.object_version_number THEN
1546: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1547: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1544: RAISE OKC_API.G_EXCEPTION_ERROR;

1540: CLOSE lchk_csr;
1541: END IF;
1542: IF (lc_row_notfound) THEN
1543: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1544: RAISE OKC_API.G_EXCEPTION_ERROR;
1545: ELSIF lc_object_version_number > p_srs_rec.object_version_number THEN
1546: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: ELSIF lc_object_version_number <> p_srs_rec.object_version_number THEN

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

1542: IF (lc_row_notfound) THEN
1543: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1544: RAISE OKC_API.G_EXCEPTION_ERROR;
1545: ELSIF lc_object_version_number > p_srs_rec.object_version_number THEN
1546: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: ELSIF lc_object_version_number <> p_srs_rec.object_version_number THEN
1549: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1550: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1547: RAISE OKC_API.G_EXCEPTION_ERROR;

1543: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1544: RAISE OKC_API.G_EXCEPTION_ERROR;
1545: ELSIF lc_object_version_number > p_srs_rec.object_version_number THEN
1546: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: ELSIF lc_object_version_number <> p_srs_rec.object_version_number THEN
1549: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1550: RAISE OKC_API.G_EXCEPTION_ERROR;
1551: ELSIF lc_object_version_number = -1 THEN

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

1545: ELSIF lc_object_version_number > p_srs_rec.object_version_number THEN
1546: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: ELSIF lc_object_version_number <> p_srs_rec.object_version_number THEN
1549: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1550: RAISE OKC_API.G_EXCEPTION_ERROR;
1551: ELSIF lc_object_version_number = -1 THEN
1552: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1553: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1550: RAISE OKC_API.G_EXCEPTION_ERROR;

1546: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: ELSIF lc_object_version_number <> p_srs_rec.object_version_number THEN
1549: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1550: RAISE OKC_API.G_EXCEPTION_ERROR;
1551: ELSIF lc_object_version_number = -1 THEN
1552: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1553: RAISE OKC_API.G_EXCEPTION_ERROR;
1554: END IF;

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

1548: ELSIF lc_object_version_number <> p_srs_rec.object_version_number THEN
1549: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1550: RAISE OKC_API.G_EXCEPTION_ERROR;
1551: ELSIF lc_object_version_number = -1 THEN
1552: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1553: RAISE OKC_API.G_EXCEPTION_ERROR;
1554: END IF;
1555: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1556: EXCEPTION

Line 1553: RAISE OKC_API.G_EXCEPTION_ERROR;

1549: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1550: RAISE OKC_API.G_EXCEPTION_ERROR;
1551: ELSIF lc_object_version_number = -1 THEN
1552: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1553: RAISE OKC_API.G_EXCEPTION_ERROR;
1554: END IF;
1555: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1556: EXCEPTION
1557: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1551: ELSIF lc_object_version_number = -1 THEN
1552: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1553: RAISE OKC_API.G_EXCEPTION_ERROR;
1554: END IF;
1555: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1556: EXCEPTION
1557: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1558: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1559: (

Line 1557: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1553: RAISE OKC_API.G_EXCEPTION_ERROR;
1554: END IF;
1555: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1556: EXCEPTION
1557: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1558: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,

Line 1558: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1554: END IF;
1555: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1556: EXCEPTION
1557: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1558: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,
1562: 'OKC_API.G_RET_STS_ERROR',

Line 1562: 'OKC_API.G_RET_STS_ERROR',

1558: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,
1562: 'OKC_API.G_RET_STS_ERROR',
1563: x_msg_count,
1564: x_msg_data,
1565: '_PVT'
1566: );

Line 1567: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1563: x_msg_count,
1564: x_msg_data,
1565: '_PVT'
1566: );
1567: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1568: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1569: (
1570: l_api_name,
1571: G_PKG_NAME,

Line 1568: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1564: x_msg_data,
1565: '_PVT'
1566: );
1567: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1568: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1569: (
1570: l_api_name,
1571: G_PKG_NAME,
1572: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1572: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1568: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1569: (
1570: l_api_name,
1571: G_PKG_NAME,
1572: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1573: x_msg_count,
1574: x_msg_data,
1575: '_PVT'
1576: );

Line 1578: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1574: x_msg_data,
1575: '_PVT'
1576: );
1577: WHEN OTHERS THEN
1578: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1579: (
1580: l_api_name,
1581: G_PKG_NAME,
1582: 'OTHERS',

Line 1593: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1589: -- lock_row for:OKL_SIF_RET_STRMS_V --
1590: --------------------------------------
1591: PROCEDURE lock_row(
1592: p_api_version IN NUMBER,
1593: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1594: x_return_status OUT NOCOPY VARCHAR2,
1595: x_msg_count OUT NOCOPY NUMBER,
1596: x_msg_data OUT NOCOPY VARCHAR2,
1597: p_srsv_rec IN srsv_rec_type) IS

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

1597: p_srsv_rec IN srsv_rec_type) IS
1598:
1599: l_api_version CONSTANT NUMBER := 1;
1600: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1601: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1602: l_srs_rec srs_rec_type;
1603: BEGIN
1604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1605: G_PKG_NAME,

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

1600: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1601: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1602: l_srs_rec srs_rec_type;
1603: BEGIN
1604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1605: G_PKG_NAME,
1606: p_init_msg_list,
1607: l_api_version,
1608: p_api_version,

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

1607: l_api_version,
1608: p_api_version,
1609: '_PVT',
1610: x_return_status);
1611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_ERROR;
1615: END IF;

Line 1612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1608: p_api_version,
1609: '_PVT',
1610: x_return_status);
1611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_ERROR;
1615: END IF;
1616: --------------------------------------

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

1609: '_PVT',
1610: x_return_status);
1611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_ERROR;
1615: END IF;
1616: --------------------------------------
1617: -- Move VIEW record to "Child" records

Line 1614: RAISE OKC_API.G_EXCEPTION_ERROR;

1610: x_return_status);
1611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_ERROR;
1615: END IF;
1616: --------------------------------------
1617: -- Move VIEW record to "Child" records
1618: --------------------------------------

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

1626: x_msg_count,
1627: x_msg_data,
1628: l_srs_rec
1629: );
1630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1633: RAISE OKC_API.G_EXCEPTION_ERROR;
1634: END IF;

Line 1631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1627: x_msg_data,
1628: l_srs_rec
1629: );
1630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1633: RAISE OKC_API.G_EXCEPTION_ERROR;
1634: END IF;
1635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1628: l_srs_rec
1629: );
1630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1633: RAISE OKC_API.G_EXCEPTION_ERROR;
1634: END IF;
1635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1636: EXCEPTION

Line 1633: RAISE OKC_API.G_EXCEPTION_ERROR;

1629: );
1630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1633: RAISE OKC_API.G_EXCEPTION_ERROR;
1634: END IF;
1635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1636: EXCEPTION
1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1633: RAISE OKC_API.G_EXCEPTION_ERROR;
1634: END IF;
1635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1636: EXCEPTION
1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1638: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1639: (

Line 1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1633: RAISE OKC_API.G_EXCEPTION_ERROR;
1634: END IF;
1635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1636: EXCEPTION
1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1638: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1639: (
1640: l_api_name,
1641: G_PKG_NAME,

Line 1638: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1634: END IF;
1635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1636: EXCEPTION
1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1638: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1639: (
1640: l_api_name,
1641: G_PKG_NAME,
1642: 'OKC_API.G_RET_STS_ERROR',

Line 1642: 'OKC_API.G_RET_STS_ERROR',

1638: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1639: (
1640: l_api_name,
1641: G_PKG_NAME,
1642: 'OKC_API.G_RET_STS_ERROR',
1643: x_msg_count,
1644: x_msg_data,
1645: '_PVT'
1646: );

Line 1647: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1643: x_msg_count,
1644: x_msg_data,
1645: '_PVT'
1646: );
1647: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1648: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1649: (
1650: l_api_name,
1651: G_PKG_NAME,

Line 1648: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1644: x_msg_data,
1645: '_PVT'
1646: );
1647: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1648: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1649: (
1650: l_api_name,
1651: G_PKG_NAME,
1652: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1652: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1648: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1649: (
1650: l_api_name,
1651: G_PKG_NAME,
1652: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1653: x_msg_count,
1654: x_msg_data,
1655: '_PVT'
1656: );

Line 1658: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1654: x_msg_data,
1655: '_PVT'
1656: );
1657: WHEN OTHERS THEN
1658: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1659: (
1660: l_api_name,
1661: G_PKG_NAME,
1662: 'OTHERS',

Line 1673: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1669: -- PL/SQL TBL lock_row for:SRSV_TBL --
1670: --------------------------------------
1671: PROCEDURE lock_row(
1672: p_api_version IN NUMBER,
1673: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1674: x_return_status OUT NOCOPY VARCHAR2,
1675: x_msg_count OUT NOCOPY NUMBER,
1676: x_msg_data OUT NOCOPY VARCHAR2,
1677: p_srsv_tbl IN srsv_tbl_type) IS

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

1677: p_srsv_tbl IN srsv_tbl_type) IS
1678:
1679: l_api_version CONSTANT NUMBER := 1;
1680: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1682: i NUMBER := 0;
1683: -- START change : mvasudev, 09/05/2001
1684: -- Adding OverAll Status Flag
1685: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

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

1681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1682: i NUMBER := 0;
1683: -- START change : mvasudev, 09/05/2001
1684: -- Adding OverAll Status Flag
1685: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1686: -- END change : mvasudev
1687: BEGIN
1688: OKC_API.init_msg_list(p_init_msg_list);
1689: -- Make sure PL/SQL table has records in it before passing

Line 1688: OKC_API.init_msg_list(p_init_msg_list);

1684: -- Adding OverAll Status Flag
1685: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1686: -- END change : mvasudev
1687: BEGIN
1688: OKC_API.init_msg_list(p_init_msg_list);
1689: -- Make sure PL/SQL table has records in it before passing
1690: IF (p_srsv_tbl.COUNT > 0) THEN
1691: i := p_srsv_tbl.FIRST;
1692: LOOP

Line 1695: p_init_msg_list => OKC_API.G_FALSE,

1691: i := p_srsv_tbl.FIRST;
1692: LOOP
1693: lock_row (
1694: p_api_version => p_api_version,
1695: p_init_msg_list => OKC_API.G_FALSE,
1696: x_return_status => x_return_status,
1697: x_msg_count => x_msg_count,
1698: x_msg_data => x_msg_data,
1699: p_srsv_rec => p_srsv_tbl(i));

Line 1702: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1698: x_msg_data => x_msg_data,
1699: p_srsv_rec => p_srsv_tbl(i));
1700: -- START change : mvasudev, 09/05/2001
1701: -- store the highest degree of error
1702: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1703: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1704: l_overall_status := x_return_status;
1705: END IF;
1706: END IF;

Line 1703: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1699: p_srsv_rec => p_srsv_tbl(i));
1700: -- START change : mvasudev, 09/05/2001
1701: -- store the highest degree of error
1702: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1703: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1704: l_overall_status := x_return_status;
1705: END IF;
1706: END IF;
1707: -- END change : mvasudev

Line 1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1713: x_return_status := l_overall_status;
1714: -- END change : mvasudev
1715: END IF;
1716: EXCEPTION
1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,

Line 1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1714: -- END change : mvasudev
1715: END IF;
1716: EXCEPTION
1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,
1722: 'OKC_API.G_RET_STS_ERROR',

Line 1722: 'OKC_API.G_RET_STS_ERROR',

1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,
1722: 'OKC_API.G_RET_STS_ERROR',
1723: x_msg_count,
1724: x_msg_data,
1725: '_PVT'
1726: );

Line 1727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1723: x_msg_count,
1724: x_msg_data,
1725: '_PVT'
1726: );
1727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1728: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1729: (
1730: l_api_name,
1731: G_PKG_NAME,

Line 1728: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1732: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1728: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1729: (
1730: l_api_name,
1731: G_PKG_NAME,
1732: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1733: x_msg_count,
1734: x_msg_data,
1735: '_PVT'
1736: );

Line 1738: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1734: x_msg_data,
1735: '_PVT'
1736: );
1737: WHEN OTHERS THEN
1738: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,
1742: 'OTHERS',

Line 1756: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1752: --------------------------------------
1753: -- update_row for:OKL_SIF_RET_STRMS --
1754: --------------------------------------
1755: PROCEDURE update_row(
1756: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1757: x_return_status OUT NOCOPY VARCHAR2,
1758: x_msg_count OUT NOCOPY NUMBER,
1759: x_msg_data OUT NOCOPY VARCHAR2,
1760: p_srs_rec IN srs_rec_type,

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

1761: x_srs_rec OUT NOCOPY srs_rec_type) IS
1762:
1763: l_api_version CONSTANT NUMBER := 1;
1764: l_api_name CONSTANT VARCHAR2(30) := 'STRMS_update_row';
1765: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1766: l_srs_rec srs_rec_type := p_srs_rec;
1767: l_def_srs_rec srs_rec_type;
1768: l_row_notfound BOOLEAN := TRUE;
1769: ----------------------------------

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

1774: x_srs_rec OUT NOCOPY srs_rec_type
1775: ) RETURN VARCHAR2 IS
1776: l_srs_rec srs_rec_type;
1777: l_row_notfound BOOLEAN := TRUE;
1778: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1779: BEGIN
1780: x_srs_rec := p_srs_rec;
1781: -- Get current database values
1782: l_srs_rec := get_rec(p_srs_rec, l_row_notfound);

Line 1784: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1780: x_srs_rec := p_srs_rec;
1781: -- Get current database values
1782: l_srs_rec := get_rec(p_srs_rec, l_row_notfound);
1783: IF (l_row_notfound) THEN
1784: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1785: END IF;
1786: IF (x_srs_rec.id IS NULL)
1787: THEN
1788: x_srs_rec.id := l_srs_rec.id;

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

1907: FUNCTION Set_Attributes (
1908: p_srs_rec IN srs_rec_type,
1909: x_srs_rec OUT NOCOPY srs_rec_type
1910: ) RETURN VARCHAR2 IS
1911: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1912: BEGIN
1913: x_srs_rec := p_srs_rec;
1914: RETURN(l_return_status);
1915: END Set_Attributes;

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

1913: x_srs_rec := p_srs_rec;
1914: RETURN(l_return_status);
1915: END Set_Attributes;
1916: BEGIN
1917: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1918: p_init_msg_list,
1919: '_PVT',
1920: x_return_status);
1921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1917: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1918: p_init_msg_list,
1919: '_PVT',
1920: x_return_status);
1921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1924: RAISE OKC_API.G_EXCEPTION_ERROR;
1925: END IF;

Line 1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1918: p_init_msg_list,
1919: '_PVT',
1920: x_return_status);
1921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1924: RAISE OKC_API.G_EXCEPTION_ERROR;
1925: END IF;
1926: --- Setting item attributes

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

1919: '_PVT',
1920: x_return_status);
1921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1924: RAISE OKC_API.G_EXCEPTION_ERROR;
1925: END IF;
1926: --- Setting item attributes
1927: l_return_status := Set_Attributes(

Line 1924: RAISE OKC_API.G_EXCEPTION_ERROR;

1920: x_return_status);
1921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1924: RAISE OKC_API.G_EXCEPTION_ERROR;
1925: END IF;
1926: --- Setting item attributes
1927: l_return_status := Set_Attributes(
1928: p_srs_rec, -- IN

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

1927: l_return_status := Set_Attributes(
1928: p_srs_rec, -- IN
1929: l_srs_rec); -- OUT
1930: --- If any errors happen abort API
1931: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1933: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1934: RAISE OKC_API.G_EXCEPTION_ERROR;
1935: END IF;

Line 1932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1928: p_srs_rec, -- IN
1929: l_srs_rec); -- OUT
1930: --- If any errors happen abort API
1931: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1933: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1934: RAISE OKC_API.G_EXCEPTION_ERROR;
1935: END IF;
1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);

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

1929: l_srs_rec); -- OUT
1930: --- If any errors happen abort API
1931: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1933: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1934: RAISE OKC_API.G_EXCEPTION_ERROR;
1935: END IF;
1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);
1937: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1934: RAISE OKC_API.G_EXCEPTION_ERROR;

1930: --- If any errors happen abort API
1931: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1932: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1933: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1934: RAISE OKC_API.G_EXCEPTION_ERROR;
1935: END IF;
1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);
1937: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1933: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1934: RAISE OKC_API.G_EXCEPTION_ERROR;
1935: END IF;
1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);
1937: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1940: RAISE OKC_API.G_EXCEPTION_ERROR;
1941: END IF;

Line 1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1934: RAISE OKC_API.G_EXCEPTION_ERROR;
1935: END IF;
1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);
1937: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1940: RAISE OKC_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: UPDATE OKL_SIF_RET_STRMS

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

1935: END IF;
1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);
1937: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1940: RAISE OKC_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: UPDATE OKL_SIF_RET_STRMS
1943: SET STREAM_TYPE_NAME = l_def_srs_rec.stream_type_name,

Line 1940: RAISE OKC_API.G_EXCEPTION_ERROR;

1936: l_return_status := populate_new_record(l_srs_rec, l_def_srs_rec);
1937: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1940: RAISE OKC_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: UPDATE OKL_SIF_RET_STRMS
1943: SET STREAM_TYPE_NAME = l_def_srs_rec.stream_type_name,
1944: INDEX_NUMBER = l_def_srs_rec.index_number,

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

1970: LAST_UPDATE_LOGIN = l_def_srs_rec.last_update_login
1971: WHERE ID = l_def_srs_rec.id;
1972:
1973: x_srs_rec := l_def_srs_rec;
1974: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1975: EXCEPTION
1976: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1977: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1978: (

Line 1976: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1972:
1973: x_srs_rec := l_def_srs_rec;
1974: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1975: EXCEPTION
1976: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1977: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1978: (
1979: l_api_name,
1980: G_PKG_NAME,

Line 1977: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1973: x_srs_rec := l_def_srs_rec;
1974: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1975: EXCEPTION
1976: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1977: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1978: (
1979: l_api_name,
1980: G_PKG_NAME,
1981: 'OKC_API.G_RET_STS_ERROR',

Line 1981: 'OKC_API.G_RET_STS_ERROR',

1977: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1978: (
1979: l_api_name,
1980: G_PKG_NAME,
1981: 'OKC_API.G_RET_STS_ERROR',
1982: x_msg_count,
1983: x_msg_data,
1984: '_PVT'
1985: );

Line 1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1982: x_msg_count,
1983: x_msg_data,
1984: '_PVT'
1985: );
1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1987: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1988: (
1989: l_api_name,
1990: G_PKG_NAME,

Line 1987: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1983: x_msg_data,
1984: '_PVT'
1985: );
1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1987: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1988: (
1989: l_api_name,
1990: G_PKG_NAME,
1991: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1991: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1987: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1988: (
1989: l_api_name,
1990: G_PKG_NAME,
1991: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1992: x_msg_count,
1993: x_msg_data,
1994: '_PVT'
1995: );

Line 1997: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1993: x_msg_data,
1994: '_PVT'
1995: );
1996: WHEN OTHERS THEN
1997: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1998: (
1999: l_api_name,
2000: G_PKG_NAME,
2001: 'OTHERS',

Line 2012: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2008: -- update_row for:OKL_SIF_RET_STRMS_V --
2009: ----------------------------------------
2010: PROCEDURE update_row(
2011: p_api_version IN NUMBER,
2012: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2013: x_return_status OUT NOCOPY VARCHAR2,
2014: x_msg_count OUT NOCOPY NUMBER,
2015: x_msg_data OUT NOCOPY VARCHAR2,
2016: p_srsv_rec IN srsv_rec_type,

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

2017: x_srsv_rec OUT NOCOPY srsv_rec_type) IS
2018:
2019: l_api_version CONSTANT NUMBER := 1;
2020: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2021: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2022: l_srsv_rec srsv_rec_type := p_srsv_rec;
2023: l_def_srsv_rec srsv_rec_type;
2024: l_srs_rec srs_rec_type;
2025: lx_srs_rec srs_rec_type;

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

2044: x_srsv_rec OUT NOCOPY srsv_rec_type
2045: ) RETURN VARCHAR2 IS
2046: l_srsv_rec srsv_rec_type;
2047: l_row_notfound BOOLEAN := TRUE;
2048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2049: BEGIN
2050: x_srsv_rec := p_srsv_rec;
2051: -- Get current database values
2052: l_srsv_rec := get_rec(p_srsv_rec, l_row_notfound);

Line 2054: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2050: x_srsv_rec := p_srsv_rec;
2051: -- Get current database values
2052: l_srsv_rec := get_rec(p_srsv_rec, l_row_notfound);
2053: IF (l_row_notfound) THEN
2054: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2055: END IF;
2056: IF (x_srsv_rec.id IS NULL)
2057: THEN
2058: x_srsv_rec.id := l_srsv_rec.id;

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

2177: FUNCTION Set_Attributes (
2178: p_srsv_rec IN srsv_rec_type,
2179: x_srsv_rec OUT NOCOPY srsv_rec_type
2180: ) RETURN VARCHAR2 IS
2181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2182: BEGIN
2183: x_srsv_rec := p_srsv_rec;
2184: x_srsv_rec.OBJECT_VERSION_NUMBER := NVL(x_srsv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2185: RETURN(l_return_status);

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

2184: x_srsv_rec.OBJECT_VERSION_NUMBER := NVL(x_srsv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2185: RETURN(l_return_status);
2186: END Set_Attributes;
2187: BEGIN
2188: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2189: G_PKG_NAME,
2190: p_init_msg_list,
2191: l_api_version,
2192: p_api_version,

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

2191: l_api_version,
2192: p_api_version,
2193: '_PVT',
2194: x_return_status);
2195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_ERROR;
2199: END IF;

Line 2196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2192: p_api_version,
2193: '_PVT',
2194: x_return_status);
2195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_ERROR;
2199: END IF;
2200: --- Setting item attributes

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

2193: '_PVT',
2194: x_return_status);
2195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_ERROR;
2199: END IF;
2200: --- Setting item attributes
2201: l_return_status := Set_Attributes(

Line 2198: RAISE OKC_API.G_EXCEPTION_ERROR;

2194: x_return_status);
2195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_ERROR;
2199: END IF;
2200: --- Setting item attributes
2201: l_return_status := Set_Attributes(
2202: p_srsv_rec, -- IN

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

2201: l_return_status := Set_Attributes(
2202: p_srsv_rec, -- IN
2203: l_srsv_rec); -- OUT
2204: --- If any errors happen abort API
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;

Line 2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2202: p_srsv_rec, -- IN
2203: l_srsv_rec); -- OUT
2204: --- If any errors happen abort API
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: /*

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

2203: l_srsv_rec); -- OUT
2204: --- If any errors happen abort API
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: /*
2211: l_return_status := populate_new_record(l_srsv_rec, l_def_srsv_rec);

Line 2208: RAISE OKC_API.G_EXCEPTION_ERROR;

2204: --- If any errors happen abort API
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: /*
2211: l_return_status := populate_new_record(l_srsv_rec, l_def_srsv_rec);
2212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: /*
2211: l_return_status := populate_new_record(l_srsv_rec, l_def_srsv_rec);
2212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2215: RAISE OKC_API.G_EXCEPTION_ERROR;
2216: END IF;

Line 2213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2209: END IF;
2210: /*
2211: l_return_status := populate_new_record(l_srsv_rec, l_def_srsv_rec);
2212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2215: RAISE OKC_API.G_EXCEPTION_ERROR;
2216: END IF;
2217: */

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

2210: /*
2211: l_return_status := populate_new_record(l_srsv_rec, l_def_srsv_rec);
2212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2215: RAISE OKC_API.G_EXCEPTION_ERROR;
2216: END IF;
2217: */
2218: l_def_srsv_rec := fill_who_columns(l_srsv_rec);

Line 2215: RAISE OKC_API.G_EXCEPTION_ERROR;

2211: l_return_status := populate_new_record(l_srsv_rec, l_def_srsv_rec);
2212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2215: RAISE OKC_API.G_EXCEPTION_ERROR;
2216: END IF;
2217: */
2218: l_def_srsv_rec := fill_who_columns(l_srsv_rec);
2219: --- Validate all non-missing attributes (Item Level Validation)

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

2220:
2221: /*
2222: l_return_status := Validate_Attributes(l_def_srsv_rec);
2223: --- If any errors happen abort API
2224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2227: RAISE OKC_API.G_EXCEPTION_ERROR;
2228: END IF;

Line 2225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2221: /*
2222: l_return_status := Validate_Attributes(l_def_srsv_rec);
2223: --- If any errors happen abort API
2224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2227: RAISE OKC_API.G_EXCEPTION_ERROR;
2228: END IF;
2229: l_return_status := Validate_Record(l_def_srsv_rec);

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

2222: l_return_status := Validate_Attributes(l_def_srsv_rec);
2223: --- If any errors happen abort API
2224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2227: RAISE OKC_API.G_EXCEPTION_ERROR;
2228: END IF;
2229: l_return_status := Validate_Record(l_def_srsv_rec);
2230: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2227: RAISE OKC_API.G_EXCEPTION_ERROR;

2223: --- If any errors happen abort API
2224: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2225: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2227: RAISE OKC_API.G_EXCEPTION_ERROR;
2228: END IF;
2229: l_return_status := Validate_Record(l_def_srsv_rec);
2230: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2226: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2227: RAISE OKC_API.G_EXCEPTION_ERROR;
2228: END IF;
2229: l_return_status := Validate_Record(l_def_srsv_rec);
2230: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2232: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2233: RAISE OKC_API.G_EXCEPTION_ERROR;
2234: END IF;

Line 2231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2227: RAISE OKC_API.G_EXCEPTION_ERROR;
2228: END IF;
2229: l_return_status := Validate_Record(l_def_srsv_rec);
2230: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2232: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2233: RAISE OKC_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: */

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

2228: END IF;
2229: l_return_status := Validate_Record(l_def_srsv_rec);
2230: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2232: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2233: RAISE OKC_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: */
2236: --------------------------------------

Line 2233: RAISE OKC_API.G_EXCEPTION_ERROR;

2229: l_return_status := Validate_Record(l_def_srsv_rec);
2230: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2231: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2232: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2233: RAISE OKC_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: */
2236: --------------------------------------
2237: -- Move VIEW record to "Child" records

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

2247: x_msg_data,
2248: l_srs_rec,
2249: lx_srs_rec
2250: );
2251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2254: RAISE OKC_API.G_EXCEPTION_ERROR;
2255: END IF;

Line 2252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2248: l_srs_rec,
2249: lx_srs_rec
2250: );
2251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2254: RAISE OKC_API.G_EXCEPTION_ERROR;
2255: END IF;
2256: migrate(lx_srs_rec, l_def_srsv_rec);

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

2249: lx_srs_rec
2250: );
2251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2254: RAISE OKC_API.G_EXCEPTION_ERROR;
2255: END IF;
2256: migrate(lx_srs_rec, l_def_srsv_rec);
2257: x_srsv_rec := l_def_srsv_rec;

Line 2254: RAISE OKC_API.G_EXCEPTION_ERROR;

2250: );
2251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2254: RAISE OKC_API.G_EXCEPTION_ERROR;
2255: END IF;
2256: migrate(lx_srs_rec, l_def_srsv_rec);
2257: x_srsv_rec := l_def_srsv_rec;
2258: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2254: RAISE OKC_API.G_EXCEPTION_ERROR;
2255: END IF;
2256: migrate(lx_srs_rec, l_def_srsv_rec);
2257: x_srsv_rec := l_def_srsv_rec;
2258: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2259: EXCEPTION
2260: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2261: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2262: (

Line 2260: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2256: migrate(lx_srs_rec, l_def_srsv_rec);
2257: x_srsv_rec := l_def_srsv_rec;
2258: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2259: EXCEPTION
2260: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2261: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2262: (
2263: l_api_name,
2264: G_PKG_NAME,

Line 2261: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2257: x_srsv_rec := l_def_srsv_rec;
2258: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2259: EXCEPTION
2260: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2261: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2262: (
2263: l_api_name,
2264: G_PKG_NAME,
2265: 'OKC_API.G_RET_STS_ERROR',

Line 2265: 'OKC_API.G_RET_STS_ERROR',

2261: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2262: (
2263: l_api_name,
2264: G_PKG_NAME,
2265: 'OKC_API.G_RET_STS_ERROR',
2266: x_msg_count,
2267: x_msg_data,
2268: '_PVT'
2269: );

Line 2270: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2266: x_msg_count,
2267: x_msg_data,
2268: '_PVT'
2269: );
2270: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2271: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2272: (
2273: l_api_name,
2274: G_PKG_NAME,

Line 2271: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2267: x_msg_data,
2268: '_PVT'
2269: );
2270: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2271: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2272: (
2273: l_api_name,
2274: G_PKG_NAME,
2275: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2275: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2271: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2272: (
2273: l_api_name,
2274: G_PKG_NAME,
2275: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2276: x_msg_count,
2277: x_msg_data,
2278: '_PVT'
2279: );

Line 2281: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2277: x_msg_data,
2278: '_PVT'
2279: );
2280: WHEN OTHERS THEN
2281: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2282: (
2283: l_api_name,
2284: G_PKG_NAME,
2285: 'OTHERS',

Line 2296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2292: -- PL/SQL TBL update_row for:SRSV_TBL --
2293: ----------------------------------------
2294: PROCEDURE update_row(
2295: p_api_version IN NUMBER,
2296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2297: x_return_status OUT NOCOPY VARCHAR2,
2298: x_msg_count OUT NOCOPY NUMBER,
2299: x_msg_data OUT NOCOPY VARCHAR2,
2300: p_srsv_tbl IN srsv_tbl_type,

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

2301: x_srsv_tbl OUT NOCOPY srsv_tbl_type) IS
2302:
2303: l_api_version CONSTANT NUMBER := 1;
2304: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2305: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2306: i NUMBER := 0;
2307: -- START change : mvasudev, 09/05/2001
2308: -- Adding OverAll Status Flag
2309: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

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

2305: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2306: i NUMBER := 0;
2307: -- START change : mvasudev, 09/05/2001
2308: -- Adding OverAll Status Flag
2309: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2310: -- END change : mvasudev
2311: BEGIN
2312: OKC_API.init_msg_list(p_init_msg_list);
2313: -- Make sure PL/SQL table has records in it before passing

Line 2312: OKC_API.init_msg_list(p_init_msg_list);

2308: -- Adding OverAll Status Flag
2309: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2310: -- END change : mvasudev
2311: BEGIN
2312: OKC_API.init_msg_list(p_init_msg_list);
2313: -- Make sure PL/SQL table has records in it before passing
2314: IF (p_srsv_tbl.COUNT > 0) THEN
2315: i := p_srsv_tbl.FIRST;
2316: LOOP

Line 2319: p_init_msg_list => OKC_API.G_FALSE,

2315: i := p_srsv_tbl.FIRST;
2316: LOOP
2317: update_row (
2318: p_api_version => p_api_version,
2319: p_init_msg_list => OKC_API.G_FALSE,
2320: x_return_status => x_return_status,
2321: x_msg_count => x_msg_count,
2322: x_msg_data => x_msg_data,
2323: p_srsv_rec => p_srsv_tbl(i),

Line 2327: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2323: p_srsv_rec => p_srsv_tbl(i),
2324: x_srsv_rec => x_srsv_tbl(i));
2325: -- START change : mvasudev, 09/05/2001
2326: -- store the highest degree of error
2327: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2328: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2329: l_overall_status := x_return_status;
2330: END IF;
2331: END IF;

Line 2328: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2324: x_srsv_rec => x_srsv_tbl(i));
2325: -- START change : mvasudev, 09/05/2001
2326: -- store the highest degree of error
2327: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2328: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2329: l_overall_status := x_return_status;
2330: END IF;
2331: END IF;
2332: -- END change : mvasudev

Line 2342: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2338: x_return_status := l_overall_status;
2339: -- END change : mvasudev
2340: END IF;
2341: EXCEPTION
2342: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2343: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2344: (
2345: l_api_name,
2346: G_PKG_NAME,

Line 2343: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2339: -- END change : mvasudev
2340: END IF;
2341: EXCEPTION
2342: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2343: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2344: (
2345: l_api_name,
2346: G_PKG_NAME,
2347: 'OKC_API.G_RET_STS_ERROR',

Line 2347: 'OKC_API.G_RET_STS_ERROR',

2343: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2344: (
2345: l_api_name,
2346: G_PKG_NAME,
2347: 'OKC_API.G_RET_STS_ERROR',
2348: x_msg_count,
2349: x_msg_data,
2350: '_PVT'
2351: );

Line 2352: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2348: x_msg_count,
2349: x_msg_data,
2350: '_PVT'
2351: );
2352: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2353: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2354: (
2355: l_api_name,
2356: G_PKG_NAME,

Line 2353: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2349: x_msg_data,
2350: '_PVT'
2351: );
2352: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2353: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2354: (
2355: l_api_name,
2356: G_PKG_NAME,
2357: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2357: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2353: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2354: (
2355: l_api_name,
2356: G_PKG_NAME,
2357: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2358: x_msg_count,
2359: x_msg_data,
2360: '_PVT'
2361: );

Line 2363: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2359: x_msg_data,
2360: '_PVT'
2361: );
2362: WHEN OTHERS THEN
2363: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2364: (
2365: l_api_name,
2366: G_PKG_NAME,
2367: 'OTHERS',

Line 2381: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2377: --------------------------------------
2378: -- delete_row for:OKL_SIF_RET_STRMS --
2379: --------------------------------------
2380: PROCEDURE delete_row(
2381: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2382: x_return_status OUT NOCOPY VARCHAR2,
2383: x_msg_count OUT NOCOPY NUMBER,
2384: x_msg_data OUT NOCOPY VARCHAR2,
2385: p_srs_rec IN srs_rec_type) IS

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

2385: p_srs_rec IN srs_rec_type) IS
2386:
2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'STRMS_delete_row';
2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2390: l_srs_rec srs_rec_type:= p_srs_rec;
2391: l_row_notfound BOOLEAN := TRUE;
2392: BEGIN
2393: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2390: l_srs_rec srs_rec_type:= p_srs_rec;
2391: l_row_notfound BOOLEAN := TRUE;
2392: BEGIN
2393: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2394: p_init_msg_list,
2395: '_PVT',
2396: x_return_status);
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2393: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2394: p_init_msg_list,
2395: '_PVT',
2396: x_return_status);
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2398: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2399: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: END IF;

Line 2398: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2394: p_init_msg_list,
2395: '_PVT',
2396: x_return_status);
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2398: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2399: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: END IF;
2402: DELETE FROM OKL_SIF_RET_STRMS

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

2395: '_PVT',
2396: x_return_status);
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2398: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2399: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: END IF;
2402: DELETE FROM OKL_SIF_RET_STRMS
2403: WHERE ID = l_srs_rec.id;

Line 2400: RAISE OKC_API.G_EXCEPTION_ERROR;

2396: x_return_status);
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2398: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2399: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: END IF;
2402: DELETE FROM OKL_SIF_RET_STRMS
2403: WHERE ID = l_srs_rec.id;
2404:

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

2401: END IF;
2402: DELETE FROM OKL_SIF_RET_STRMS
2403: WHERE ID = l_srs_rec.id;
2404:
2405: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2406: EXCEPTION
2407: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2409: (

Line 2407: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2403: WHERE ID = l_srs_rec.id;
2404:
2405: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2406: EXCEPTION
2407: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2409: (
2410: l_api_name,
2411: G_PKG_NAME,

Line 2408: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2404:
2405: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2406: EXCEPTION
2407: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2409: (
2410: l_api_name,
2411: G_PKG_NAME,
2412: 'OKC_API.G_RET_STS_ERROR',

Line 2412: 'OKC_API.G_RET_STS_ERROR',

2408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2409: (
2410: l_api_name,
2411: G_PKG_NAME,
2412: 'OKC_API.G_RET_STS_ERROR',
2413: x_msg_count,
2414: x_msg_data,
2415: '_PVT'
2416: );

Line 2417: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2418: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 2422: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2428: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 2443: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2439: -- delete_row for:OKL_SIF_RET_STRMS_V --
2440: ----------------------------------------
2441: PROCEDURE delete_row(
2442: p_api_version IN NUMBER,
2443: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2444: x_return_status OUT NOCOPY VARCHAR2,
2445: x_msg_count OUT NOCOPY NUMBER,
2446: x_msg_data OUT NOCOPY VARCHAR2,
2447: p_srsv_rec IN srsv_rec_type) IS

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

2447: p_srsv_rec IN srsv_rec_type) IS
2448:
2449: l_api_version CONSTANT NUMBER := 1;
2450: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2452: l_srsv_rec srsv_rec_type := p_srsv_rec;
2453: l_srs_rec srs_rec_type;
2454: BEGIN
2455: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2452: l_srsv_rec srsv_rec_type := p_srsv_rec;
2453: l_srs_rec srs_rec_type;
2454: BEGIN
2455: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2456: G_PKG_NAME,
2457: p_init_msg_list,
2458: l_api_version,
2459: p_api_version,

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

2458: l_api_version,
2459: p_api_version,
2460: '_PVT',
2461: x_return_status);
2462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2465: RAISE OKC_API.G_EXCEPTION_ERROR;
2466: END IF;

Line 2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2459: p_api_version,
2460: '_PVT',
2461: x_return_status);
2462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2465: RAISE OKC_API.G_EXCEPTION_ERROR;
2466: END IF;
2467: --------------------------------------

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

2460: '_PVT',
2461: x_return_status);
2462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2465: RAISE OKC_API.G_EXCEPTION_ERROR;
2466: END IF;
2467: --------------------------------------
2468: -- Move VIEW record to "Child" records

Line 2465: RAISE OKC_API.G_EXCEPTION_ERROR;

2461: x_return_status);
2462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2465: RAISE OKC_API.G_EXCEPTION_ERROR;
2466: END IF;
2467: --------------------------------------
2468: -- Move VIEW record to "Child" records
2469: --------------------------------------

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

2477: x_msg_count,
2478: x_msg_data,
2479: l_srs_rec
2480: );
2481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;

Line 2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2478: x_msg_data,
2479: l_srs_rec
2480: );
2481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;
2486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2479: l_srs_rec
2480: );
2481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;
2486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2487: EXCEPTION

Line 2484: RAISE OKC_API.G_EXCEPTION_ERROR;

2480: );
2481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;
2486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2487: EXCEPTION
2488: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;
2486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2487: EXCEPTION
2488: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (

Line 2488: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2484: RAISE OKC_API.G_EXCEPTION_ERROR;
2485: END IF;
2486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2487: EXCEPTION
2488: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (
2491: l_api_name,
2492: G_PKG_NAME,

Line 2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2485: END IF;
2486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2487: EXCEPTION
2488: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (
2491: l_api_name,
2492: G_PKG_NAME,
2493: 'OKC_API.G_RET_STS_ERROR',

Line 2493: 'OKC_API.G_RET_STS_ERROR',

2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (
2491: l_api_name,
2492: G_PKG_NAME,
2493: 'OKC_API.G_RET_STS_ERROR',
2494: x_msg_count,
2495: x_msg_data,
2496: '_PVT'
2497: );

Line 2498: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2494: x_msg_count,
2495: x_msg_data,
2496: '_PVT'
2497: );
2498: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2499: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2500: (
2501: l_api_name,
2502: G_PKG_NAME,

Line 2499: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2495: x_msg_data,
2496: '_PVT'
2497: );
2498: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2499: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2500: (
2501: l_api_name,
2502: G_PKG_NAME,
2503: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2503: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 2524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2520: -- PL/SQL TBL delete_row for:SRSV_TBL --
2521: ----------------------------------------
2522: PROCEDURE delete_row(
2523: p_api_version IN NUMBER,
2524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2525: x_return_status OUT NOCOPY VARCHAR2,
2526: x_msg_count OUT NOCOPY NUMBER,
2527: x_msg_data OUT NOCOPY VARCHAR2,
2528: p_srsv_tbl IN srsv_tbl_type) IS

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

2528: p_srsv_tbl IN srsv_tbl_type) IS
2529:
2530: l_api_version CONSTANT NUMBER := 1;
2531: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2532: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2533: i NUMBER := 0;
2534: -- START change : mvasudev, 09/05/2001
2535: -- Adding OverAll Status Flag
2536: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

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

2532: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2533: i NUMBER := 0;
2534: -- START change : mvasudev, 09/05/2001
2535: -- Adding OverAll Status Flag
2536: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2537: -- END change : mvasudev
2538: BEGIN
2539: OKC_API.init_msg_list(p_init_msg_list);
2540: -- Make sure PL/SQL table has records in it before passing

Line 2539: OKC_API.init_msg_list(p_init_msg_list);

2535: -- Adding OverAll Status Flag
2536: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2537: -- END change : mvasudev
2538: BEGIN
2539: OKC_API.init_msg_list(p_init_msg_list);
2540: -- Make sure PL/SQL table has records in it before passing
2541: IF (p_srsv_tbl.COUNT > 0) THEN
2542: i := p_srsv_tbl.FIRST;
2543: LOOP

Line 2546: p_init_msg_list => OKC_API.G_FALSE,

2542: i := p_srsv_tbl.FIRST;
2543: LOOP
2544: delete_row (
2545: p_api_version => p_api_version,
2546: p_init_msg_list => OKC_API.G_FALSE,
2547: x_return_status => x_return_status,
2548: x_msg_count => x_msg_count,
2549: x_msg_data => x_msg_data,
2550: p_srsv_rec => p_srsv_tbl(i));

Line 2553: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2549: x_msg_data => x_msg_data,
2550: p_srsv_rec => p_srsv_tbl(i));
2551: -- START change : mvasudev, 09/05/2001
2552: -- store the highest degree of error
2553: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2554: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2555: l_overall_status := x_return_status;
2556: END IF;
2557: END IF;

Line 2554: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2550: p_srsv_rec => p_srsv_tbl(i));
2551: -- START change : mvasudev, 09/05/2001
2552: -- store the highest degree of error
2553: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2554: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2555: l_overall_status := x_return_status;
2556: END IF;
2557: END IF;
2558: -- END change : mvasudev

Line 2568: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2564: x_return_status := l_overall_status;
2565: -- END change : mvasudev
2566: END IF;
2567: EXCEPTION
2568: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2569: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2570: (
2571: l_api_name,
2572: G_PKG_NAME,

Line 2569: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2565: -- END change : mvasudev
2566: END IF;
2567: EXCEPTION
2568: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2569: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2570: (
2571: l_api_name,
2572: G_PKG_NAME,
2573: 'OKC_API.G_RET_STS_ERROR',

Line 2573: 'OKC_API.G_RET_STS_ERROR',

2569: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2570: (
2571: l_api_name,
2572: G_PKG_NAME,
2573: 'OKC_API.G_RET_STS_ERROR',
2574: x_msg_count,
2575: x_msg_data,
2576: '_PVT'
2577: );

Line 2578: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2574: x_msg_count,
2575: x_msg_data,
2576: '_PVT'
2577: );
2578: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2579: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2580: (
2581: l_api_name,
2582: G_PKG_NAME,

Line 2579: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2575: x_msg_data,
2576: '_PVT'
2577: );
2578: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2579: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2580: (
2581: l_api_name,
2582: G_PKG_NAME,
2583: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2583: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2579: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2580: (
2581: l_api_name,
2582: G_PKG_NAME,
2583: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2584: x_msg_count,
2585: x_msg_data,
2586: '_PVT'
2587: );

Line 2589: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2585: x_msg_data,
2586: '_PVT'
2587: );
2588: WHEN OTHERS THEN
2589: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2590: (
2591: l_api_name,
2592: G_PKG_NAME,
2593: 'OTHERS',

Line 2616: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2612: -- End of comments
2613:
2614: PROCEDURE insert_row_per(
2615: p_api_version IN NUMBER,
2616: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2617: x_return_status OUT NOCOPY VARCHAR2,
2618: x_msg_count OUT NOCOPY NUMBER,
2619: x_msg_data OUT NOCOPY VARCHAR2,
2620: p_srsv_rec IN srsv_rec_type,

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

2621: x_srsv_rec OUT NOCOPY srsv_rec_type) IS
2622:
2623: l_api_version CONSTANT NUMBER := 1;
2624: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
2625: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2626: l_srsv_rec srsv_rec_type;
2627: l_def_srsv_rec srsv_rec_type;
2628: l_srs_rec srs_rec_type;
2629: lx_srs_rec srs_rec_type;

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

2650: FUNCTION Set_Attributes (
2651: p_srsv_rec IN srsv_rec_type,
2652: x_srsv_rec OUT NOCOPY srsv_rec_type
2653: ) RETURN VARCHAR2 IS
2654: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2655: BEGIN
2656: x_srsv_rec := p_srsv_rec;
2657: x_srsv_rec.OBJECT_VERSION_NUMBER := 1;
2658: RETURN(l_return_status);

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

2658: RETURN(l_return_status);
2659: END Set_Attributes;
2660:
2661: BEGIN
2662: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2663: G_PKG_NAME,
2664: p_init_msg_list,
2665: l_api_version,
2666: p_api_version,

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

2665: l_api_version,
2666: p_api_version,
2667: '_PVT',
2668: x_return_status);
2669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2672: RAISE OKC_API.G_EXCEPTION_ERROR;
2673: END IF;

Line 2670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2666: p_api_version,
2667: '_PVT',
2668: x_return_status);
2669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2672: RAISE OKC_API.G_EXCEPTION_ERROR;
2673: END IF;
2674: l_srsv_rec := null_out_defaults(p_srsv_rec);

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

2667: '_PVT',
2668: x_return_status);
2669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2672: RAISE OKC_API.G_EXCEPTION_ERROR;
2673: END IF;
2674: l_srsv_rec := null_out_defaults(p_srsv_rec);
2675: -- Set primary key value

Line 2672: RAISE OKC_API.G_EXCEPTION_ERROR;

2668: x_return_status);
2669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2672: RAISE OKC_API.G_EXCEPTION_ERROR;
2673: END IF;
2674: l_srsv_rec := null_out_defaults(p_srsv_rec);
2675: -- Set primary key value
2676: l_srsv_rec.ID := get_seq_id;

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

2678: l_return_status := Set_Attributes(
2679: l_srsv_rec, -- IN
2680: l_def_srsv_rec); -- OUT
2681: --- If any errors happen abort API
2682: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2683: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2684: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2685: RAISE OKC_API.G_EXCEPTION_ERROR;
2686: END IF;

Line 2683: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2679: l_srsv_rec, -- IN
2680: l_def_srsv_rec); -- OUT
2681: --- If any errors happen abort API
2682: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2683: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2684: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2685: RAISE OKC_API.G_EXCEPTION_ERROR;
2686: END IF;
2687: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);

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

2680: l_def_srsv_rec); -- OUT
2681: --- If any errors happen abort API
2682: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2683: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2684: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2685: RAISE OKC_API.G_EXCEPTION_ERROR;
2686: END IF;
2687: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
2688: x_srsv_rec := l_def_srsv_rec;

Line 2685: RAISE OKC_API.G_EXCEPTION_ERROR;

2681: --- If any errors happen abort API
2682: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2683: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2684: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2685: RAISE OKC_API.G_EXCEPTION_ERROR;
2686: END IF;
2687: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
2688: x_srsv_rec := l_def_srsv_rec;
2689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2685: RAISE OKC_API.G_EXCEPTION_ERROR;
2686: END IF;
2687: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
2688: x_srsv_rec := l_def_srsv_rec;
2689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2690: EXCEPTION
2691: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2692: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2693: (

Line 2691: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2687: l_def_srsv_rec := fill_who_columns(l_def_srsv_rec);
2688: x_srsv_rec := l_def_srsv_rec;
2689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2690: EXCEPTION
2691: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2692: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2693: (
2694: l_api_name,
2695: G_PKG_NAME,

Line 2692: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2688: x_srsv_rec := l_def_srsv_rec;
2689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2690: EXCEPTION
2691: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2692: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2693: (
2694: l_api_name,
2695: G_PKG_NAME,
2696: 'OKC_API.G_RET_STS_ERROR',

Line 2696: 'OKC_API.G_RET_STS_ERROR',

2692: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2693: (
2694: l_api_name,
2695: G_PKG_NAME,
2696: 'OKC_API.G_RET_STS_ERROR',
2697: x_msg_count,
2698: x_msg_data,
2699: '_PVT'
2700: );

Line 2701: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2697: x_msg_count,
2698: x_msg_data,
2699: '_PVT'
2700: );
2701: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2703: (
2704: l_api_name,
2705: G_PKG_NAME,

Line 2702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2698: x_msg_data,
2699: '_PVT'
2700: );
2701: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2703: (
2704: l_api_name,
2705: G_PKG_NAME,
2706: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2706: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2703: (
2704: l_api_name,
2705: G_PKG_NAME,
2706: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2707: x_msg_count,
2708: x_msg_data,
2709: '_PVT'
2710: );

Line 2712: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2708: x_msg_data,
2709: '_PVT'
2710: );
2711: WHEN OTHERS THEN
2712: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2713: (
2714: l_api_name,
2715: G_PKG_NAME,
2716: 'OTHERS',