eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_TEMPLATE_SET_PVT dependencies on OKC_API

Line 7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,

3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

Line 8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
12: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

Line 40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.

36: ---------------------------------------------------------------------------
37: -- FUNCTION find_highest_exception
38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE

38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN

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

40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;

Line 50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;

Line 51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;
55: EXIT WHEN (i = p_error_tbl.LAST);

Line 158: x_return_status := OKC_API.G_RET_STS_SUCCESS;

154: ) RETURN tmsv_rec_type IS
155: l_tmsv_rec tmsv_rec_type;
156: l_row_notfound BOOLEAN := TRUE;
157: BEGIN
158: x_return_status := OKC_API.G_RET_STS_SUCCESS;
159: l_tmsv_rec := get_rec(p_tmsv_rec, l_row_notfound);
160: IF (l_row_notfound) THEN
161: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
162: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 161: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

157: BEGIN
158: x_return_status := OKC_API.G_RET_STS_SUCCESS;
159: l_tmsv_rec := get_rec(p_tmsv_rec, l_row_notfound);
160: IF (l_row_notfound) THEN
161: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
162: x_return_status := OKC_API.G_RET_STS_ERROR;
163: END IF;
164: RETURN(l_tmsv_rec);
165: END get_rec;

Line 162: x_return_status := OKC_API.G_RET_STS_ERROR;

158: x_return_status := OKC_API.G_RET_STS_SUCCESS;
159: l_tmsv_rec := get_rec(p_tmsv_rec, l_row_notfound);
160: IF (l_row_notfound) THEN
161: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
162: x_return_status := OKC_API.G_RET_STS_ERROR;
163: END IF;
164: RETURN(l_tmsv_rec);
165: END get_rec;
166: -----------------------------------------------------------

Line 241: x_return_status := OKC_API.G_RET_STS_SUCCESS;

237: ) RETURN tms_rec_type IS
238: l_tms_rec tms_rec_type;
239: l_row_notfound BOOLEAN := TRUE;
240: BEGIN
241: x_return_status := OKC_API.G_RET_STS_SUCCESS;
242: l_tms_rec := get_rec(p_tms_rec, l_row_notfound);
243: IF (l_row_notfound) THEN
244: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
245: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 244: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

240: BEGIN
241: x_return_status := OKC_API.G_RET_STS_SUCCESS;
242: l_tms_rec := get_rec(p_tms_rec, l_row_notfound);
243: IF (l_row_notfound) THEN
244: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
245: x_return_status := OKC_API.G_RET_STS_ERROR;
246: END IF;
247: RETURN(l_tms_rec);
248: END get_rec;

Line 245: x_return_status := OKC_API.G_RET_STS_ERROR;

241: x_return_status := OKC_API.G_RET_STS_SUCCESS;
242: l_tms_rec := get_rec(p_tms_rec, l_row_notfound);
243: IF (l_row_notfound) THEN
244: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
245: x_return_status := OKC_API.G_RET_STS_ERROR;
246: END IF;
247: RETURN(l_tms_rec);
248: END get_rec;
249: -----------------------------------------------------------

Line 267: IF (l_tmsv_rec.id = OKC_API.G_MISS_NUM ) THEN

263: p_tmsv_rec IN tmsv_rec_type
264: ) RETURN tmsv_rec_type IS
265: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
266: BEGIN
267: IF (l_tmsv_rec.id = OKC_API.G_MISS_NUM ) THEN
268: l_tmsv_rec.id := NULL;
269: END IF;
270: IF (l_tmsv_rec.name = OKC_API.G_MISS_CHAR ) THEN
271: l_tmsv_rec.name := NULL;

Line 270: IF (l_tmsv_rec.name = OKC_API.G_MISS_CHAR ) THEN

266: BEGIN
267: IF (l_tmsv_rec.id = OKC_API.G_MISS_NUM ) THEN
268: l_tmsv_rec.id := NULL;
269: END IF;
270: IF (l_tmsv_rec.name = OKC_API.G_MISS_CHAR ) THEN
271: l_tmsv_rec.name := NULL;
272: END IF;
273: IF (l_tmsv_rec.description = OKC_API.G_MISS_CHAR ) THEN
274: l_tmsv_rec.description := NULL;

Line 273: IF (l_tmsv_rec.description = OKC_API.G_MISS_CHAR ) THEN

269: END IF;
270: IF (l_tmsv_rec.name = OKC_API.G_MISS_CHAR ) THEN
271: l_tmsv_rec.name := NULL;
272: END IF;
273: IF (l_tmsv_rec.description = OKC_API.G_MISS_CHAR ) THEN
274: l_tmsv_rec.description := NULL;
275: END IF;
276: IF (l_tmsv_rec.start_date = OKC_API.G_MISS_DATE ) THEN
277: l_tmsv_rec.start_date := NULL;

Line 276: IF (l_tmsv_rec.start_date = OKC_API.G_MISS_DATE ) THEN

272: END IF;
273: IF (l_tmsv_rec.description = OKC_API.G_MISS_CHAR ) THEN
274: l_tmsv_rec.description := NULL;
275: END IF;
276: IF (l_tmsv_rec.start_date = OKC_API.G_MISS_DATE ) THEN
277: l_tmsv_rec.start_date := NULL;
278: END IF;
279: IF (l_tmsv_rec.end_date = OKC_API.G_MISS_DATE ) THEN
280: l_tmsv_rec.end_date := NULL;

Line 279: IF (l_tmsv_rec.end_date = OKC_API.G_MISS_DATE ) THEN

275: END IF;
276: IF (l_tmsv_rec.start_date = OKC_API.G_MISS_DATE ) THEN
277: l_tmsv_rec.start_date := NULL;
278: END IF;
279: IF (l_tmsv_rec.end_date = OKC_API.G_MISS_DATE ) THEN
280: l_tmsv_rec.end_date := NULL;
281: END IF;
282: IF (l_tmsv_rec.org_id = OKC_API.G_MISS_NUM ) THEN
283: l_tmsv_rec.org_id := NULL;

Line 282: IF (l_tmsv_rec.org_id = OKC_API.G_MISS_NUM ) THEN

278: END IF;
279: IF (l_tmsv_rec.end_date = OKC_API.G_MISS_DATE ) THEN
280: l_tmsv_rec.end_date := NULL;
281: END IF;
282: IF (l_tmsv_rec.org_id = OKC_API.G_MISS_NUM ) THEN
283: l_tmsv_rec.org_id := NULL;
284: END IF;
285: IF (l_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM ) THEN
286: l_tmsv_rec.quote_letter := NULL;

Line 285: IF (l_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM ) THEN

281: END IF;
282: IF (l_tmsv_rec.org_id = OKC_API.G_MISS_NUM ) THEN
283: l_tmsv_rec.org_id := NULL;
284: END IF;
285: IF (l_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM ) THEN
286: l_tmsv_rec.quote_letter := NULL;
287: END IF;
288: IF (l_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM ) THEN
289: l_tmsv_rec.cover_letter := NULL;

Line 288: IF (l_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM ) THEN

284: END IF;
285: IF (l_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM ) THEN
286: l_tmsv_rec.quote_letter := NULL;
287: END IF;
288: IF (l_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM ) THEN
289: l_tmsv_rec.cover_letter := NULL;
290: END IF;
291: IF (l_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR ) THEN
292: l_tmsv_rec.sts_code := NULL;

Line 291: IF (l_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR ) THEN

287: END IF;
288: IF (l_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM ) THEN
289: l_tmsv_rec.cover_letter := NULL;
290: END IF;
291: IF (l_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR ) THEN
292: l_tmsv_rec.sts_code := NULL;
293: END IF;
294: IF (l_tmsv_rec.template_source = OKC_API.G_MISS_CHAR ) THEN
295: l_tmsv_rec.template_source := NULL;

Line 294: IF (l_tmsv_rec.template_source = OKC_API.G_MISS_CHAR ) THEN

290: END IF;
291: IF (l_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR ) THEN
292: l_tmsv_rec.sts_code := NULL;
293: END IF;
294: IF (l_tmsv_rec.template_source = OKC_API.G_MISS_CHAR ) THEN
295: l_tmsv_rec.template_source := NULL;
296: END IF;
297: IF (l_tmsv_rec.created_by = OKC_API.G_MISS_NUM ) THEN
298: l_tmsv_rec.created_by := NULL;

Line 297: IF (l_tmsv_rec.created_by = OKC_API.G_MISS_NUM ) THEN

293: END IF;
294: IF (l_tmsv_rec.template_source = OKC_API.G_MISS_CHAR ) THEN
295: l_tmsv_rec.template_source := NULL;
296: END IF;
297: IF (l_tmsv_rec.created_by = OKC_API.G_MISS_NUM ) THEN
298: l_tmsv_rec.created_by := NULL;
299: END IF;
300: IF (l_tmsv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
301: l_tmsv_rec.creation_date := NULL;

Line 300: IF (l_tmsv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN

296: END IF;
297: IF (l_tmsv_rec.created_by = OKC_API.G_MISS_NUM ) THEN
298: l_tmsv_rec.created_by := NULL;
299: END IF;
300: IF (l_tmsv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
301: l_tmsv_rec.creation_date := NULL;
302: END IF;
303: IF (l_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
304: l_tmsv_rec.last_updated_by := NULL;

Line 303: IF (l_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN

299: END IF;
300: IF (l_tmsv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
301: l_tmsv_rec.creation_date := NULL;
302: END IF;
303: IF (l_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
304: l_tmsv_rec.last_updated_by := NULL;
305: END IF;
306: IF (l_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
307: l_tmsv_rec.last_update_date := NULL;

Line 306: IF (l_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN

302: END IF;
303: IF (l_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
304: l_tmsv_rec.last_updated_by := NULL;
305: END IF;
306: IF (l_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
307: l_tmsv_rec.last_update_date := NULL;
308: END IF;
309: IF (l_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
310: l_tmsv_rec.last_update_login := NULL;

Line 309: IF (l_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN

305: END IF;
306: IF (l_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
307: l_tmsv_rec.last_update_date := NULL;
308: END IF;
309: IF (l_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
310: l_tmsv_rec.last_update_login := NULL;
311: END IF;
312: IF (l_tmsv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
313: l_tmsv_rec.object_version_number := NULL;

Line 312: IF (l_tmsv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN

308: END IF;
309: IF (l_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
310: l_tmsv_rec.last_update_login := NULL;
311: END IF;
312: IF (l_tmsv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
313: l_tmsv_rec.object_version_number := NULL;
314: END IF;
315: RETURN(l_tmsv_rec);
316: END null_out_defaults;

Line 324: x_return_status := OKC_API.G_RET_STS_SUCCESS;

320: PROCEDURE validate_id(
321: x_return_status OUT NOCOPY VARCHAR2,
322: p_id IN NUMBER) IS
323: BEGIN
324: x_return_status := OKC_API.G_RET_STS_SUCCESS;
325: IF (p_id = OKC_API.G_MISS_NUM OR
326: p_id IS NULL)
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

Line 325: IF (p_id = OKC_API.G_MISS_NUM OR

321: x_return_status OUT NOCOPY VARCHAR2,
322: p_id IN NUMBER) IS
323: BEGIN
324: x_return_status := OKC_API.G_RET_STS_SUCCESS;
325: IF (p_id = OKC_API.G_MISS_NUM OR
326: p_id IS NULL)
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
329: x_return_status := OKC_API.G_RET_STS_ERROR;

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

324: x_return_status := OKC_API.G_RET_STS_SUCCESS;
325: IF (p_id = OKC_API.G_MISS_NUM OR
326: p_id IS NULL)
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
329: x_return_status := OKC_API.G_RET_STS_ERROR;
330: RAISE G_EXCEPTION_HALT_VALIDATION;
331: END IF;
332: EXCEPTION

Line 329: x_return_status := OKC_API.G_RET_STS_ERROR;

325: IF (p_id = OKC_API.G_MISS_NUM OR
326: p_id IS NULL)
327: THEN
328: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
329: x_return_status := OKC_API.G_RET_STS_ERROR;
330: RAISE G_EXCEPTION_HALT_VALIDATION;
331: END IF;
332: EXCEPTION
333: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 336: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

332: EXCEPTION
333: WHEN G_EXCEPTION_HALT_VALIDATION THEN
334: null;
335: WHEN OTHERS THEN
336: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
337: ,p_msg_name => G_UNEXPECTED_ERROR
338: ,p_token1 => G_SQLCODE_TOKEN
339: ,p_token1_value => SQLCODE
340: ,p_token2 => G_SQLERRM_TOKEN

Line 342: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

338: ,p_token1 => G_SQLCODE_TOKEN
339: ,p_token1_value => SQLCODE
340: ,p_token2 => G_SQLERRM_TOKEN
341: ,p_token2_value => SQLERRM);
342: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
343: END validate_id;
344: ----------------------------------------------------
345: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --
346: ----------------------------------------------------

Line 351: x_return_status := OKC_API.G_RET_STS_SUCCESS;

347: PROCEDURE validate_object_version_number(
348: x_return_status OUT NOCOPY VARCHAR2,
349: p_object_version_number IN NUMBER) IS
350: BEGIN
351: x_return_status := OKC_API.G_RET_STS_SUCCESS;
352: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
353: p_object_version_number IS NULL)
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');

Line 352: IF (p_object_version_number = OKC_API.G_MISS_NUM OR

348: x_return_status OUT NOCOPY VARCHAR2,
349: p_object_version_number IN NUMBER) IS
350: BEGIN
351: x_return_status := OKC_API.G_RET_STS_SUCCESS;
352: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
353: p_object_version_number IS NULL)
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
356: x_return_status := OKC_API.G_RET_STS_ERROR;

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

351: x_return_status := OKC_API.G_RET_STS_SUCCESS;
352: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
353: p_object_version_number IS NULL)
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
356: x_return_status := OKC_API.G_RET_STS_ERROR;
357: RAISE G_EXCEPTION_HALT_VALIDATION;
358: END IF;
359: EXCEPTION

Line 356: x_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 363: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

359: EXCEPTION
360: WHEN G_EXCEPTION_HALT_VALIDATION THEN
361: null;
362: WHEN OTHERS THEN
363: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
364: ,p_msg_name => G_UNEXPECTED_ERROR
365: ,p_token1 => G_SQLCODE_TOKEN
366: ,p_token1_value => SQLCODE
367: ,p_token2 => G_SQLERRM_TOKEN

Line 369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

365: ,p_token1 => G_SQLCODE_TOKEN
366: ,p_token1_value => SQLCODE
367: ,p_token2 => G_SQLERRM_TOKEN
368: ,p_token2_value => SQLERRM);
369: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
370: END validate_object_version_number;
371: ---------------------------------------------------------------------------
372: -- FUNCTION Validate_Attributes
373: ---------------------------------------------------------------------------

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

376: ------------------------------------------------
377: FUNCTION Validate_Attributes (
378: p_tmsv_rec IN tmsv_rec_type
379: ) RETURN VARCHAR2 IS
380: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
381: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
382: BEGIN
383: -----------------------------
384: -- Column Level Validation --

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

377: FUNCTION Validate_Attributes (
378: p_tmsv_rec IN tmsv_rec_type
379: ) RETURN VARCHAR2 IS
380: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
381: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
382: BEGIN
383: -----------------------------
384: -- Column Level Validation --
385: -----------------------------

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

386: -- ***
387: -- id
388: -- ***
389: validate_id(x_return_status, p_tmsv_rec.id);
390: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
391: l_return_status := x_return_status;
392: RAISE G_EXCEPTION_HALT_VALIDATION;
393: END IF;
394:

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

395: -- ***
396: -- object_version_number
397: -- ***
398: validate_object_version_number(x_return_status, p_tmsv_rec.object_version_number);
399: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
400: l_return_status := x_return_status;
401: RAISE G_EXCEPTION_HALT_VALIDATION;
402: END IF;
403:

Line 409: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

405: EXCEPTION
406: WHEN G_EXCEPTION_HALT_VALIDATION THEN
407: RETURN(l_return_status);
408: WHEN OTHERS THEN
409: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
410: ,p_msg_name => G_UNEXPECTED_ERROR
411: ,p_token1 => G_SQLCODE_TOKEN
412: ,p_token1_value => SQLCODE
413: ,p_token2 => G_SQLERRM_TOKEN

Line 415: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

411: ,p_token1 => G_SQLCODE_TOKEN
412: ,p_token1_value => SQLCODE
413: ,p_token2 => G_SQLERRM_TOKEN
414: ,p_token2_value => SQLERRM);
415: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
416: RETURN(l_return_status);
417: END Validate_Attributes;
418: ---------------------------------------------------------------------------
419: -- PROCEDURE Validate_Record

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

424: FUNCTION Validate_Record (
425: p_tmsv_rec IN tmsv_rec_type,
426: p_db_tmsv_rec IN tmsv_rec_type
427: ) RETURN VARCHAR2 IS
428: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
429: BEGIN
430: RETURN (l_return_status);
431: END Validate_Record;
432: FUNCTION Validate_Record (

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

431: END Validate_Record;
432: FUNCTION Validate_Record (
433: p_tmsv_rec IN tmsv_rec_type
434: ) RETURN VARCHAR2 IS
435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
436: l_db_tmsv_rec tmsv_rec_type := get_rec(p_tmsv_rec);
437: BEGIN
438: l_return_status := Validate_Record(p_tmsv_rec => p_tmsv_rec,
439: p_db_tmsv_rec => l_db_tmsv_rec);

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

502: p_tmsv_rec IN tmsv_rec_type) IS
503:
504: l_api_version CONSTANT NUMBER := 1;
505: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
506: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
507: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
508: l_tms_rec tms_rec_type;
509: l_tms_rec tms_rec_type;
510: BEGIN

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

507: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
508: l_tms_rec tms_rec_type;
509: l_tms_rec tms_rec_type;
510: BEGIN
511: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
512: G_PKG_NAME,
513: p_init_msg_list,
514: l_api_version,
515: p_api_version,

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

514: l_api_version,
515: p_api_version,
516: '_PVT',
517: x_return_status);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;

Line 519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

515: p_api_version,
516: '_PVT',
517: x_return_status);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: --- Validate all non-missing attributes (Item Level Validation)

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

516: '_PVT',
517: x_return_status);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: --- Validate all non-missing attributes (Item Level Validation)
524: l_return_status := Validate_Attributes(l_tmsv_rec);

Line 521: RAISE OKC_API.G_EXCEPTION_ERROR;

517: x_return_status);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: --- Validate all non-missing attributes (Item Level Validation)
524: l_return_status := Validate_Attributes(l_tmsv_rec);
525: --- If any errors happen abort API

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

522: END IF;
523: --- Validate all non-missing attributes (Item Level Validation)
524: l_return_status := Validate_Attributes(l_tmsv_rec);
525: --- If any errors happen abort API
526: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;

Line 527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

523: --- Validate all non-missing attributes (Item Level Validation)
524: l_return_status := Validate_Attributes(l_tmsv_rec);
525: --- If any errors happen abort API
526: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531: l_return_status := Validate_Record(l_tmsv_rec);

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

524: l_return_status := Validate_Attributes(l_tmsv_rec);
525: --- If any errors happen abort API
526: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531: l_return_status := Validate_Record(l_tmsv_rec);
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 529: RAISE OKC_API.G_EXCEPTION_ERROR;

525: --- If any errors happen abort API
526: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531: l_return_status := Validate_Record(l_tmsv_rec);
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

528: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531: l_return_status := Validate_Record(l_tmsv_rec);
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;

Line 533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531: l_return_status := Validate_Record(l_tmsv_rec);
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537: x_return_status := l_return_status;

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

530: END IF;
531: l_return_status := Validate_Record(l_tmsv_rec);
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537: x_return_status := l_return_status;
538: EXCEPTION

Line 535: RAISE OKC_API.G_EXCEPTION_ERROR;

531: l_return_status := Validate_Record(l_tmsv_rec);
532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537: x_return_status := l_return_status;
538: EXCEPTION
539: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 539: WHEN OKC_API.G_EXCEPTION_ERROR THEN

535: RAISE OKC_API.G_EXCEPTION_ERROR;
536: END IF;
537: x_return_status := l_return_status;
538: EXCEPTION
539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
540: x_return_status := OKC_API.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,

Line 540: x_return_status := OKC_API.HANDLE_EXCEPTIONS

536: END IF;
537: x_return_status := l_return_status;
538: EXCEPTION
539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
540: x_return_status := OKC_API.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,
544: 'OKC_API.G_RET_STS_ERROR',

Line 544: 'OKC_API.G_RET_STS_ERROR',

540: x_return_status := OKC_API.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,
544: 'OKC_API.G_RET_STS_ERROR',
545: x_msg_count,
546: x_msg_data,
547: '_PVT'
548: );

Line 549: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

545: x_msg_count,
546: x_msg_data,
547: '_PVT'
548: );
549: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
550: x_return_status := OKC_API.HANDLE_EXCEPTIONS
551: (
552: l_api_name,
553: G_PKG_NAME,

Line 550: x_return_status := OKC_API.HANDLE_EXCEPTIONS

546: x_msg_data,
547: '_PVT'
548: );
549: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
550: x_return_status := OKC_API.HANDLE_EXCEPTIONS
551: (
552: l_api_name,
553: G_PKG_NAME,
554: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 554: 'OKC_API.G_RET_STS_UNEXP_ERROR',

550: x_return_status := OKC_API.HANDLE_EXCEPTIONS
551: (
552: l_api_name,
553: G_PKG_NAME,
554: 'OKC_API.G_RET_STS_UNEXP_ERROR',
555: x_msg_count,
556: x_msg_data,
557: '_PVT'
558: );

Line 560: x_return_status := OKC_API.HANDLE_EXCEPTIONS

556: x_msg_data,
557: '_PVT'
558: );
559: WHEN OTHERS THEN
560: x_return_status := OKC_API.HANDLE_EXCEPTIONS
561: (
562: l_api_name,
563: G_PKG_NAME,
564: 'OTHERS',

Line 580: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

576: x_return_status OUT NOCOPY VARCHAR2,
577: x_msg_count OUT NOCOPY NUMBER,
578: x_msg_data OUT NOCOPY VARCHAR2,
579: p_tmsv_tbl IN tmsv_tbl_type,
580: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
581:
582: l_api_version CONSTANT NUMBER := 1;
583: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
584: i NUMBER := 0;

Line 586: OKC_API.init_msg_list(p_init_msg_list);

582: l_api_version CONSTANT NUMBER := 1;
583: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
584: i NUMBER := 0;
585: BEGIN
586: OKC_API.init_msg_list(p_init_msg_list);
587: -- Make sure PL/SQL table has records in it before passing
588: IF (p_tmsv_tbl.COUNT > 0) THEN
589: i := p_tmsv_tbl.FIRST;
590: LOOP

Line 592: l_error_rec OKC_API.ERROR_REC_TYPE;

588: IF (p_tmsv_tbl.COUNT > 0) THEN
589: i := p_tmsv_tbl.FIRST;
590: LOOP
591: DECLARE
592: l_error_rec OKC_API.ERROR_REC_TYPE;
593: BEGIN
594: l_error_rec.api_name := l_api_name;
595: l_error_rec.api_package := G_PKG_NAME;
596: l_error_rec.idx := i;

Line 599: p_init_msg_list => OKC_API.G_FALSE,

595: l_error_rec.api_package := G_PKG_NAME;
596: l_error_rec.idx := i;
597: validate_row (
598: p_api_version => p_api_version,
599: p_init_msg_list => OKC_API.G_FALSE,
600: x_return_status => l_error_rec.error_type,
601: x_msg_count => l_error_rec.msg_count,
602: x_msg_data => l_error_rec.msg_data,
603: p_tmsv_rec => p_tmsv_tbl(i));

Line 604: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

600: x_return_status => l_error_rec.error_type,
601: x_msg_count => l_error_rec.msg_count,
602: x_msg_data => l_error_rec.msg_data,
603: p_tmsv_rec => p_tmsv_tbl(i));
604: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
605: l_error_rec.sqlcode := SQLCODE;
606: load_error_tbl(l_error_rec, px_error_tbl);
607: ELSE
608: x_msg_count := l_error_rec.msg_count;

Line 612: WHEN OKC_API.G_EXCEPTION_ERROR THEN

608: x_msg_count := l_error_rec.msg_count;
609: x_msg_data := l_error_rec.msg_data;
610: END IF;
611: EXCEPTION
612: WHEN OKC_API.G_EXCEPTION_ERROR THEN
613: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
614: l_error_rec.sqlcode := SQLCODE;
615: load_error_tbl(l_error_rec, px_error_tbl);
616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 613: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

609: x_msg_data := l_error_rec.msg_data;
610: END IF;
611: EXCEPTION
612: WHEN OKC_API.G_EXCEPTION_ERROR THEN
613: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
614: l_error_rec.sqlcode := SQLCODE;
615: load_error_tbl(l_error_rec, px_error_tbl);
616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
617: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

612: WHEN OKC_API.G_EXCEPTION_ERROR THEN
613: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
614: l_error_rec.sqlcode := SQLCODE;
615: load_error_tbl(l_error_rec, px_error_tbl);
616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
617: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
618: l_error_rec.sqlcode := SQLCODE;
619: load_error_tbl(l_error_rec, px_error_tbl);
620: WHEN OTHERS THEN

Line 617: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

613: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
614: l_error_rec.sqlcode := SQLCODE;
615: load_error_tbl(l_error_rec, px_error_tbl);
616: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
617: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
618: l_error_rec.sqlcode := SQLCODE;
619: load_error_tbl(l_error_rec, px_error_tbl);
620: WHEN OTHERS THEN
621: l_error_rec.error_type := 'OTHERS';

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

628: END IF;
629: -- Loop through the error_tbl to find the error with the highest severity
630: -- and return it.
631: x_return_status := find_highest_exception(px_error_tbl);
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (

Line 634: WHEN OKC_API.G_EXCEPTION_ERROR THEN

630: -- and return it.
631: x_return_status := find_highest_exception(px_error_tbl);
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,

Line 635: x_return_status := OKC_API.HANDLE_EXCEPTIONS

631: x_return_status := find_highest_exception(px_error_tbl);
632: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
633: EXCEPTION
634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_ERROR',

Line 639: 'OKC_API.G_RET_STS_ERROR',

635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,
639: 'OKC_API.G_RET_STS_ERROR',
640: x_msg_count,
641: x_msg_data,
642: '_PVT'
643: );

Line 644: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

640: x_msg_count,
641: x_msg_data,
642: '_PVT'
643: );
644: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
645: x_return_status := OKC_API.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,

Line 645: x_return_status := OKC_API.HANDLE_EXCEPTIONS

641: x_msg_data,
642: '_PVT'
643: );
644: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
645: x_return_status := OKC_API.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,
649: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 649: 'OKC_API.G_RET_STS_UNEXP_ERROR',

645: x_return_status := OKC_API.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,
649: 'OKC_API.G_RET_STS_UNEXP_ERROR',
650: x_msg_count,
651: x_msg_data,
652: '_PVT'
653: );

Line 655: x_return_status := OKC_API.HANDLE_EXCEPTIONS

651: x_msg_data,
652: '_PVT'
653: );
654: WHEN OTHERS THEN
655: x_return_status := OKC_API.HANDLE_EXCEPTIONS
656: (
657: l_api_name,
658: G_PKG_NAME,
659: 'OTHERS',

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

675: p_tmsv_tbl IN tmsv_tbl_type) IS
676:
677: l_api_version CONSTANT NUMBER := 1;
678: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
679: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
680: l_error_tbl OKC_API.ERROR_TBL_TYPE;
681: BEGIN
682: OKC_API.init_msg_list(p_init_msg_list);
683: -- Make sure PL/SQL table has records in it before passing

Line 680: l_error_tbl OKC_API.ERROR_TBL_TYPE;

676:
677: l_api_version CONSTANT NUMBER := 1;
678: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
679: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
680: l_error_tbl OKC_API.ERROR_TBL_TYPE;
681: BEGIN
682: OKC_API.init_msg_list(p_init_msg_list);
683: -- Make sure PL/SQL table has records in it before passing
684: IF (p_tmsv_tbl.COUNT > 0) THEN

Line 682: OKC_API.init_msg_list(p_init_msg_list);

678: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
679: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
680: l_error_tbl OKC_API.ERROR_TBL_TYPE;
681: BEGIN
682: OKC_API.init_msg_list(p_init_msg_list);
683: -- Make sure PL/SQL table has records in it before passing
684: IF (p_tmsv_tbl.COUNT > 0) THEN
685: validate_row (
686: p_api_version => p_api_version,

Line 687: p_init_msg_list => OKC_API.G_FALSE,

683: -- Make sure PL/SQL table has records in it before passing
684: IF (p_tmsv_tbl.COUNT > 0) THEN
685: validate_row (
686: p_api_version => p_api_version,
687: p_init_msg_list => OKC_API.G_FALSE,
688: x_return_status => x_return_status,
689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data,
691: p_tmsv_tbl => p_tmsv_tbl,

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

690: x_msg_data => x_msg_data,
691: p_tmsv_tbl => p_tmsv_tbl,
692: px_error_tbl => l_error_tbl);
693: END IF;
694: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
695: EXCEPTION
696: WHEN OKC_API.G_EXCEPTION_ERROR THEN
697: x_return_status := OKC_API.HANDLE_EXCEPTIONS
698: (

Line 696: WHEN OKC_API.G_EXCEPTION_ERROR THEN

692: px_error_tbl => l_error_tbl);
693: END IF;
694: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
695: EXCEPTION
696: WHEN OKC_API.G_EXCEPTION_ERROR THEN
697: x_return_status := OKC_API.HANDLE_EXCEPTIONS
698: (
699: l_api_name,
700: G_PKG_NAME,

Line 697: x_return_status := OKC_API.HANDLE_EXCEPTIONS

693: END IF;
694: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
695: EXCEPTION
696: WHEN OKC_API.G_EXCEPTION_ERROR THEN
697: x_return_status := OKC_API.HANDLE_EXCEPTIONS
698: (
699: l_api_name,
700: G_PKG_NAME,
701: 'OKC_API.G_RET_STS_ERROR',

Line 701: 'OKC_API.G_RET_STS_ERROR',

697: x_return_status := OKC_API.HANDLE_EXCEPTIONS
698: (
699: l_api_name,
700: G_PKG_NAME,
701: 'OKC_API.G_RET_STS_ERROR',
702: x_msg_count,
703: x_msg_data,
704: '_PVT'
705: );

Line 706: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

702: x_msg_count,
703: x_msg_data,
704: '_PVT'
705: );
706: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
707: x_return_status := OKC_API.HANDLE_EXCEPTIONS
708: (
709: l_api_name,
710: G_PKG_NAME,

Line 707: x_return_status := OKC_API.HANDLE_EXCEPTIONS

703: x_msg_data,
704: '_PVT'
705: );
706: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
707: x_return_status := OKC_API.HANDLE_EXCEPTIONS
708: (
709: l_api_name,
710: G_PKG_NAME,
711: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 711: 'OKC_API.G_RET_STS_UNEXP_ERROR',

707: x_return_status := OKC_API.HANDLE_EXCEPTIONS
708: (
709: l_api_name,
710: G_PKG_NAME,
711: 'OKC_API.G_RET_STS_UNEXP_ERROR',
712: x_msg_count,
713: x_msg_data,
714: '_PVT'
715: );

Line 717: x_return_status := OKC_API.HANDLE_EXCEPTIONS

713: x_msg_data,
714: '_PVT'
715: );
716: WHEN OTHERS THEN
717: x_return_status := OKC_API.HANDLE_EXCEPTIONS
718: (
719: l_api_name,
720: G_PKG_NAME,
721: 'OTHERS',

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

740: x_tms_rec OUT NOCOPY tms_rec_type) IS
741:
742: l_api_version CONSTANT NUMBER := 1;
743: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
744: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
745: l_tms_rec tms_rec_type := p_tms_rec;
746: l_def_tms_rec tms_rec_type;
747: -----------------------------------------
748: -- Set_Attributes for:OKS_TEMPLATE_SET --

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

750: FUNCTION Set_Attributes (
751: p_tms_rec IN tms_rec_type,
752: x_tms_rec OUT NOCOPY tms_rec_type
753: ) RETURN VARCHAR2 IS
754: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
755: BEGIN
756: x_tms_rec := p_tms_rec;
757: RETURN(l_return_status);
758: END Set_Attributes;

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

756: x_tms_rec := p_tms_rec;
757: RETURN(l_return_status);
758: END Set_Attributes;
759: BEGIN
760: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
761: p_init_msg_list,
762: '_PVT',
763: x_return_status);
764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

760: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
761: p_init_msg_list,
762: '_PVT',
763: x_return_status);
764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_ERROR;
768: END IF;

Line 765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

761: p_init_msg_list,
762: '_PVT',
763: x_return_status);
764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_ERROR;
768: END IF;
769: --- Setting item atributes

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

762: '_PVT',
763: x_return_status);
764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_ERROR;
768: END IF;
769: --- Setting item atributes
770: l_return_status := Set_Attributes(

Line 767: RAISE OKC_API.G_EXCEPTION_ERROR;

763: x_return_status);
764: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
767: RAISE OKC_API.G_EXCEPTION_ERROR;
768: END IF;
769: --- Setting item atributes
770: l_return_status := Set_Attributes(
771: p_tms_rec, -- IN

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

770: l_return_status := Set_Attributes(
771: p_tms_rec, -- IN
772: l_tms_rec); -- OUT
773: --- If any errors happen abort API
774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_ERROR;
778: END IF;

Line 775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

771: p_tms_rec, -- IN
772: l_tms_rec); -- OUT
773: --- If any errors happen abort API
774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_ERROR;
778: END IF;
779: INSERT INTO OKS_TEMPLATE_SET(

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

772: l_tms_rec); -- OUT
773: --- If any errors happen abort API
774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_ERROR;
778: END IF;
779: INSERT INTO OKS_TEMPLATE_SET(
780: id,

Line 777: RAISE OKC_API.G_EXCEPTION_ERROR;

773: --- If any errors happen abort API
774: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
775: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
776: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
777: RAISE OKC_API.G_EXCEPTION_ERROR;
778: END IF;
779: INSERT INTO OKS_TEMPLATE_SET(
780: id,
781: name,

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

812: l_tms_rec.object_version_number);
813: -- Set OUT values
814: x_tms_rec := l_tms_rec;
815: x_return_status := l_return_status;
816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
817: EXCEPTION
818: WHEN OKC_API.G_EXCEPTION_ERROR THEN
819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
820: (

Line 818: WHEN OKC_API.G_EXCEPTION_ERROR THEN

814: x_tms_rec := l_tms_rec;
815: x_return_status := l_return_status;
816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
817: EXCEPTION
818: WHEN OKC_API.G_EXCEPTION_ERROR THEN
819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
820: (
821: l_api_name,
822: G_PKG_NAME,

Line 819: x_return_status := OKC_API.HANDLE_EXCEPTIONS

815: x_return_status := l_return_status;
816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
817: EXCEPTION
818: WHEN OKC_API.G_EXCEPTION_ERROR THEN
819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
820: (
821: l_api_name,
822: G_PKG_NAME,
823: 'OKC_API.G_RET_STS_ERROR',

Line 823: 'OKC_API.G_RET_STS_ERROR',

819: x_return_status := OKC_API.HANDLE_EXCEPTIONS
820: (
821: l_api_name,
822: G_PKG_NAME,
823: 'OKC_API.G_RET_STS_ERROR',
824: x_msg_count,
825: x_msg_data,
826: '_PVT'
827: );

Line 828: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

824: x_msg_count,
825: x_msg_data,
826: '_PVT'
827: );
828: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
829: x_return_status := OKC_API.HANDLE_EXCEPTIONS
830: (
831: l_api_name,
832: G_PKG_NAME,

Line 829: x_return_status := OKC_API.HANDLE_EXCEPTIONS

825: x_msg_data,
826: '_PVT'
827: );
828: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
829: x_return_status := OKC_API.HANDLE_EXCEPTIONS
830: (
831: l_api_name,
832: G_PKG_NAME,
833: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 833: 'OKC_API.G_RET_STS_UNEXP_ERROR',

829: x_return_status := OKC_API.HANDLE_EXCEPTIONS
830: (
831: l_api_name,
832: G_PKG_NAME,
833: 'OKC_API.G_RET_STS_UNEXP_ERROR',
834: x_msg_count,
835: x_msg_data,
836: '_PVT'
837: );

Line 839: x_return_status := OKC_API.HANDLE_EXCEPTIONS

835: x_msg_data,
836: '_PVT'
837: );
838: WHEN OTHERS THEN
839: x_return_status := OKC_API.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
843: 'OTHERS',

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

859: x_tmsv_rec OUT NOCOPY tmsv_rec_type) IS
860:
861: l_api_version CONSTANT NUMBER := 1;
862: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
864: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
865: l_def_tmsv_rec tmsv_rec_type;
866: l_tms_rec tms_rec_type;
867: lx_tms_rec tms_rec_type;

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

886: FUNCTION Set_Attributes (
887: p_tmsv_rec IN tmsv_rec_type,
888: x_tmsv_rec OUT NOCOPY tmsv_rec_type
889: ) RETURN VARCHAR2 IS
890: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
891: BEGIN
892: x_tmsv_rec := p_tmsv_rec;
893: x_tmsv_rec.OBJECT_VERSION_NUMBER := 1;
894: RETURN(l_return_status);

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

893: x_tmsv_rec.OBJECT_VERSION_NUMBER := 1;
894: RETURN(l_return_status);
895: END Set_Attributes;
896: BEGIN
897: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
898: G_PKG_NAME,
899: p_init_msg_list,
900: l_api_version,
901: p_api_version,

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

900: l_api_version,
901: p_api_version,
902: '_PVT',
903: x_return_status);
904: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
907: RAISE OKC_API.G_EXCEPTION_ERROR;
908: END IF;

Line 905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

901: p_api_version,
902: '_PVT',
903: x_return_status);
904: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
907: RAISE OKC_API.G_EXCEPTION_ERROR;
908: END IF;
909: l_tmsv_rec := null_out_defaults(p_tmsv_rec);

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

902: '_PVT',
903: x_return_status);
904: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
907: RAISE OKC_API.G_EXCEPTION_ERROR;
908: END IF;
909: l_tmsv_rec := null_out_defaults(p_tmsv_rec);
910: -- Set primary key value

Line 907: RAISE OKC_API.G_EXCEPTION_ERROR;

903: x_return_status);
904: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
905: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
906: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
907: RAISE OKC_API.G_EXCEPTION_ERROR;
908: END IF;
909: l_tmsv_rec := null_out_defaults(p_tmsv_rec);
910: -- Set primary key value
911: l_tmsv_rec.ID := get_seq_id;

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

913: l_return_Status := Set_Attributes(
914: l_tmsv_rec, -- IN
915: l_def_tmsv_rec); -- OUT
916: --- If any errors happen abort API
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;

Line 918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

914: l_tmsv_rec, -- IN
915: l_def_tmsv_rec); -- OUT
916: --- If any errors happen abort API
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;
922: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);

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

915: l_def_tmsv_rec); -- OUT
916: --- If any errors happen abort API
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;
922: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);
923: --- Validate all non-missing attributes (Item Level Validation)

Line 920: RAISE OKC_API.G_EXCEPTION_ERROR;

916: --- If any errors happen abort API
917: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
920: RAISE OKC_API.G_EXCEPTION_ERROR;
921: END IF;
922: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);
923: --- Validate all non-missing attributes (Item Level Validation)
924: l_return_status := Validate_Attributes(l_def_tmsv_rec);

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

922: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);
923: --- Validate all non-missing attributes (Item Level Validation)
924: l_return_status := Validate_Attributes(l_def_tmsv_rec);
925: --- If any errors happen abort API
926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;

Line 927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

923: --- Validate all non-missing attributes (Item Level Validation)
924: l_return_status := Validate_Attributes(l_def_tmsv_rec);
925: --- If any errors happen abort API
926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: l_return_status := Validate_Record(l_def_tmsv_rec);

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

924: l_return_status := Validate_Attributes(l_def_tmsv_rec);
925: --- If any errors happen abort API
926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: l_return_status := Validate_Record(l_def_tmsv_rec);
932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 929: RAISE OKC_API.G_EXCEPTION_ERROR;

925: --- If any errors happen abort API
926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: l_return_status := Validate_Record(l_def_tmsv_rec);
932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: l_return_status := Validate_Record(l_def_tmsv_rec);
932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_ERROR;
936: END IF;

Line 933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

929: RAISE OKC_API.G_EXCEPTION_ERROR;
930: END IF;
931: l_return_status := Validate_Record(l_def_tmsv_rec);
932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_ERROR;
936: END IF;
937: -----------------------------------------

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

930: END IF;
931: l_return_status := Validate_Record(l_def_tmsv_rec);
932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_ERROR;
936: END IF;
937: -----------------------------------------
938: -- Move VIEW record to "Child" records --

Line 935: RAISE OKC_API.G_EXCEPTION_ERROR;

931: l_return_status := Validate_Record(l_def_tmsv_rec);
932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_ERROR;
936: END IF;
937: -----------------------------------------
938: -- Move VIEW record to "Child" records --
939: -----------------------------------------

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

948: x_msg_data,
949: l_tms_rec,
950: lx_tms_rec
951: );
952: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
954: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
955: RAISE OKC_API.G_EXCEPTION_ERROR;
956: END IF;

Line 953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

949: l_tms_rec,
950: lx_tms_rec
951: );
952: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
954: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
955: RAISE OKC_API.G_EXCEPTION_ERROR;
956: END IF;
957: migrate(lx_tms_rec, l_def_tmsv_rec);

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

950: lx_tms_rec
951: );
952: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
954: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
955: RAISE OKC_API.G_EXCEPTION_ERROR;
956: END IF;
957: migrate(lx_tms_rec, l_def_tmsv_rec);
958: -- Set OUT values

Line 955: RAISE OKC_API.G_EXCEPTION_ERROR;

951: );
952: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
954: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
955: RAISE OKC_API.G_EXCEPTION_ERROR;
956: END IF;
957: migrate(lx_tms_rec, l_def_tmsv_rec);
958: -- Set OUT values
959: x_tmsv_rec := l_def_tmsv_rec;

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

957: migrate(lx_tms_rec, l_def_tmsv_rec);
958: -- Set OUT values
959: x_tmsv_rec := l_def_tmsv_rec;
960: x_return_status := l_return_status;
961: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
962: EXCEPTION
963: WHEN OKC_API.G_EXCEPTION_ERROR THEN
964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (

Line 963: WHEN OKC_API.G_EXCEPTION_ERROR THEN

959: x_tmsv_rec := l_def_tmsv_rec;
960: x_return_status := l_return_status;
961: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
962: EXCEPTION
963: WHEN OKC_API.G_EXCEPTION_ERROR THEN
964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,

Line 964: x_return_status := OKC_API.HANDLE_EXCEPTIONS

960: x_return_status := l_return_status;
961: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
962: EXCEPTION
963: WHEN OKC_API.G_EXCEPTION_ERROR THEN
964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,
968: 'OKC_API.G_RET_STS_ERROR',

Line 968: 'OKC_API.G_RET_STS_ERROR',

964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,
968: 'OKC_API.G_RET_STS_ERROR',
969: x_msg_count,
970: x_msg_data,
971: '_PVT'
972: );

Line 973: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

969: x_msg_count,
970: x_msg_data,
971: '_PVT'
972: );
973: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (
976: l_api_name,
977: G_PKG_NAME,

Line 974: x_return_status := OKC_API.HANDLE_EXCEPTIONS

970: x_msg_data,
971: '_PVT'
972: );
973: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (
976: l_api_name,
977: G_PKG_NAME,
978: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 978: 'OKC_API.G_RET_STS_UNEXP_ERROR',

974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (
976: l_api_name,
977: G_PKG_NAME,
978: 'OKC_API.G_RET_STS_UNEXP_ERROR',
979: x_msg_count,
980: x_msg_data,
981: '_PVT'
982: );

Line 984: x_return_status := OKC_API.HANDLE_EXCEPTIONS

980: x_msg_data,
981: '_PVT'
982: );
983: WHEN OTHERS THEN
984: x_return_status := OKC_API.HANDLE_EXCEPTIONS
985: (
986: l_api_name,
987: G_PKG_NAME,
988: 'OTHERS',

Line 1005: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_tmsv_tbl IN tmsv_tbl_type,
1004: x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
1005: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1006:
1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1009: i NUMBER := 0;

Line 1011: OKC_API.init_msg_list(p_init_msg_list);

1007: l_api_version CONSTANT NUMBER := 1;
1008: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1009: i NUMBER := 0;
1010: BEGIN
1011: OKC_API.init_msg_list(p_init_msg_list);
1012: -- Make sure PL/SQL table has records in it before passing
1013: IF (p_tmsv_tbl.COUNT > 0) THEN
1014: i := p_tmsv_tbl.FIRST;
1015: LOOP

Line 1017: l_error_rec OKC_API.ERROR_REC_TYPE;

1013: IF (p_tmsv_tbl.COUNT > 0) THEN
1014: i := p_tmsv_tbl.FIRST;
1015: LOOP
1016: DECLARE
1017: l_error_rec OKC_API.ERROR_REC_TYPE;
1018: BEGIN
1019: l_error_rec.api_name := l_api_name;
1020: l_error_rec.api_package := G_PKG_NAME;
1021: l_error_rec.idx := i;

Line 1024: p_init_msg_list => OKC_API.G_FALSE,

1020: l_error_rec.api_package := G_PKG_NAME;
1021: l_error_rec.idx := i;
1022: insert_row (
1023: p_api_version => p_api_version,
1024: p_init_msg_list => OKC_API.G_FALSE,
1025: x_return_status => l_error_rec.error_type,
1026: x_msg_count => l_error_rec.msg_count,
1027: x_msg_data => l_error_rec.msg_data,
1028: p_tmsv_rec => p_tmsv_tbl(i),

Line 1030: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1026: x_msg_count => l_error_rec.msg_count,
1027: x_msg_data => l_error_rec.msg_data,
1028: p_tmsv_rec => p_tmsv_tbl(i),
1029: x_tmsv_rec => x_tmsv_tbl(i));
1030: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1031: l_error_rec.sqlcode := SQLCODE;
1032: load_error_tbl(l_error_rec, px_error_tbl);
1033: ELSE
1034: x_msg_count := l_error_rec.msg_count;

Line 1038: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1034: x_msg_count := l_error_rec.msg_count;
1035: x_msg_data := l_error_rec.msg_data;
1036: END IF;
1037: EXCEPTION
1038: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1039: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1040: l_error_rec.sqlcode := SQLCODE;
1041: load_error_tbl(l_error_rec, px_error_tbl);
1042: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1039: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1035: x_msg_data := l_error_rec.msg_data;
1036: END IF;
1037: EXCEPTION
1038: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1039: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1040: l_error_rec.sqlcode := SQLCODE;
1041: load_error_tbl(l_error_rec, px_error_tbl);
1042: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1043: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1042: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1038: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1039: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1040: l_error_rec.sqlcode := SQLCODE;
1041: load_error_tbl(l_error_rec, px_error_tbl);
1042: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1043: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1044: l_error_rec.sqlcode := SQLCODE;
1045: load_error_tbl(l_error_rec, px_error_tbl);
1046: WHEN OTHERS THEN

Line 1043: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1039: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1040: l_error_rec.sqlcode := SQLCODE;
1041: load_error_tbl(l_error_rec, px_error_tbl);
1042: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1043: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1044: l_error_rec.sqlcode := SQLCODE;
1045: load_error_tbl(l_error_rec, px_error_tbl);
1046: WHEN OTHERS THEN
1047: l_error_rec.error_type := 'OTHERS';

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

1054: END IF;
1055: -- Loop through the error_tbl to find the error with the highest severity
1056: -- and return it.
1057: x_return_status := find_highest_exception(px_error_tbl);
1058: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1059: EXCEPTION
1060: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1062: (

Line 1060: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1056: -- and return it.
1057: x_return_status := find_highest_exception(px_error_tbl);
1058: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1059: EXCEPTION
1060: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1062: (
1063: l_api_name,
1064: G_PKG_NAME,

Line 1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1057: x_return_status := find_highest_exception(px_error_tbl);
1058: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1059: EXCEPTION
1060: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1062: (
1063: l_api_name,
1064: G_PKG_NAME,
1065: 'OKC_API.G_RET_STS_ERROR',

Line 1065: 'OKC_API.G_RET_STS_ERROR',

1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1062: (
1063: l_api_name,
1064: G_PKG_NAME,
1065: 'OKC_API.G_RET_STS_ERROR',
1066: x_msg_count,
1067: x_msg_data,
1068: '_PVT'
1069: );

Line 1070: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1071: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1067: x_msg_data,
1068: '_PVT'
1069: );
1070: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1072: (
1073: l_api_name,
1074: G_PKG_NAME,
1075: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1075: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1081: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1077: x_msg_data,
1078: '_PVT'
1079: );
1080: WHEN OTHERS THEN
1081: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1082: (
1083: l_api_name,
1084: G_PKG_NAME,
1085: 'OTHERS',

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

1104: x_tmsv_tbl OUT NOCOPY tmsv_tbl_type) IS
1105:
1106: l_api_version CONSTANT NUMBER := 1;
1107: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1109: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1110: BEGIN
1111: OKC_API.init_msg_list(p_init_msg_list);
1112: -- Make sure PL/SQL table has records in it before passing

Line 1109: l_error_tbl OKC_API.ERROR_TBL_TYPE;

1105:
1106: l_api_version CONSTANT NUMBER := 1;
1107: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1109: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1110: BEGIN
1111: OKC_API.init_msg_list(p_init_msg_list);
1112: -- Make sure PL/SQL table has records in it before passing
1113: IF (p_tmsv_tbl.COUNT > 0) THEN

Line 1111: OKC_API.init_msg_list(p_init_msg_list);

1107: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1108: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1109: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1110: BEGIN
1111: OKC_API.init_msg_list(p_init_msg_list);
1112: -- Make sure PL/SQL table has records in it before passing
1113: IF (p_tmsv_tbl.COUNT > 0) THEN
1114: insert_row (
1115: p_api_version => p_api_version,

Line 1116: p_init_msg_list => OKC_API.G_FALSE,

1112: -- Make sure PL/SQL table has records in it before passing
1113: IF (p_tmsv_tbl.COUNT > 0) THEN
1114: insert_row (
1115: p_api_version => p_api_version,
1116: p_init_msg_list => OKC_API.G_FALSE,
1117: x_return_status => x_return_status,
1118: x_msg_count => x_msg_count,
1119: x_msg_data => x_msg_data,
1120: p_tmsv_tbl => p_tmsv_tbl,

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

1120: p_tmsv_tbl => p_tmsv_tbl,
1121: x_tmsv_tbl => x_tmsv_tbl,
1122: px_error_tbl => l_error_tbl);
1123: END IF;
1124: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1125: EXCEPTION
1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1128: (

Line 1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1122: px_error_tbl => l_error_tbl);
1123: END IF;
1124: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1125: EXCEPTION
1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,

Line 1127: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1123: END IF;
1124: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1125: EXCEPTION
1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'OKC_API.G_RET_STS_ERROR',

Line 1131: 'OKC_API.G_RET_STS_ERROR',

1127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'OKC_API.G_RET_STS_ERROR',
1132: x_msg_count,
1133: x_msg_data,
1134: '_PVT'
1135: );

Line 1136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1132: x_msg_count,
1133: x_msg_data,
1134: '_PVT'
1135: );
1136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1137: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,

Line 1137: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1133: x_msg_data,
1134: '_PVT'
1135: );
1136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1137: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,
1141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1137: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,
1141: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1142: x_msg_count,
1143: x_msg_data,
1144: '_PVT'
1145: );

Line 1147: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1143: x_msg_data,
1144: '_PVT'
1145: );
1146: WHEN OTHERS THEN
1147: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,
1151: 'OTHERS',

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

1182: FROM OKS_TEMPLATE_SET
1183: WHERE ID = p_tms_rec.id;
1184: l_api_version CONSTANT NUMBER := 1;
1185: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1186: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1187: l_object_version_number OKS_TEMPLATE_SET.OBJECT_VERSION_NUMBER%TYPE;
1188: lc_object_version_number OKS_TEMPLATE_SET.OBJECT_VERSION_NUMBER%TYPE;
1189: l_row_notfound BOOLEAN := FALSE;
1190: lc_row_notfound BOOLEAN := FALSE;

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

1188: lc_object_version_number OKS_TEMPLATE_SET.OBJECT_VERSION_NUMBER%TYPE;
1189: l_row_notfound BOOLEAN := FALSE;
1190: lc_row_notfound BOOLEAN := FALSE;
1191: BEGIN
1192: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1193: p_init_msg_list,
1194: '_PVT',
1195: x_return_status);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1192: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1193: p_init_msg_list,
1194: '_PVT',
1195: x_return_status);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;

Line 1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1193: p_init_msg_list,
1194: '_PVT',
1195: x_return_status);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: BEGIN

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

1194: '_PVT',
1195: x_return_status);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: BEGIN
1202: OPEN lock_csr(p_tms_rec);

Line 1199: RAISE OKC_API.G_EXCEPTION_ERROR;

1195: x_return_status);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: BEGIN
1202: OPEN lock_csr(p_tms_rec);
1203: FETCH lock_csr INTO l_object_version_number;

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

1207: WHEN E_Resource_Busy THEN
1208: IF (lock_csr%ISOPEN) THEN
1209: CLOSE lock_csr;
1210: END IF;
1211: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1212: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1213: END;
1214:
1215: IF ( l_row_notfound ) THEN

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

1218: lc_row_notfound := lchk_csr%NOTFOUND;
1219: CLOSE lchk_csr;
1220: END IF;
1221: IF (lc_row_notfound) THEN
1222: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1223: RAISE OKC_API.G_EXCEPTION_ERROR;
1224: ELSIF lc_object_version_number > p_tms_rec.object_version_number THEN
1225: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1223: RAISE OKC_API.G_EXCEPTION_ERROR;

1219: CLOSE lchk_csr;
1220: END IF;
1221: IF (lc_row_notfound) THEN
1222: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1223: RAISE OKC_API.G_EXCEPTION_ERROR;
1224: ELSIF lc_object_version_number > p_tms_rec.object_version_number THEN
1225: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: ELSIF lc_object_version_number <> p_tms_rec.object_version_number THEN

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

1221: IF (lc_row_notfound) THEN
1222: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1223: RAISE OKC_API.G_EXCEPTION_ERROR;
1224: ELSIF lc_object_version_number > p_tms_rec.object_version_number THEN
1225: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: ELSIF lc_object_version_number <> p_tms_rec.object_version_number THEN
1228: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1229: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1226: RAISE OKC_API.G_EXCEPTION_ERROR;

1222: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1223: RAISE OKC_API.G_EXCEPTION_ERROR;
1224: ELSIF lc_object_version_number > p_tms_rec.object_version_number THEN
1225: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: ELSIF lc_object_version_number <> p_tms_rec.object_version_number THEN
1228: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: ELSIF lc_object_version_number = -1 THEN

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

1224: ELSIF lc_object_version_number > p_tms_rec.object_version_number THEN
1225: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: ELSIF lc_object_version_number <> p_tms_rec.object_version_number THEN
1228: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: ELSIF lc_object_version_number = -1 THEN
1231: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1232: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1229: RAISE OKC_API.G_EXCEPTION_ERROR;

1225: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1226: RAISE OKC_API.G_EXCEPTION_ERROR;
1227: ELSIF lc_object_version_number <> p_tms_rec.object_version_number THEN
1228: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: ELSIF lc_object_version_number = -1 THEN
1231: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1232: RAISE OKC_API.G_EXCEPTION_ERROR;
1233: END IF;

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

1227: ELSIF lc_object_version_number <> p_tms_rec.object_version_number THEN
1228: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: ELSIF lc_object_version_number = -1 THEN
1231: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1232: RAISE OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: x_return_status := l_return_status;
1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1232: RAISE OKC_API.G_EXCEPTION_ERROR;

1228: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: ELSIF lc_object_version_number = -1 THEN
1231: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1232: RAISE OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: x_return_status := l_return_status;
1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION

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

1231: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1232: RAISE OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: x_return_status := l_return_status;
1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1238: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1239: (

Line 1237: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1233: END IF;
1234: x_return_status := l_return_status;
1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1238: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1239: (
1240: l_api_name,
1241: G_PKG_NAME,

Line 1238: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1234: x_return_status := l_return_status;
1235: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1238: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1239: (
1240: l_api_name,
1241: G_PKG_NAME,
1242: 'OKC_API.G_RET_STS_ERROR',

Line 1242: 'OKC_API.G_RET_STS_ERROR',

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

Line 1247: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1248: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1252: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1248: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1249: (
1250: l_api_name,
1251: G_PKG_NAME,
1252: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1253: x_msg_count,
1254: x_msg_data,
1255: '_PVT'
1256: );

Line 1258: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1254: x_msg_data,
1255: '_PVT'
1256: );
1257: WHEN OTHERS THEN
1258: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1259: (
1260: l_api_name,
1261: G_PKG_NAME,
1262: 'OTHERS',

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

1277: p_tmsv_rec IN tmsv_rec_type) IS
1278:
1279: l_api_version CONSTANT NUMBER := 1;
1280: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1281: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1282: l_tms_rec tms_rec_type;
1283: BEGIN
1284: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1285: G_PKG_NAME,

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

1280: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1281: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1282: l_tms_rec tms_rec_type;
1283: BEGIN
1284: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1285: G_PKG_NAME,
1286: p_init_msg_list,
1287: l_api_version,
1288: p_api_version,

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

1287: l_api_version,
1288: p_api_version,
1289: '_PVT',
1290: x_return_status);
1291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_ERROR;
1295: END IF;

Line 1292: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1288: p_api_version,
1289: '_PVT',
1290: x_return_status);
1291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: -----------------------------------------

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

1289: '_PVT',
1290: x_return_status);
1291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: -----------------------------------------
1297: -- Move VIEW record to "Child" records --

Line 1294: RAISE OKC_API.G_EXCEPTION_ERROR;

1290: x_return_status);
1291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: -----------------------------------------
1297: -- Move VIEW record to "Child" records --
1298: -----------------------------------------

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

1306: x_msg_count,
1307: x_msg_data,
1308: l_tms_rec
1309: );
1310: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1313: RAISE OKC_API.G_EXCEPTION_ERROR;
1314: END IF;

Line 1311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1307: x_msg_data,
1308: l_tms_rec
1309: );
1310: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1313: RAISE OKC_API.G_EXCEPTION_ERROR;
1314: END IF;
1315: x_return_status := l_return_status;

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

1308: l_tms_rec
1309: );
1310: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1313: RAISE OKC_API.G_EXCEPTION_ERROR;
1314: END IF;
1315: x_return_status := l_return_status;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1313: RAISE OKC_API.G_EXCEPTION_ERROR;

1309: );
1310: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1313: RAISE OKC_API.G_EXCEPTION_ERROR;
1314: END IF;
1315: x_return_status := l_return_status;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION

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

1312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1313: RAISE OKC_API.G_EXCEPTION_ERROR;
1314: END IF;
1315: x_return_status := l_return_status;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION
1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (

Line 1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1314: END IF;
1315: x_return_status := l_return_status;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION
1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (
1321: l_api_name,
1322: G_PKG_NAME,

Line 1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1315: x_return_status := l_return_status;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION
1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (
1321: l_api_name,
1322: G_PKG_NAME,
1323: 'OKC_API.G_RET_STS_ERROR',

Line 1323: 'OKC_API.G_RET_STS_ERROR',

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

Line 1328: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1333: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,
1333: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1334: x_msg_count,
1335: x_msg_data,
1336: '_PVT'
1337: );

Line 1339: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1335: x_msg_data,
1336: '_PVT'
1337: );
1338: WHEN OTHERS THEN
1339: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1340: (
1341: l_api_name,
1342: G_PKG_NAME,
1343: 'OTHERS',

Line 1359: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1355: x_return_status OUT NOCOPY VARCHAR2,
1356: x_msg_count OUT NOCOPY NUMBER,
1357: x_msg_data OUT NOCOPY VARCHAR2,
1358: p_tmsv_tbl IN tmsv_tbl_type,
1359: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1360:
1361: l_api_version CONSTANT NUMBER := 1;
1362: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1363: i NUMBER := 0;

Line 1365: OKC_API.init_msg_list(p_init_msg_list);

1361: l_api_version CONSTANT NUMBER := 1;
1362: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1363: i NUMBER := 0;
1364: BEGIN
1365: OKC_API.init_msg_list(p_init_msg_list);
1366: -- Make sure PL/SQL table has recrods in it before passing
1367: IF (p_tmsv_tbl.COUNT > 0) THEN
1368: i := p_tmsv_tbl.FIRST;
1369: LOOP

Line 1371: l_error_rec OKC_API.ERROR_REC_TYPE;

1367: IF (p_tmsv_tbl.COUNT > 0) THEN
1368: i := p_tmsv_tbl.FIRST;
1369: LOOP
1370: DECLARE
1371: l_error_rec OKC_API.ERROR_REC_TYPE;
1372: BEGIN
1373: l_error_rec.api_name := l_api_name;
1374: l_error_rec.api_package := G_PKG_NAME;
1375: l_error_rec.idx := i;

Line 1378: p_init_msg_list => OKC_API.G_FALSE,

1374: l_error_rec.api_package := G_PKG_NAME;
1375: l_error_rec.idx := i;
1376: lock_row(
1377: p_api_version => p_api_version,
1378: p_init_msg_list => OKC_API.G_FALSE,
1379: x_return_status => l_error_rec.error_type,
1380: x_msg_count => l_error_rec.msg_count,
1381: x_msg_data => l_error_rec.msg_data,
1382: p_tmsv_rec => p_tmsv_tbl(i));

Line 1383: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1379: x_return_status => l_error_rec.error_type,
1380: x_msg_count => l_error_rec.msg_count,
1381: x_msg_data => l_error_rec.msg_data,
1382: p_tmsv_rec => p_tmsv_tbl(i));
1383: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1384: l_error_rec.sqlcode := SQLCODE;
1385: load_error_tbl(l_error_rec, px_error_tbl);
1386: ELSE
1387: x_msg_count := l_error_rec.msg_count;

Line 1391: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1387: x_msg_count := l_error_rec.msg_count;
1388: x_msg_data := l_error_rec.msg_data;
1389: END IF;
1390: EXCEPTION
1391: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1392: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1393: l_error_rec.sqlcode := SQLCODE;
1394: load_error_tbl(l_error_rec, px_error_tbl);
1395: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1392: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1388: x_msg_data := l_error_rec.msg_data;
1389: END IF;
1390: EXCEPTION
1391: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1392: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1393: l_error_rec.sqlcode := SQLCODE;
1394: load_error_tbl(l_error_rec, px_error_tbl);
1395: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1396: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1395: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1391: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1392: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1393: l_error_rec.sqlcode := SQLCODE;
1394: load_error_tbl(l_error_rec, px_error_tbl);
1395: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1396: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1397: l_error_rec.sqlcode := SQLCODE;
1398: load_error_tbl(l_error_rec, px_error_tbl);
1399: WHEN OTHERS THEN

Line 1396: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1392: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1393: l_error_rec.sqlcode := SQLCODE;
1394: load_error_tbl(l_error_rec, px_error_tbl);
1395: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1396: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1397: l_error_rec.sqlcode := SQLCODE;
1398: load_error_tbl(l_error_rec, px_error_tbl);
1399: WHEN OTHERS THEN
1400: l_error_rec.error_type := 'OTHERS';

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

1407: END IF;
1408: -- Loop through the error_tbl to find the error with the highest severity
1409: -- and return it.
1410: x_return_status := find_highest_exception(px_error_tbl);
1411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1412: EXCEPTION
1413: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1415: (

Line 1413: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1409: -- and return it.
1410: x_return_status := find_highest_exception(px_error_tbl);
1411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1412: EXCEPTION
1413: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1415: (
1416: l_api_name,
1417: G_PKG_NAME,

Line 1414: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1410: x_return_status := find_highest_exception(px_error_tbl);
1411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1412: EXCEPTION
1413: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1415: (
1416: l_api_name,
1417: G_PKG_NAME,
1418: 'OKC_API.G_RET_STS_ERROR',

Line 1418: 'OKC_API.G_RET_STS_ERROR',

1414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1415: (
1416: l_api_name,
1417: G_PKG_NAME,
1418: 'OKC_API.G_RET_STS_ERROR',
1419: x_msg_count,
1420: x_msg_data,
1421: '_PVT'
1422: );

Line 1423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1420: x_msg_data,
1421: '_PVT'
1422: );
1423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1425: (
1426: l_api_name,
1427: G_PKG_NAME,
1428: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1428: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1430: x_msg_data,
1431: '_PVT'
1432: );
1433: WHEN OTHERS THEN
1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,
1438: 'OTHERS',

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

1453: p_tmsv_tbl IN tmsv_tbl_type) IS
1454:
1455: l_api_version CONSTANT NUMBER := 1;
1456: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1458: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1459: BEGIN
1460: OKC_API.init_msg_list(p_init_msg_list);
1461: -- Make sure PL/SQL table has recrods in it before passing

Line 1458: l_error_tbl OKC_API.ERROR_TBL_TYPE;

1454:
1455: l_api_version CONSTANT NUMBER := 1;
1456: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1458: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1459: BEGIN
1460: OKC_API.init_msg_list(p_init_msg_list);
1461: -- Make sure PL/SQL table has recrods in it before passing
1462: IF (p_tmsv_tbl.COUNT > 0) THEN

Line 1460: OKC_API.init_msg_list(p_init_msg_list);

1456: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1458: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1459: BEGIN
1460: OKC_API.init_msg_list(p_init_msg_list);
1461: -- Make sure PL/SQL table has recrods in it before passing
1462: IF (p_tmsv_tbl.COUNT > 0) THEN
1463: lock_row(
1464: p_api_version => p_api_version,

Line 1465: p_init_msg_list => OKC_API.G_FALSE,

1461: -- Make sure PL/SQL table has recrods in it before passing
1462: IF (p_tmsv_tbl.COUNT > 0) THEN
1463: lock_row(
1464: p_api_version => p_api_version,
1465: p_init_msg_list => OKC_API.G_FALSE,
1466: x_return_status => x_return_status,
1467: x_msg_count => x_msg_count,
1468: x_msg_data => x_msg_data,
1469: p_tmsv_tbl => p_tmsv_tbl,

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

1468: x_msg_data => x_msg_data,
1469: p_tmsv_tbl => p_tmsv_tbl,
1470: px_error_tbl => l_error_tbl);
1471: END IF;
1472: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1473: EXCEPTION
1474: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1475: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1476: (

Line 1474: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1470: px_error_tbl => l_error_tbl);
1471: END IF;
1472: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1473: EXCEPTION
1474: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1475: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1476: (
1477: l_api_name,
1478: G_PKG_NAME,

Line 1475: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1471: END IF;
1472: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1473: EXCEPTION
1474: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1475: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1476: (
1477: l_api_name,
1478: G_PKG_NAME,
1479: 'OKC_API.G_RET_STS_ERROR',

Line 1479: 'OKC_API.G_RET_STS_ERROR',

1475: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1476: (
1477: l_api_name,
1478: G_PKG_NAME,
1479: 'OKC_API.G_RET_STS_ERROR',
1480: x_msg_count,
1481: x_msg_data,
1482: '_PVT'
1483: );

Line 1484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1480: x_msg_count,
1481: x_msg_data,
1482: '_PVT'
1483: );
1484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1485: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1486: (
1487: l_api_name,
1488: G_PKG_NAME,

Line 1485: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1481: x_msg_data,
1482: '_PVT'
1483: );
1484: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1485: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1486: (
1487: l_api_name,
1488: G_PKG_NAME,
1489: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1489: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1485: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1486: (
1487: l_api_name,
1488: G_PKG_NAME,
1489: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1490: x_msg_count,
1491: x_msg_data,
1492: '_PVT'
1493: );

Line 1495: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1491: x_msg_data,
1492: '_PVT'
1493: );
1494: WHEN OTHERS THEN
1495: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1496: (
1497: l_api_name,
1498: G_PKG_NAME,
1499: 'OTHERS',

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

1517: x_tms_rec OUT NOCOPY tms_rec_type) IS
1518:
1519: l_api_version CONSTANT NUMBER := 1;
1520: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1521: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1522: l_tms_rec tms_rec_type := p_tms_rec;
1523: l_def_tms_rec tms_rec_type;
1524: l_row_notfound BOOLEAN := TRUE;
1525: ----------------------------------

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

1530: x_tms_rec OUT NOCOPY tms_rec_type
1531: ) RETURN VARCHAR2 IS
1532: l_tms_rec tms_rec_type;
1533: l_row_notfound BOOLEAN := TRUE;
1534: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1535: BEGIN
1536: x_tms_rec := p_tms_rec;
1537: -- Get current database values
1538: l_tms_rec := get_rec(p_tms_rec, l_return_status);

Line 1539: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1535: BEGIN
1536: x_tms_rec := p_tms_rec;
1537: -- Get current database values
1538: l_tms_rec := get_rec(p_tms_rec, l_return_status);
1539: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1540: IF (x_tms_rec.id = OKC_API.G_MISS_NUM)
1541: THEN
1542: x_tms_rec.id := l_tms_rec.id;
1543: END IF;

Line 1540: IF (x_tms_rec.id = OKC_API.G_MISS_NUM)

1536: x_tms_rec := p_tms_rec;
1537: -- Get current database values
1538: l_tms_rec := get_rec(p_tms_rec, l_return_status);
1539: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1540: IF (x_tms_rec.id = OKC_API.G_MISS_NUM)
1541: THEN
1542: x_tms_rec.id := l_tms_rec.id;
1543: END IF;
1544: IF (x_tms_rec.name = OKC_API.G_MISS_CHAR)

Line 1544: IF (x_tms_rec.name = OKC_API.G_MISS_CHAR)

1540: IF (x_tms_rec.id = OKC_API.G_MISS_NUM)
1541: THEN
1542: x_tms_rec.id := l_tms_rec.id;
1543: END IF;
1544: IF (x_tms_rec.name = OKC_API.G_MISS_CHAR)
1545: THEN
1546: x_tms_rec.name := l_tms_rec.name;
1547: END IF;
1548: IF (x_tms_rec.description = OKC_API.G_MISS_CHAR)

Line 1548: IF (x_tms_rec.description = OKC_API.G_MISS_CHAR)

1544: IF (x_tms_rec.name = OKC_API.G_MISS_CHAR)
1545: THEN
1546: x_tms_rec.name := l_tms_rec.name;
1547: END IF;
1548: IF (x_tms_rec.description = OKC_API.G_MISS_CHAR)
1549: THEN
1550: x_tms_rec.description := l_tms_rec.description;
1551: END IF;
1552: IF (x_tms_rec.start_date = OKC_API.G_MISS_DATE)

Line 1552: IF (x_tms_rec.start_date = OKC_API.G_MISS_DATE)

1548: IF (x_tms_rec.description = OKC_API.G_MISS_CHAR)
1549: THEN
1550: x_tms_rec.description := l_tms_rec.description;
1551: END IF;
1552: IF (x_tms_rec.start_date = OKC_API.G_MISS_DATE)
1553: THEN
1554: x_tms_rec.start_date := l_tms_rec.start_date;
1555: END IF;
1556: IF (x_tms_rec.end_date = OKC_API.G_MISS_DATE)

Line 1556: IF (x_tms_rec.end_date = OKC_API.G_MISS_DATE)

1552: IF (x_tms_rec.start_date = OKC_API.G_MISS_DATE)
1553: THEN
1554: x_tms_rec.start_date := l_tms_rec.start_date;
1555: END IF;
1556: IF (x_tms_rec.end_date = OKC_API.G_MISS_DATE)
1557: THEN
1558: x_tms_rec.end_date := l_tms_rec.end_date;
1559: END IF;
1560: IF (x_tms_rec.org_id = OKC_API.G_MISS_NUM)

Line 1560: IF (x_tms_rec.org_id = OKC_API.G_MISS_NUM)

1556: IF (x_tms_rec.end_date = OKC_API.G_MISS_DATE)
1557: THEN
1558: x_tms_rec.end_date := l_tms_rec.end_date;
1559: END IF;
1560: IF (x_tms_rec.org_id = OKC_API.G_MISS_NUM)
1561: THEN
1562: x_tms_rec.org_id := l_tms_rec.org_id;
1563: END IF;
1564: IF (x_tms_rec.quote_letter = OKC_API.G_MISS_NUM)

Line 1564: IF (x_tms_rec.quote_letter = OKC_API.G_MISS_NUM)

1560: IF (x_tms_rec.org_id = OKC_API.G_MISS_NUM)
1561: THEN
1562: x_tms_rec.org_id := l_tms_rec.org_id;
1563: END IF;
1564: IF (x_tms_rec.quote_letter = OKC_API.G_MISS_NUM)
1565: THEN
1566: x_tms_rec.quote_letter := l_tms_rec.quote_letter;
1567: END IF;
1568: IF (x_tms_rec.cover_letter = OKC_API.G_MISS_NUM)

Line 1568: IF (x_tms_rec.cover_letter = OKC_API.G_MISS_NUM)

1564: IF (x_tms_rec.quote_letter = OKC_API.G_MISS_NUM)
1565: THEN
1566: x_tms_rec.quote_letter := l_tms_rec.quote_letter;
1567: END IF;
1568: IF (x_tms_rec.cover_letter = OKC_API.G_MISS_NUM)
1569: THEN
1570: x_tms_rec.cover_letter := l_tms_rec.cover_letter;
1571: END IF;
1572: IF (x_tms_rec.sts_code = OKC_API.G_MISS_CHAR)

Line 1572: IF (x_tms_rec.sts_code = OKC_API.G_MISS_CHAR)

1568: IF (x_tms_rec.cover_letter = OKC_API.G_MISS_NUM)
1569: THEN
1570: x_tms_rec.cover_letter := l_tms_rec.cover_letter;
1571: END IF;
1572: IF (x_tms_rec.sts_code = OKC_API.G_MISS_CHAR)
1573: THEN
1574: x_tms_rec.sts_code := l_tms_rec.sts_code;
1575: END IF;
1576: IF (x_tms_rec.template_source = OKC_API.G_MISS_CHAR)

Line 1576: IF (x_tms_rec.template_source = OKC_API.G_MISS_CHAR)

1572: IF (x_tms_rec.sts_code = OKC_API.G_MISS_CHAR)
1573: THEN
1574: x_tms_rec.sts_code := l_tms_rec.sts_code;
1575: END IF;
1576: IF (x_tms_rec.template_source = OKC_API.G_MISS_CHAR)
1577: THEN
1578: x_tms_rec.template_source := l_tms_rec.template_source;
1579: END IF;
1580: IF (x_tms_rec.created_by = OKC_API.G_MISS_NUM)

Line 1580: IF (x_tms_rec.created_by = OKC_API.G_MISS_NUM)

1576: IF (x_tms_rec.template_source = OKC_API.G_MISS_CHAR)
1577: THEN
1578: x_tms_rec.template_source := l_tms_rec.template_source;
1579: END IF;
1580: IF (x_tms_rec.created_by = OKC_API.G_MISS_NUM)
1581: THEN
1582: x_tms_rec.created_by := l_tms_rec.created_by;
1583: END IF;
1584: IF (x_tms_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1584: IF (x_tms_rec.creation_date = OKC_API.G_MISS_DATE)

1580: IF (x_tms_rec.created_by = OKC_API.G_MISS_NUM)
1581: THEN
1582: x_tms_rec.created_by := l_tms_rec.created_by;
1583: END IF;
1584: IF (x_tms_rec.creation_date = OKC_API.G_MISS_DATE)
1585: THEN
1586: x_tms_rec.creation_date := l_tms_rec.creation_date;
1587: END IF;
1588: IF (x_tms_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1588: IF (x_tms_rec.last_updated_by = OKC_API.G_MISS_NUM)

1584: IF (x_tms_rec.creation_date = OKC_API.G_MISS_DATE)
1585: THEN
1586: x_tms_rec.creation_date := l_tms_rec.creation_date;
1587: END IF;
1588: IF (x_tms_rec.last_updated_by = OKC_API.G_MISS_NUM)
1589: THEN
1590: x_tms_rec.last_updated_by := l_tms_rec.last_updated_by;
1591: END IF;
1592: IF (x_tms_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1592: IF (x_tms_rec.last_update_date = OKC_API.G_MISS_DATE)

1588: IF (x_tms_rec.last_updated_by = OKC_API.G_MISS_NUM)
1589: THEN
1590: x_tms_rec.last_updated_by := l_tms_rec.last_updated_by;
1591: END IF;
1592: IF (x_tms_rec.last_update_date = OKC_API.G_MISS_DATE)
1593: THEN
1594: x_tms_rec.last_update_date := l_tms_rec.last_update_date;
1595: END IF;
1596: IF (x_tms_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1596: IF (x_tms_rec.last_update_login = OKC_API.G_MISS_NUM)

1592: IF (x_tms_rec.last_update_date = OKC_API.G_MISS_DATE)
1593: THEN
1594: x_tms_rec.last_update_date := l_tms_rec.last_update_date;
1595: END IF;
1596: IF (x_tms_rec.last_update_login = OKC_API.G_MISS_NUM)
1597: THEN
1598: x_tms_rec.last_update_login := l_tms_rec.last_update_login;
1599: END IF;
1600: IF (x_tms_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1600: IF (x_tms_rec.object_version_number = OKC_API.G_MISS_NUM)

1596: IF (x_tms_rec.last_update_login = OKC_API.G_MISS_NUM)
1597: THEN
1598: x_tms_rec.last_update_login := l_tms_rec.last_update_login;
1599: END IF;
1600: IF (x_tms_rec.object_version_number = OKC_API.G_MISS_NUM)
1601: THEN
1602: x_tms_rec.object_version_number := l_tms_rec.object_version_number;
1603: END IF;
1604: END IF;

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

1610: FUNCTION Set_Attributes (
1611: p_tms_rec IN tms_rec_type,
1612: x_tms_rec OUT NOCOPY tms_rec_type
1613: ) RETURN VARCHAR2 IS
1614: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1615: BEGIN
1616: x_tms_rec := p_tms_rec;
1617: x_tms_rec.OBJECT_VERSION_NUMBER := p_tms_rec.OBJECT_VERSION_NUMBER + 1;
1618: RETURN(l_return_status);

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

1617: x_tms_rec.OBJECT_VERSION_NUMBER := p_tms_rec.OBJECT_VERSION_NUMBER + 1;
1618: RETURN(l_return_status);
1619: END Set_Attributes;
1620: BEGIN
1621: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1622: p_init_msg_list,
1623: '_PVT',
1624: x_return_status);
1625: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1621: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1622: p_init_msg_list,
1623: '_PVT',
1624: x_return_status);
1625: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1627: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1628: RAISE OKC_API.G_EXCEPTION_ERROR;
1629: END IF;

Line 1626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1622: p_init_msg_list,
1623: '_PVT',
1624: x_return_status);
1625: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1627: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1628: RAISE OKC_API.G_EXCEPTION_ERROR;
1629: END IF;
1630: --- Setting item attributes

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

1623: '_PVT',
1624: x_return_status);
1625: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1627: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1628: RAISE OKC_API.G_EXCEPTION_ERROR;
1629: END IF;
1630: --- Setting item attributes
1631: l_return_status := Set_Attributes(

Line 1628: RAISE OKC_API.G_EXCEPTION_ERROR;

1624: x_return_status);
1625: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1627: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1628: RAISE OKC_API.G_EXCEPTION_ERROR;
1629: END IF;
1630: --- Setting item attributes
1631: l_return_status := Set_Attributes(
1632: p_tms_rec, -- IN

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

1631: l_return_status := Set_Attributes(
1632: p_tms_rec, -- IN
1633: l_tms_rec); -- OUT
1634: --- If any errors happen abort API
1635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;

Line 1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1632: p_tms_rec, -- IN
1633: l_tms_rec); -- OUT
1634: --- If any errors happen abort API
1635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);

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

1633: l_tms_rec); -- OUT
1634: --- If any errors happen abort API
1635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1638: RAISE OKC_API.G_EXCEPTION_ERROR;

1634: --- If any errors happen abort API
1635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1637: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;

Line 1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;
1646: UPDATE OKS_TEMPLATE_SET

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

1639: END IF;
1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;
1646: UPDATE OKS_TEMPLATE_SET
1647: SET NAME = l_def_tms_rec.name,

Line 1644: RAISE OKC_API.G_EXCEPTION_ERROR;

1640: l_return_status := populate_new_record(l_tms_rec, l_def_tms_rec);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;
1646: UPDATE OKS_TEMPLATE_SET
1647: SET NAME = l_def_tms_rec.name,
1648: DESCRIPTION = l_def_tms_rec.description,

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

1662: WHERE ID = l_def_tms_rec.id;
1663:
1664: x_tms_rec := l_tms_rec;
1665: x_return_status := l_return_status;
1666: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1667: EXCEPTION
1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (

Line 1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1664: x_tms_rec := l_tms_rec;
1665: x_return_status := l_return_status;
1666: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1667: EXCEPTION
1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (
1671: l_api_name,
1672: G_PKG_NAME,

Line 1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1665: x_return_status := l_return_status;
1666: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1667: EXCEPTION
1668: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (
1671: l_api_name,
1672: G_PKG_NAME,
1673: 'OKC_API.G_RET_STS_ERROR',

Line 1673: 'OKC_API.G_RET_STS_ERROR',

1669: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1670: (
1671: l_api_name,
1672: G_PKG_NAME,
1673: 'OKC_API.G_RET_STS_ERROR',
1674: x_msg_count,
1675: x_msg_data,
1676: '_PVT'
1677: );

Line 1678: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1674: x_msg_count,
1675: x_msg_data,
1676: '_PVT'
1677: );
1678: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1679: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1680: (
1681: l_api_name,
1682: G_PKG_NAME,

Line 1679: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1675: x_msg_data,
1676: '_PVT'
1677: );
1678: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1679: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1680: (
1681: l_api_name,
1682: G_PKG_NAME,
1683: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1683: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1679: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1680: (
1681: l_api_name,
1682: G_PKG_NAME,
1683: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1684: x_msg_count,
1685: x_msg_data,
1686: '_PVT'
1687: );

Line 1689: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1685: x_msg_data,
1686: '_PVT'
1687: );
1688: WHEN OTHERS THEN
1689: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1690: (
1691: l_api_name,
1692: G_PKG_NAME,
1693: 'OTHERS',

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

1709: x_tmsv_rec OUT NOCOPY tmsv_rec_type) IS
1710:
1711: l_api_version CONSTANT NUMBER := 1;
1712: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1713: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1714: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
1715: l_def_tmsv_rec tmsv_rec_type;
1716: l_db_tmsv_rec tmsv_rec_type;
1717: l_tms_rec tms_rec_type;

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

1736: p_tmsv_rec IN tmsv_rec_type,
1737: x_tmsv_rec OUT NOCOPY tmsv_rec_type
1738: ) RETURN VARCHAR2 IS
1739: l_row_notfound BOOLEAN := TRUE;
1740: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1741: BEGIN
1742: x_tmsv_rec := p_tmsv_rec;
1743: -- Get current database values
1744: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 1747: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1743: -- Get current database values
1744: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1745: -- so it may be verified through LOCK_ROW.
1746: l_db_tmsv_rec := get_rec(p_tmsv_rec, l_return_status);
1747: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1748: IF (x_tmsv_rec.id = OKC_API.G_MISS_NUM)
1749: THEN
1750: x_tmsv_rec.id := l_db_tmsv_rec.id;
1751: END IF;

Line 1748: IF (x_tmsv_rec.id = OKC_API.G_MISS_NUM)

1744: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1745: -- so it may be verified through LOCK_ROW.
1746: l_db_tmsv_rec := get_rec(p_tmsv_rec, l_return_status);
1747: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1748: IF (x_tmsv_rec.id = OKC_API.G_MISS_NUM)
1749: THEN
1750: x_tmsv_rec.id := l_db_tmsv_rec.id;
1751: END IF;
1752: IF (x_tmsv_rec.name = OKC_API.G_MISS_CHAR)

Line 1752: IF (x_tmsv_rec.name = OKC_API.G_MISS_CHAR)

1748: IF (x_tmsv_rec.id = OKC_API.G_MISS_NUM)
1749: THEN
1750: x_tmsv_rec.id := l_db_tmsv_rec.id;
1751: END IF;
1752: IF (x_tmsv_rec.name = OKC_API.G_MISS_CHAR)
1753: THEN
1754: x_tmsv_rec.name := l_db_tmsv_rec.name;
1755: END IF;
1756: IF (x_tmsv_rec.description = OKC_API.G_MISS_CHAR)

Line 1756: IF (x_tmsv_rec.description = OKC_API.G_MISS_CHAR)

1752: IF (x_tmsv_rec.name = OKC_API.G_MISS_CHAR)
1753: THEN
1754: x_tmsv_rec.name := l_db_tmsv_rec.name;
1755: END IF;
1756: IF (x_tmsv_rec.description = OKC_API.G_MISS_CHAR)
1757: THEN
1758: x_tmsv_rec.description := l_db_tmsv_rec.description;
1759: END IF;
1760: IF (x_tmsv_rec.start_date = OKC_API.G_MISS_DATE)

Line 1760: IF (x_tmsv_rec.start_date = OKC_API.G_MISS_DATE)

1756: IF (x_tmsv_rec.description = OKC_API.G_MISS_CHAR)
1757: THEN
1758: x_tmsv_rec.description := l_db_tmsv_rec.description;
1759: END IF;
1760: IF (x_tmsv_rec.start_date = OKC_API.G_MISS_DATE)
1761: THEN
1762: x_tmsv_rec.start_date := l_db_tmsv_rec.start_date;
1763: END IF;
1764: IF (x_tmsv_rec.end_date = OKC_API.G_MISS_DATE)

Line 1764: IF (x_tmsv_rec.end_date = OKC_API.G_MISS_DATE)

1760: IF (x_tmsv_rec.start_date = OKC_API.G_MISS_DATE)
1761: THEN
1762: x_tmsv_rec.start_date := l_db_tmsv_rec.start_date;
1763: END IF;
1764: IF (x_tmsv_rec.end_date = OKC_API.G_MISS_DATE)
1765: THEN
1766: x_tmsv_rec.end_date := l_db_tmsv_rec.end_date;
1767: END IF;
1768: IF (x_tmsv_rec.org_id = OKC_API.G_MISS_NUM)

Line 1768: IF (x_tmsv_rec.org_id = OKC_API.G_MISS_NUM)

1764: IF (x_tmsv_rec.end_date = OKC_API.G_MISS_DATE)
1765: THEN
1766: x_tmsv_rec.end_date := l_db_tmsv_rec.end_date;
1767: END IF;
1768: IF (x_tmsv_rec.org_id = OKC_API.G_MISS_NUM)
1769: THEN
1770: x_tmsv_rec.org_id := l_db_tmsv_rec.org_id;
1771: END IF;
1772: IF (x_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM)

Line 1772: IF (x_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM)

1768: IF (x_tmsv_rec.org_id = OKC_API.G_MISS_NUM)
1769: THEN
1770: x_tmsv_rec.org_id := l_db_tmsv_rec.org_id;
1771: END IF;
1772: IF (x_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM)
1773: THEN
1774: x_tmsv_rec.quote_letter := l_db_tmsv_rec.quote_letter;
1775: END IF;
1776: IF (x_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM)

Line 1776: IF (x_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM)

1772: IF (x_tmsv_rec.quote_letter = OKC_API.G_MISS_NUM)
1773: THEN
1774: x_tmsv_rec.quote_letter := l_db_tmsv_rec.quote_letter;
1775: END IF;
1776: IF (x_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM)
1777: THEN
1778: x_tmsv_rec.cover_letter := l_db_tmsv_rec.cover_letter;
1779: END IF;
1780: IF (x_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR)

Line 1780: IF (x_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR)

1776: IF (x_tmsv_rec.cover_letter = OKC_API.G_MISS_NUM)
1777: THEN
1778: x_tmsv_rec.cover_letter := l_db_tmsv_rec.cover_letter;
1779: END IF;
1780: IF (x_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR)
1781: THEN
1782: x_tmsv_rec.sts_code := l_db_tmsv_rec.sts_code;
1783: END IF;
1784: IF (x_tmsv_rec.template_source = OKC_API.G_MISS_CHAR)

Line 1784: IF (x_tmsv_rec.template_source = OKC_API.G_MISS_CHAR)

1780: IF (x_tmsv_rec.sts_code = OKC_API.G_MISS_CHAR)
1781: THEN
1782: x_tmsv_rec.sts_code := l_db_tmsv_rec.sts_code;
1783: END IF;
1784: IF (x_tmsv_rec.template_source = OKC_API.G_MISS_CHAR)
1785: THEN
1786: x_tmsv_rec.template_source := l_db_tmsv_rec.template_source;
1787: END IF;
1788: IF (x_tmsv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1788: IF (x_tmsv_rec.created_by = OKC_API.G_MISS_NUM)

1784: IF (x_tmsv_rec.template_source = OKC_API.G_MISS_CHAR)
1785: THEN
1786: x_tmsv_rec.template_source := l_db_tmsv_rec.template_source;
1787: END IF;
1788: IF (x_tmsv_rec.created_by = OKC_API.G_MISS_NUM)
1789: THEN
1790: x_tmsv_rec.created_by := l_db_tmsv_rec.created_by;
1791: END IF;
1792: IF (x_tmsv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1792: IF (x_tmsv_rec.creation_date = OKC_API.G_MISS_DATE)

1788: IF (x_tmsv_rec.created_by = OKC_API.G_MISS_NUM)
1789: THEN
1790: x_tmsv_rec.created_by := l_db_tmsv_rec.created_by;
1791: END IF;
1792: IF (x_tmsv_rec.creation_date = OKC_API.G_MISS_DATE)
1793: THEN
1794: x_tmsv_rec.creation_date := l_db_tmsv_rec.creation_date;
1795: END IF;
1796: IF (x_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1796: IF (x_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1792: IF (x_tmsv_rec.creation_date = OKC_API.G_MISS_DATE)
1793: THEN
1794: x_tmsv_rec.creation_date := l_db_tmsv_rec.creation_date;
1795: END IF;
1796: IF (x_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1797: THEN
1798: x_tmsv_rec.last_updated_by := l_db_tmsv_rec.last_updated_by;
1799: END IF;
1800: IF (x_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1800: IF (x_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE)

1796: IF (x_tmsv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1797: THEN
1798: x_tmsv_rec.last_updated_by := l_db_tmsv_rec.last_updated_by;
1799: END IF;
1800: IF (x_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE)
1801: THEN
1802: x_tmsv_rec.last_update_date := l_db_tmsv_rec.last_update_date;
1803: END IF;
1804: IF (x_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1804: IF (x_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM)

1800: IF (x_tmsv_rec.last_update_date = OKC_API.G_MISS_DATE)
1801: THEN
1802: x_tmsv_rec.last_update_date := l_db_tmsv_rec.last_update_date;
1803: END IF;
1804: IF (x_tmsv_rec.last_update_login = OKC_API.G_MISS_NUM)
1805: THEN
1806: x_tmsv_rec.last_update_login := l_db_tmsv_rec.last_update_login;
1807: END IF;
1808: END IF;

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

1814: FUNCTION Set_Attributes (
1815: p_tmsv_rec IN tmsv_rec_type,
1816: x_tmsv_rec OUT NOCOPY tmsv_rec_type
1817: ) RETURN VARCHAR2 IS
1818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1819: BEGIN
1820: x_tmsv_rec := p_tmsv_rec;
1821: RETURN(l_return_status);
1822: END Set_Attributes;

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

1820: x_tmsv_rec := p_tmsv_rec;
1821: RETURN(l_return_status);
1822: END Set_Attributes;
1823: BEGIN
1824: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1825: G_PKG_NAME,
1826: p_init_msg_list,
1827: l_api_version,
1828: p_api_version,

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

1827: l_api_version,
1828: p_api_version,
1829: '_PVT',
1830: x_return_status);
1831: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1834: RAISE OKC_API.G_EXCEPTION_ERROR;
1835: END IF;

Line 1832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1828: p_api_version,
1829: '_PVT',
1830: x_return_status);
1831: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1834: RAISE OKC_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: --- Setting item attributes

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

1829: '_PVT',
1830: x_return_status);
1831: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1834: RAISE OKC_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: --- Setting item attributes
1837: l_return_status := Set_Attributes(

Line 1834: RAISE OKC_API.G_EXCEPTION_ERROR;

1830: x_return_status);
1831: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1834: RAISE OKC_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: --- Setting item attributes
1837: l_return_status := Set_Attributes(
1838: p_tmsv_rec, -- IN

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

1837: l_return_status := Set_Attributes(
1838: p_tmsv_rec, -- IN
1839: x_tmsv_rec); -- OUT
1840: --- If any errors happen abort API
1841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_ERROR;
1845: END IF;

Line 1842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1838: p_tmsv_rec, -- IN
1839: x_tmsv_rec); -- OUT
1840: --- If any errors happen abort API
1841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_ERROR;
1845: END IF;
1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);

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

1839: x_tmsv_rec); -- OUT
1840: --- If any errors happen abort API
1841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_ERROR;
1845: END IF;
1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);
1847: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1844: RAISE OKC_API.G_EXCEPTION_ERROR;

1840: --- If any errors happen abort API
1841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_ERROR;
1845: END IF;
1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);
1847: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_ERROR;
1845: END IF;
1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);
1847: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1850: RAISE OKC_API.G_EXCEPTION_ERROR;
1851: END IF;

Line 1848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1844: RAISE OKC_API.G_EXCEPTION_ERROR;
1845: END IF;
1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);
1847: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1850: RAISE OKC_API.G_EXCEPTION_ERROR;
1851: END IF;
1852: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);

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

1845: END IF;
1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);
1847: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1850: RAISE OKC_API.G_EXCEPTION_ERROR;
1851: END IF;
1852: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);
1853: --- Validate all non-missing attributes (Item Level Validation)

Line 1850: RAISE OKC_API.G_EXCEPTION_ERROR;

1846: l_return_status := populate_new_record(l_tmsv_rec, l_def_tmsv_rec);
1847: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1849: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1850: RAISE OKC_API.G_EXCEPTION_ERROR;
1851: END IF;
1852: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);
1853: --- Validate all non-missing attributes (Item Level Validation)
1854: l_return_status := Validate_Attributes(l_def_tmsv_rec);

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

1852: l_def_tmsv_rec := fill_who_columns(l_def_tmsv_rec);
1853: --- Validate all non-missing attributes (Item Level Validation)
1854: l_return_status := Validate_Attributes(l_def_tmsv_rec);
1855: --- If any errors happen abort API
1856: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1858: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1859: RAISE OKC_API.G_EXCEPTION_ERROR;
1860: END IF;

Line 1857: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1853: --- Validate all non-missing attributes (Item Level Validation)
1854: l_return_status := Validate_Attributes(l_def_tmsv_rec);
1855: --- If any errors happen abort API
1856: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1858: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1859: RAISE OKC_API.G_EXCEPTION_ERROR;
1860: END IF;
1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);

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

1854: l_return_status := Validate_Attributes(l_def_tmsv_rec);
1855: --- If any errors happen abort API
1856: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1858: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1859: RAISE OKC_API.G_EXCEPTION_ERROR;
1860: END IF;
1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);
1862: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1859: RAISE OKC_API.G_EXCEPTION_ERROR;

1855: --- If any errors happen abort API
1856: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1857: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1858: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1859: RAISE OKC_API.G_EXCEPTION_ERROR;
1860: END IF;
1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);
1862: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1858: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1859: RAISE OKC_API.G_EXCEPTION_ERROR;
1860: END IF;
1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);
1862: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1865: RAISE OKC_API.G_EXCEPTION_ERROR;
1866: END IF;

Line 1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1859: RAISE OKC_API.G_EXCEPTION_ERROR;
1860: END IF;
1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);
1862: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1865: RAISE OKC_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:

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

1860: END IF;
1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);
1862: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1865: RAISE OKC_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:
1868: -- Lock the Record

Line 1865: RAISE OKC_API.G_EXCEPTION_ERROR;

1861: l_return_status := Validate_Record(l_def_tmsv_rec, l_db_tmsv_rec);
1862: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1865: RAISE OKC_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:
1868: -- Lock the Record
1869: lock_row(

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

1872: x_return_status => l_return_status,
1873: x_msg_count => x_msg_count,
1874: x_msg_data => x_msg_data,
1875: p_tmsv_rec => p_tmsv_rec);
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;

Line 1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1873: x_msg_count => x_msg_count,
1874: x_msg_data => x_msg_data,
1875: p_tmsv_rec => p_tmsv_rec);
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881:

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

1874: x_msg_data => x_msg_data,
1875: p_tmsv_rec => p_tmsv_rec);
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881:
1882: -----------------------------------------

Line 1879: RAISE OKC_API.G_EXCEPTION_ERROR;

1875: p_tmsv_rec => p_tmsv_rec);
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881:
1882: -----------------------------------------
1883: -- Move VIEW record to "Child" records --

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

1893: x_msg_data,
1894: l_tms_rec,
1895: lx_tms_rec
1896: );
1897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;

Line 1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1894: l_tms_rec,
1895: lx_tms_rec
1896: );
1897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_tms_rec, l_def_tmsv_rec);

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

1895: lx_tms_rec
1896: );
1897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_tms_rec, l_def_tmsv_rec);
1903: x_tmsv_rec := l_def_tmsv_rec;

Line 1900: RAISE OKC_API.G_EXCEPTION_ERROR;

1896: );
1897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_tms_rec, l_def_tmsv_rec);
1903: x_tmsv_rec := l_def_tmsv_rec;
1904: x_return_status := l_return_status;

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

1901: END IF;
1902: migrate(lx_tms_rec, l_def_tmsv_rec);
1903: x_tmsv_rec := l_def_tmsv_rec;
1904: x_return_status := l_return_status;
1905: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1906: EXCEPTION
1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1908: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1909: (

Line 1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1903: x_tmsv_rec := l_def_tmsv_rec;
1904: x_return_status := l_return_status;
1905: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1906: EXCEPTION
1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1908: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1909: (
1910: l_api_name,
1911: G_PKG_NAME,

Line 1908: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1904: x_return_status := l_return_status;
1905: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1906: EXCEPTION
1907: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1908: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1909: (
1910: l_api_name,
1911: G_PKG_NAME,
1912: 'OKC_API.G_RET_STS_ERROR',

Line 1912: 'OKC_API.G_RET_STS_ERROR',

1908: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1909: (
1910: l_api_name,
1911: G_PKG_NAME,
1912: 'OKC_API.G_RET_STS_ERROR',
1913: x_msg_count,
1914: x_msg_data,
1915: '_PVT'
1916: );

Line 1917: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1913: x_msg_count,
1914: x_msg_data,
1915: '_PVT'
1916: );
1917: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1919: (
1920: l_api_name,
1921: G_PKG_NAME,

Line 1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1914: x_msg_data,
1915: '_PVT'
1916: );
1917: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1919: (
1920: l_api_name,
1921: G_PKG_NAME,
1922: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1922: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1919: (
1920: l_api_name,
1921: G_PKG_NAME,
1922: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1923: x_msg_count,
1924: x_msg_data,
1925: '_PVT'
1926: );

Line 1928: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1924: x_msg_data,
1925: '_PVT'
1926: );
1927: WHEN OTHERS THEN
1928: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,
1932: 'OTHERS',

Line 1949: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1945: x_msg_count OUT NOCOPY NUMBER,
1946: x_msg_data OUT NOCOPY VARCHAR2,
1947: p_tmsv_tbl IN tmsv_tbl_type,
1948: x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
1949: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1950:
1951: l_api_version CONSTANT NUMBER := 1;
1952: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
1953: i NUMBER := 0;

Line 1955: OKC_API.init_msg_list(p_init_msg_list);

1951: l_api_version CONSTANT NUMBER := 1;
1952: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
1953: i NUMBER := 0;
1954: BEGIN
1955: OKC_API.init_msg_list(p_init_msg_list);
1956: -- Make sure PL/SQL table has records in it before passing
1957: IF (p_tmsv_tbl.COUNT > 0) THEN
1958: i := p_tmsv_tbl.FIRST;
1959: LOOP

Line 1961: l_error_rec OKC_API.ERROR_REC_TYPE;

1957: IF (p_tmsv_tbl.COUNT > 0) THEN
1958: i := p_tmsv_tbl.FIRST;
1959: LOOP
1960: DECLARE
1961: l_error_rec OKC_API.ERROR_REC_TYPE;
1962: BEGIN
1963: l_error_rec.api_name := l_api_name;
1964: l_error_rec.api_package := G_PKG_NAME;
1965: l_error_rec.idx := i;

Line 1968: p_init_msg_list => OKC_API.G_FALSE,

1964: l_error_rec.api_package := G_PKG_NAME;
1965: l_error_rec.idx := i;
1966: update_row (
1967: p_api_version => p_api_version,
1968: p_init_msg_list => OKC_API.G_FALSE,
1969: x_return_status => l_error_rec.error_type,
1970: x_msg_count => l_error_rec.msg_count,
1971: x_msg_data => l_error_rec.msg_data,
1972: p_tmsv_rec => p_tmsv_tbl(i),

Line 1974: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1970: x_msg_count => l_error_rec.msg_count,
1971: x_msg_data => l_error_rec.msg_data,
1972: p_tmsv_rec => p_tmsv_tbl(i),
1973: x_tmsv_rec => x_tmsv_tbl(i));
1974: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1975: l_error_rec.sqlcode := SQLCODE;
1976: load_error_tbl(l_error_rec, px_error_tbl);
1977: ELSE
1978: x_msg_count := l_error_rec.msg_count;

Line 1982: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1978: x_msg_count := l_error_rec.msg_count;
1979: x_msg_data := l_error_rec.msg_data;
1980: END IF;
1981: EXCEPTION
1982: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1983: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1984: l_error_rec.sqlcode := SQLCODE;
1985: load_error_tbl(l_error_rec, px_error_tbl);
1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1983: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1979: x_msg_data := l_error_rec.msg_data;
1980: END IF;
1981: EXCEPTION
1982: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1983: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1984: l_error_rec.sqlcode := SQLCODE;
1985: load_error_tbl(l_error_rec, px_error_tbl);
1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1987: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1982: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1983: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1984: l_error_rec.sqlcode := SQLCODE;
1985: load_error_tbl(l_error_rec, px_error_tbl);
1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1987: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1988: l_error_rec.sqlcode := SQLCODE;
1989: load_error_tbl(l_error_rec, px_error_tbl);
1990: WHEN OTHERS THEN

Line 1987: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1983: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1984: l_error_rec.sqlcode := SQLCODE;
1985: load_error_tbl(l_error_rec, px_error_tbl);
1986: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1987: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1988: l_error_rec.sqlcode := SQLCODE;
1989: load_error_tbl(l_error_rec, px_error_tbl);
1990: WHEN OTHERS THEN
1991: l_error_rec.error_type := 'OTHERS';

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

1998: END IF;
1999: -- Loop through the error_tbl to find the error with the highest severity
2000: -- and return it.
2001: x_return_status := find_highest_exception(px_error_tbl);
2002: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2003: EXCEPTION
2004: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2005: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2006: (

Line 2004: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2000: -- and return it.
2001: x_return_status := find_highest_exception(px_error_tbl);
2002: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2003: EXCEPTION
2004: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2005: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2006: (
2007: l_api_name,
2008: G_PKG_NAME,

Line 2005: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2001: x_return_status := find_highest_exception(px_error_tbl);
2002: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2003: EXCEPTION
2004: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2005: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2006: (
2007: l_api_name,
2008: G_PKG_NAME,
2009: 'OKC_API.G_RET_STS_ERROR',

Line 2009: 'OKC_API.G_RET_STS_ERROR',

2005: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2006: (
2007: l_api_name,
2008: G_PKG_NAME,
2009: 'OKC_API.G_RET_STS_ERROR',
2010: x_msg_count,
2011: x_msg_data,
2012: '_PVT'
2013: );

Line 2014: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2010: x_msg_count,
2011: x_msg_data,
2012: '_PVT'
2013: );
2014: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2015: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2016: (
2017: l_api_name,
2018: G_PKG_NAME,

Line 2015: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2011: x_msg_data,
2012: '_PVT'
2013: );
2014: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2015: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2016: (
2017: l_api_name,
2018: G_PKG_NAME,
2019: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2019: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2015: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2016: (
2017: l_api_name,
2018: G_PKG_NAME,
2019: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2020: x_msg_count,
2021: x_msg_data,
2022: '_PVT'
2023: );

Line 2025: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2021: x_msg_data,
2022: '_PVT'
2023: );
2024: WHEN OTHERS THEN
2025: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2026: (
2027: l_api_name,
2028: G_PKG_NAME,
2029: 'OTHERS',

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

2048: x_tmsv_tbl OUT NOCOPY tmsv_tbl_type) IS
2049:
2050: l_api_version CONSTANT NUMBER := 1;
2051: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2052: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2053: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2054: BEGIN
2055: OKC_API.init_msg_list(p_init_msg_list);
2056: -- Make sure PL/SQL table has records in it before passing

Line 2053: l_error_tbl OKC_API.ERROR_TBL_TYPE;

2049:
2050: l_api_version CONSTANT NUMBER := 1;
2051: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2052: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2053: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2054: BEGIN
2055: OKC_API.init_msg_list(p_init_msg_list);
2056: -- Make sure PL/SQL table has records in it before passing
2057: IF (p_tmsv_tbl.COUNT > 0) THEN

Line 2055: OKC_API.init_msg_list(p_init_msg_list);

2051: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2052: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2053: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2054: BEGIN
2055: OKC_API.init_msg_list(p_init_msg_list);
2056: -- Make sure PL/SQL table has records in it before passing
2057: IF (p_tmsv_tbl.COUNT > 0) THEN
2058: update_row (
2059: p_api_version => p_api_version,

Line 2060: p_init_msg_list => OKC_API.G_FALSE,

2056: -- Make sure PL/SQL table has records in it before passing
2057: IF (p_tmsv_tbl.COUNT > 0) THEN
2058: update_row (
2059: p_api_version => p_api_version,
2060: p_init_msg_list => OKC_API.G_FALSE,
2061: x_return_status => x_return_status,
2062: x_msg_count => x_msg_count,
2063: x_msg_data => x_msg_data,
2064: p_tmsv_tbl => p_tmsv_tbl,

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

2064: p_tmsv_tbl => p_tmsv_tbl,
2065: x_tmsv_tbl => x_tmsv_tbl,
2066: px_error_tbl => l_error_tbl);
2067: END IF;
2068: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2069: EXCEPTION
2070: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2072: (

Line 2070: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2066: px_error_tbl => l_error_tbl);
2067: END IF;
2068: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2069: EXCEPTION
2070: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2072: (
2073: l_api_name,
2074: G_PKG_NAME,

Line 2071: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2067: END IF;
2068: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2069: EXCEPTION
2070: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2072: (
2073: l_api_name,
2074: G_PKG_NAME,
2075: 'OKC_API.G_RET_STS_ERROR',

Line 2075: 'OKC_API.G_RET_STS_ERROR',

2071: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2072: (
2073: l_api_name,
2074: G_PKG_NAME,
2075: 'OKC_API.G_RET_STS_ERROR',
2076: x_msg_count,
2077: x_msg_data,
2078: '_PVT'
2079: );

Line 2080: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2076: x_msg_count,
2077: x_msg_data,
2078: '_PVT'
2079: );
2080: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2081: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2082: (
2083: l_api_name,
2084: G_PKG_NAME,

Line 2081: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2077: x_msg_data,
2078: '_PVT'
2079: );
2080: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2081: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2082: (
2083: l_api_name,
2084: G_PKG_NAME,
2085: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2085: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2081: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2082: (
2083: l_api_name,
2084: G_PKG_NAME,
2085: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2086: x_msg_count,
2087: x_msg_data,
2088: '_PVT'
2089: );

Line 2091: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2087: x_msg_data,
2088: '_PVT'
2089: );
2090: WHEN OTHERS THEN
2091: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2092: (
2093: l_api_name,
2094: G_PKG_NAME,
2095: 'OTHERS',

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

2113: p_tms_rec IN tms_rec_type) IS
2114:
2115: l_api_version CONSTANT NUMBER := 1;
2116: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2117: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2118: l_tms_rec tms_rec_type := p_tms_rec;
2119: l_row_notfound BOOLEAN := TRUE;
2120: BEGIN
2121: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2117: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2118: l_tms_rec tms_rec_type := p_tms_rec;
2119: l_row_notfound BOOLEAN := TRUE;
2120: BEGIN
2121: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2122: p_init_msg_list,
2123: '_PVT',
2124: x_return_status);
2125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2121: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2122: p_init_msg_list,
2123: '_PVT',
2124: x_return_status);
2125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2128: RAISE OKC_API.G_EXCEPTION_ERROR;
2129: END IF;

Line 2126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2122: p_init_msg_list,
2123: '_PVT',
2124: x_return_status);
2125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2128: RAISE OKC_API.G_EXCEPTION_ERROR;
2129: END IF;
2130:

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

2123: '_PVT',
2124: x_return_status);
2125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2128: RAISE OKC_API.G_EXCEPTION_ERROR;
2129: END IF;
2130:
2131: DELETE FROM OKS_TEMPLATE_SET

Line 2128: RAISE OKC_API.G_EXCEPTION_ERROR;

2124: x_return_status);
2125: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2128: RAISE OKC_API.G_EXCEPTION_ERROR;
2129: END IF;
2130:
2131: DELETE FROM OKS_TEMPLATE_SET
2132: WHERE ID = p_tms_rec.id;

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

2131: DELETE FROM OKS_TEMPLATE_SET
2132: WHERE ID = p_tms_rec.id;
2133:
2134: x_return_status := l_return_status;
2135: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2136: EXCEPTION
2137: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2139: (

Line 2137: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2133:
2134: x_return_status := l_return_status;
2135: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2136: EXCEPTION
2137: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2139: (
2140: l_api_name,
2141: G_PKG_NAME,

Line 2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2134: x_return_status := l_return_status;
2135: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2136: EXCEPTION
2137: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2139: (
2140: l_api_name,
2141: G_PKG_NAME,
2142: 'OKC_API.G_RET_STS_ERROR',

Line 2142: 'OKC_API.G_RET_STS_ERROR',

2138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2139: (
2140: l_api_name,
2141: G_PKG_NAME,
2142: 'OKC_API.G_RET_STS_ERROR',
2143: x_msg_count,
2144: x_msg_data,
2145: '_PVT'
2146: );

Line 2147: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2143: x_msg_count,
2144: x_msg_data,
2145: '_PVT'
2146: );
2147: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2148: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2149: (
2150: l_api_name,
2151: G_PKG_NAME,

Line 2148: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2144: x_msg_data,
2145: '_PVT'
2146: );
2147: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2148: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2149: (
2150: l_api_name,
2151: G_PKG_NAME,
2152: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2152: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2148: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2149: (
2150: l_api_name,
2151: G_PKG_NAME,
2152: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2153: x_msg_count,
2154: x_msg_data,
2155: '_PVT'
2156: );

Line 2158: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2154: x_msg_data,
2155: '_PVT'
2156: );
2157: WHEN OTHERS THEN
2158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2159: (
2160: l_api_name,
2161: G_PKG_NAME,
2162: 'OTHERS',

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

2177: p_tmsv_rec IN tmsv_rec_type) IS
2178:
2179: l_api_version CONSTANT NUMBER := 1;
2180: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2182: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
2183: l_tms_rec tms_rec_type;
2184: BEGIN
2185: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2182: l_tmsv_rec tmsv_rec_type := p_tmsv_rec;
2183: l_tms_rec tms_rec_type;
2184: BEGIN
2185: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2186: G_PKG_NAME,
2187: p_init_msg_list,
2188: l_api_version,
2189: p_api_version,

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

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

Line 2193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

2190: '_PVT',
2191: x_return_status);
2192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2195: RAISE OKC_API.G_EXCEPTION_ERROR;
2196: END IF;
2197: -----------------------------------------
2198: -- Move VIEW record to "Child" records --

Line 2195: RAISE OKC_API.G_EXCEPTION_ERROR;

2191: x_return_status);
2192: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2195: RAISE OKC_API.G_EXCEPTION_ERROR;
2196: END IF;
2197: -----------------------------------------
2198: -- Move VIEW record to "Child" records --
2199: -----------------------------------------

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

2207: x_msg_count,
2208: x_msg_data,
2209: l_tms_rec
2210: );
2211: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2214: RAISE OKC_API.G_EXCEPTION_ERROR;
2215: END IF;

Line 2212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2208: x_msg_data,
2209: l_tms_rec
2210: );
2211: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2214: RAISE OKC_API.G_EXCEPTION_ERROR;
2215: END IF;
2216: x_return_status := l_return_status;

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

2209: l_tms_rec
2210: );
2211: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2214: RAISE OKC_API.G_EXCEPTION_ERROR;
2215: END IF;
2216: x_return_status := l_return_status;
2217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2214: RAISE OKC_API.G_EXCEPTION_ERROR;

2210: );
2211: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2214: RAISE OKC_API.G_EXCEPTION_ERROR;
2215: END IF;
2216: x_return_status := l_return_status;
2217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2218: EXCEPTION

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

2213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2214: RAISE OKC_API.G_EXCEPTION_ERROR;
2215: END IF;
2216: x_return_status := l_return_status;
2217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2218: EXCEPTION
2219: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2220: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2221: (

Line 2219: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2215: END IF;
2216: x_return_status := l_return_status;
2217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2218: EXCEPTION
2219: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2220: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2221: (
2222: l_api_name,
2223: G_PKG_NAME,

Line 2220: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2216: x_return_status := l_return_status;
2217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2218: EXCEPTION
2219: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2220: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2221: (
2222: l_api_name,
2223: G_PKG_NAME,
2224: 'OKC_API.G_RET_STS_ERROR',

Line 2224: 'OKC_API.G_RET_STS_ERROR',

2220: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2221: (
2222: l_api_name,
2223: G_PKG_NAME,
2224: 'OKC_API.G_RET_STS_ERROR',
2225: x_msg_count,
2226: x_msg_data,
2227: '_PVT'
2228: );

Line 2229: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2225: x_msg_count,
2226: x_msg_data,
2227: '_PVT'
2228: );
2229: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2231: (
2232: l_api_name,
2233: G_PKG_NAME,

Line 2230: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2226: x_msg_data,
2227: '_PVT'
2228: );
2229: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2231: (
2232: l_api_name,
2233: G_PKG_NAME,
2234: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2234: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2231: (
2232: l_api_name,
2233: G_PKG_NAME,
2234: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2235: x_msg_count,
2236: x_msg_data,
2237: '_PVT'
2238: );

Line 2240: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2236: x_msg_data,
2237: '_PVT'
2238: );
2239: WHEN OTHERS THEN
2240: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2241: (
2242: l_api_name,
2243: G_PKG_NAME,
2244: 'OTHERS',

Line 2260: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

2256: x_return_status OUT NOCOPY VARCHAR2,
2257: x_msg_count OUT NOCOPY NUMBER,
2258: x_msg_data OUT NOCOPY VARCHAR2,
2259: p_tmsv_tbl IN tmsv_tbl_type,
2260: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2261:
2262: l_api_version CONSTANT NUMBER := 1;
2263: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2264: i NUMBER := 0;

Line 2266: OKC_API.init_msg_list(p_init_msg_list);

2262: l_api_version CONSTANT NUMBER := 1;
2263: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2264: i NUMBER := 0;
2265: BEGIN
2266: OKC_API.init_msg_list(p_init_msg_list);
2267: -- Make sure PL/SQL table has records in it before passing
2268: IF (p_tmsv_tbl.COUNT > 0) THEN
2269: i := p_tmsv_tbl.FIRST;
2270: LOOP

Line 2272: l_error_rec OKC_API.ERROR_REC_TYPE;

2268: IF (p_tmsv_tbl.COUNT > 0) THEN
2269: i := p_tmsv_tbl.FIRST;
2270: LOOP
2271: DECLARE
2272: l_error_rec OKC_API.ERROR_REC_TYPE;
2273: BEGIN
2274: l_error_rec.api_name := l_api_name;
2275: l_error_rec.api_package := G_PKG_NAME;
2276: l_error_rec.idx := i;

Line 2279: p_init_msg_list => OKC_API.G_FALSE,

2275: l_error_rec.api_package := G_PKG_NAME;
2276: l_error_rec.idx := i;
2277: delete_row (
2278: p_api_version => p_api_version,
2279: p_init_msg_list => OKC_API.G_FALSE,
2280: x_return_status => l_error_rec.error_type,
2281: x_msg_count => l_error_rec.msg_count,
2282: x_msg_data => l_error_rec.msg_data,
2283: p_tmsv_rec => p_tmsv_tbl(i));

Line 2284: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

2280: x_return_status => l_error_rec.error_type,
2281: x_msg_count => l_error_rec.msg_count,
2282: x_msg_data => l_error_rec.msg_data,
2283: p_tmsv_rec => p_tmsv_tbl(i));
2284: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2285: l_error_rec.sqlcode := SQLCODE;
2286: load_error_tbl(l_error_rec, px_error_tbl);
2287: ELSE
2288: x_msg_count := l_error_rec.msg_count;

Line 2292: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2288: x_msg_count := l_error_rec.msg_count;
2289: x_msg_data := l_error_rec.msg_data;
2290: END IF;
2291: EXCEPTION
2292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2293: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2294: l_error_rec.sqlcode := SQLCODE;
2295: load_error_tbl(l_error_rec, px_error_tbl);
2296: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2293: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

2289: x_msg_data := l_error_rec.msg_data;
2290: END IF;
2291: EXCEPTION
2292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2293: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2294: l_error_rec.sqlcode := SQLCODE;
2295: load_error_tbl(l_error_rec, px_error_tbl);
2296: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2297: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2296: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2292: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2293: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2294: l_error_rec.sqlcode := SQLCODE;
2295: load_error_tbl(l_error_rec, px_error_tbl);
2296: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2297: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2298: l_error_rec.sqlcode := SQLCODE;
2299: load_error_tbl(l_error_rec, px_error_tbl);
2300: WHEN OTHERS THEN

Line 2297: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

2293: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2294: l_error_rec.sqlcode := SQLCODE;
2295: load_error_tbl(l_error_rec, px_error_tbl);
2296: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2297: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2298: l_error_rec.sqlcode := SQLCODE;
2299: load_error_tbl(l_error_rec, px_error_tbl);
2300: WHEN OTHERS THEN
2301: l_error_rec.error_type := 'OTHERS';

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

2308: END IF;
2309: -- Loop through the error_tbl to find the error with the highest severity
2310: -- and return it.
2311: x_return_status := find_highest_exception(px_error_tbl);
2312: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2313: EXCEPTION
2314: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2315: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2316: (

Line 2314: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2310: -- and return it.
2311: x_return_status := find_highest_exception(px_error_tbl);
2312: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2313: EXCEPTION
2314: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2315: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2316: (
2317: l_api_name,
2318: G_PKG_NAME,

Line 2315: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 2319: 'OKC_API.G_RET_STS_ERROR',

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

Line 2324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2325: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 2329: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2335: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

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

2355: p_tmsv_tbl IN tmsv_tbl_type) IS
2356:
2357: l_api_version CONSTANT NUMBER := 1;
2358: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2359: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2360: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2361: BEGIN
2362: OKC_API.init_msg_list(p_init_msg_list);
2363: -- Make sure PL/SQL table has records in it before passing

Line 2360: l_error_tbl OKC_API.ERROR_TBL_TYPE;

2356:
2357: l_api_version CONSTANT NUMBER := 1;
2358: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2359: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2360: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2361: BEGIN
2362: OKC_API.init_msg_list(p_init_msg_list);
2363: -- Make sure PL/SQL table has records in it before passing
2364: IF (p_tmsv_tbl.COUNT > 0) THEN

Line 2362: OKC_API.init_msg_list(p_init_msg_list);

2358: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2359: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2360: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2361: BEGIN
2362: OKC_API.init_msg_list(p_init_msg_list);
2363: -- Make sure PL/SQL table has records in it before passing
2364: IF (p_tmsv_tbl.COUNT > 0) THEN
2365: delete_row (
2366: p_api_version => p_api_version,

Line 2367: p_init_msg_list => OKC_API.G_FALSE,

2363: -- Make sure PL/SQL table has records in it before passing
2364: IF (p_tmsv_tbl.COUNT > 0) THEN
2365: delete_row (
2366: p_api_version => p_api_version,
2367: p_init_msg_list => OKC_API.G_FALSE,
2368: x_return_status => x_return_status,
2369: x_msg_count => x_msg_count,
2370: x_msg_data => x_msg_data,
2371: p_tmsv_tbl => p_tmsv_tbl,

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

2370: x_msg_data => x_msg_data,
2371: p_tmsv_tbl => p_tmsv_tbl,
2372: px_error_tbl => l_error_tbl);
2373: END IF;
2374: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2375: EXCEPTION
2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (

Line 2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2372: px_error_tbl => l_error_tbl);
2373: END IF;
2374: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2375: EXCEPTION
2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (
2379: l_api_name,
2380: G_PKG_NAME,

Line 2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2373: END IF;
2374: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2375: EXCEPTION
2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (
2379: l_api_name,
2380: G_PKG_NAME,
2381: 'OKC_API.G_RET_STS_ERROR',

Line 2381: 'OKC_API.G_RET_STS_ERROR',

2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (
2379: l_api_name,
2380: G_PKG_NAME,
2381: 'OKC_API.G_RET_STS_ERROR',
2382: x_msg_count,
2383: x_msg_data,
2384: '_PVT'
2385: );

Line 2386: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2382: x_msg_count,
2383: x_msg_data,
2384: '_PVT'
2385: );
2386: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,

Line 2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2383: x_msg_data,
2384: '_PVT'
2385: );
2386: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,
2391: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2391: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2397: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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