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

APPS.OKL_SLX_PVT dependencies on OKL_API

Line 342: IF p_slxv_rec.id = Okl_Api.G_MISS_NUM OR

338: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
339: BEGIN
340: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
341: Okc_Util.ADD_VIEW('OKL_STRM_TYPE_EXEMPT_V', x_return_status);
342: IF p_slxv_rec.id = Okl_Api.G_MISS_NUM OR
343: p_slxv_rec.id IS NULL THEN
344: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
345: x_return_status := Okl_Api.G_RET_STS_ERROR;
346: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

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

340: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
341: Okc_Util.ADD_VIEW('OKL_STRM_TYPE_EXEMPT_V', x_return_status);
342: IF p_slxv_rec.id = Okl_Api.G_MISS_NUM OR
343: p_slxv_rec.id IS NULL THEN
344: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
345: x_return_status := Okl_Api.G_RET_STS_ERROR;
346: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
347: l_return_status := x_return_status;
348: END IF;

Line 345: x_return_status := Okl_Api.G_RET_STS_ERROR;

341: Okc_Util.ADD_VIEW('OKL_STRM_TYPE_EXEMPT_V', x_return_status);
342: IF p_slxv_rec.id = Okl_Api.G_MISS_NUM OR
343: p_slxv_rec.id IS NULL THEN
344: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
345: x_return_status := Okl_Api.G_RET_STS_ERROR;
346: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
347: l_return_status := x_return_status;
348: END IF;
349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR

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

342: IF p_slxv_rec.id = Okl_Api.G_MISS_NUM OR
343: p_slxv_rec.id IS NULL THEN
344: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
345: x_return_status := Okl_Api.G_RET_STS_ERROR;
346: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
347: l_return_status := x_return_status;
348: END IF;
349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR
350: p_slxv_rec.lpo_id IS NULL THEN

Line 349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR

345: x_return_status := Okl_Api.G_RET_STS_ERROR;
346: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
347: l_return_status := x_return_status;
348: END IF;
349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR
350: p_slxv_rec.lpo_id IS NULL THEN
351: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lpo_id');
352: x_return_status := Okl_Api.G_RET_STS_ERROR;
353: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 351: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lpo_id');

347: l_return_status := x_return_status;
348: END IF;
349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR
350: p_slxv_rec.lpo_id IS NULL THEN
351: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lpo_id');
352: x_return_status := Okl_Api.G_RET_STS_ERROR;
353: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
354: l_return_status := x_return_status;
355: END IF;

Line 352: x_return_status := Okl_Api.G_RET_STS_ERROR;

348: END IF;
349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR
350: p_slxv_rec.lpo_id IS NULL THEN
351: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lpo_id');
352: x_return_status := Okl_Api.G_RET_STS_ERROR;
353: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
354: l_return_status := x_return_status;
355: END IF;
356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR

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

349: ELSIF p_slxv_rec.lpo_id = Okl_Api.G_MISS_NUM OR
350: p_slxv_rec.lpo_id IS NULL THEN
351: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lpo_id');
352: x_return_status := Okl_Api.G_RET_STS_ERROR;
353: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
354: l_return_status := x_return_status;
355: END IF;
356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR
357: p_slxv_rec.sty_id IS NULL THEN

Line 356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR

352: x_return_status := Okl_Api.G_RET_STS_ERROR;
353: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
354: l_return_status := x_return_status;
355: END IF;
356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR
357: p_slxv_rec.sty_id IS NULL THEN
358: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
359: x_return_status := Okl_Api.G_RET_STS_ERROR;
360: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

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

354: l_return_status := x_return_status;
355: END IF;
356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR
357: p_slxv_rec.sty_id IS NULL THEN
358: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
359: x_return_status := Okl_Api.G_RET_STS_ERROR;
360: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
361: l_return_status := x_return_status;
362: END IF;

Line 359: x_return_status := Okl_Api.G_RET_STS_ERROR;

355: END IF;
356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR
357: p_slxv_rec.sty_id IS NULL THEN
358: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
359: x_return_status := Okl_Api.G_RET_STS_ERROR;
360: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
361: l_return_status := x_return_status;
362: END IF;
363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

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

356: ELSIF p_slxv_rec.sty_id = Okl_Api.G_MISS_NUM OR
357: p_slxv_rec.sty_id IS NULL THEN
358: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
359: x_return_status := Okl_Api.G_RET_STS_ERROR;
360: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
361: l_return_status := x_return_status;
362: END IF;
363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
364: p_slxv_rec.object_version_number IS NULL THEN

Line 363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

359: x_return_status := Okl_Api.G_RET_STS_ERROR;
360: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
361: l_return_status := x_return_status;
362: END IF;
363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
364: p_slxv_rec.object_version_number IS NULL THEN
365: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

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

361: l_return_status := x_return_status;
362: END IF;
363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
364: p_slxv_rec.object_version_number IS NULL THEN
365: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
368: l_return_status := x_return_status;
369: END IF;

Line 366: x_return_status := Okl_Api.G_RET_STS_ERROR;

362: END IF;
363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
364: p_slxv_rec.object_version_number IS NULL THEN
365: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
368: l_return_status := x_return_status;
369: END IF;
370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR

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

363: ELSIF p_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
364: p_slxv_rec.object_version_number IS NULL THEN
365: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
368: l_return_status := x_return_status;
369: END IF;
370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR
371: p_slxv_rec.late_policy_exempt_yn IS NULL THEN

Line 370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR

366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
368: l_return_status := x_return_status;
369: END IF;
370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR
371: p_slxv_rec.late_policy_exempt_yn IS NULL THEN
372: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_exempt_yn');
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 372: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_exempt_yn');

368: l_return_status := x_return_status;
369: END IF;
370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR
371: p_slxv_rec.late_policy_exempt_yn IS NULL THEN
372: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_exempt_yn');
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
375: l_return_status := x_return_status;
376: END IF;

Line 373: x_return_status := Okl_Api.G_RET_STS_ERROR;

369: END IF;
370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR
371: p_slxv_rec.late_policy_exempt_yn IS NULL THEN
372: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_exempt_yn');
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
375: l_return_status := x_return_status;
376: END IF;
377: END IF;

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

370: ELSIF p_slxv_rec.late_policy_exempt_yn = Okl_Api.G_MISS_CHAR OR
371: p_slxv_rec.late_policy_exempt_yn IS NULL THEN
372: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_exempt_yn');
373: x_return_status := Okl_Api.G_RET_STS_ERROR;
374: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
375: l_return_status := x_return_status;
376: END IF;
377: END IF;
378: RETURN(l_return_status);

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

396: -- Validate Record for:OKL_STRM_TYPE_EXEMPT_V --
397: ------------------------------------------------
398: FUNCTION Validate_Record (p_slxv_rec IN slxv_rec_type)
399: RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
401: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
402: BEGIN
403: RETURN (l_return_status);
404: EXCEPTION

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

397: ------------------------------------------------
398: FUNCTION Validate_Record (p_slxv_rec IN slxv_rec_type)
399: RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
401: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
402: BEGIN
403: RETURN (l_return_status);
404: EXCEPTION
405: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 408: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 414: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

Line 1533: IF (x_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM)

1529: IF (x_slxv_rec.id = Okc_Api.G_MISS_NUM)
1530: THEN
1531: x_slxv_rec.id := l_db_slxv_rec.id;
1532: END IF;
1533: IF (x_slxv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1534: THEN
1535: x_slxv_rec.object_version_number := l_db_slxv_rec.object_version_number;
1536: END IF;
1537: IF (x_slxv_rec.lpo_id = Okc_Api.G_MISS_NUM)