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

Line 57: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

53: x_return_status := G_RET_STS_ERROR;
54: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
55: p_region_code => G_AK_REGION_NAME,
56: p_attribute_code => 'OKL_STREAM_TYPE');
57: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
58: p_msg_name => 'OKL_REQUIRED_VALUE',
59: p_token1 => 'COL_NAME',
60: p_token1_value => l_ak_prompt);
61: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 70: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

66: x_return_status := G_RET_STS_ERROR;
67: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
68: p_region_code => G_AK_REGION_NAME,
69: p_attribute_code => 'OKL_STREAM_TYPE_SUBCLASS');
70: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
71: p_msg_name => 'OKL_REQUIRED_VALUE',
72: p_token1 => 'COL_NAME',
73: p_token1_value => l_ak_prompt);
74: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 84: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

80: x_return_status := G_RET_STS_ERROR;
81: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
82: p_region_code => G_AK_REGION_NAME,
83: p_attribute_code => 'OKL_LA_SEC_INVESTOR');
84: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
85: p_msg_name => 'OKL_REQUIRED_VALUE',
86: p_token1 => 'COL_NAME',
87: p_token1_value => l_ak_prompt);
88: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 97: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

93: x_return_status := G_RET_STS_ERROR;
94: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
95: p_region_code => G_AK_REGION_NAME,
96: p_attribute_code => 'OKL_SHARE_PERCENT');
97: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
98: p_msg_name => 'OKL_REQUIRED_VALUE',
99: p_token1 => 'COL_NAME',
100: p_token1_value => l_ak_prompt);
101: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 104: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

100: p_token1_value => l_ak_prompt);
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: ELSIF p_szr_rec.kle_percent_stake > 100 THEN
103: x_return_status := G_RET_STS_ERROR;
104: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
105: p_msg_name => 'OKL_LLA_PERCENT');
106: RAISE OKC_API.G_EXCEPTION_ERROR;
107: END IF;
108:

Line 117: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

113: x_return_status := G_RET_STS_ERROR;
114: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
115: p_region_code => G_AK_REGION_NAME,
116: p_attribute_code => 'OKL_STREAM_TYPE_SUBCLASS');
117: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
118: p_msg_name => 'OKL_INV_STY_UNIQUE',
119: p_token1 => 'STY_SUBCLASS',
120: p_token1_value => l_ak_prompt);
121: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 139: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

135: x_return_status := G_RET_STS_ERROR;
136: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
137: p_region_code => G_AK_REGION_NAME,
138: p_attribute_code => 'OKL_STREAM_TYPE');
139: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
140: p_msg_name => 'OKL_REV_SHARE_PERCENT',
141: p_token1 => 'TITLE',
142: p_token1_value => l_ak_prompt);
143: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 286: OKL_API.set_message(G_APP_NAME,'OKL_STY_NOT_UNIQUE');

282: l_found := l_okl_cle_sty_csr%FOUND;
283: CLOSE l_okl_cle_sty_csr;
284:
285: IF(l_found) THEN
286: OKL_API.set_message(G_APP_NAME,'OKL_STY_NOT_UNIQUE');
287: x_return_status := G_RET_STS_ERROR;
288: RAISE OKC_API.G_EXCEPTION_ERROR;
289: END IF;
290:

Line 320: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

316: p_klev_rec => l_klev_rec,
317: x_clev_rec => lx_clev_rec,
318: x_klev_rec => lx_klev_rec);
319:
320: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;

Line 321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

317: x_clev_rec => lx_clev_rec,
318: x_klev_rec => lx_klev_rec);
319:
320: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:

Line 322: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

318: x_klev_rec => lx_klev_rec);
319:
320: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:
326: --Call End Activity

Line 323: RAISE OKL_API.G_EXCEPTION_ERROR;

319:
320: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:
326: --Call End Activity
327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:
326: --Call End Activity
327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data);
329:
330:
331: EXCEPTION

Line 447: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

443: p_klev_rec => l_klev_rec,
444: x_clev_rec => lx_clev_rec,
445: x_klev_rec => lx_klev_rec);
446:
447: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_ERROR;
451: END IF;

Line 448: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

444: x_clev_rec => lx_clev_rec,
445: x_klev_rec => lx_klev_rec);
446:
447: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_ERROR;
451: END IF;
452:

Line 449: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

445: x_klev_rec => lx_klev_rec);
446:
447: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_ERROR;
451: END IF;
452:
453: --Call End Activity

Line 450: RAISE OKL_API.G_EXCEPTION_ERROR;

446:
447: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
449: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_ERROR;
451: END IF;
452:
453: --Call End Activity
454: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 454: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

450: RAISE OKL_API.G_EXCEPTION_ERROR;
451: END IF;
452:
453: --Call End Activity
454: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data);
456:
457:
458: EXCEPTION

Line 537: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

533: x_msg_data => x_msg_data,
534: p_clev_rec => l_clev_rec,
535: p_klev_rec => l_klev_rec);
536:
537: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_ERROR;
541: END IF;

Line 538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

534: p_clev_rec => l_clev_rec,
535: p_klev_rec => l_klev_rec);
536:
537: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_ERROR;
541: END IF;
542:

Line 539: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

535: p_klev_rec => l_klev_rec);
536:
537: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_ERROR;
541: END IF;
542:
543: --Call End Activity

Line 540: RAISE OKL_API.G_EXCEPTION_ERROR;

536:
537: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_ERROR;
541: END IF;
542:
543: --Call End Activity
544: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 544: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

540: RAISE OKL_API.G_EXCEPTION_ERROR;
541: END IF;
542:
543: --Call End Activity
544: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
545: x_msg_data => x_msg_data);
546: EXCEPTION
547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 615: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

611: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
612: x_return_status := G_RET_STS_UNEXP_ERROR;
613: WHEN OTHERS THEN
614: -- store SQL error message on message stack for caller
615: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
616: p_msg_name => G_UNEXPECTED_ERROR,
617: p_token1 => G_SQLCODE_TOKEN,
618: p_token1_value => SQLCODE,
619: p_token2 => G_SQLERRM_TOKEN,

Line 664: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

660: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
661: x_return_status := G_RET_STS_UNEXP_ERROR;
662: WHEN OTHERS THEN
663: -- store SQL error message on message stack for caller
664: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
665: p_msg_name => G_UNEXPECTED_ERROR,
666: p_token1 => G_SQLCODE_TOKEN,
667: p_token1_value => SQLCODE,
668: p_token2 => G_SQLERRM_TOKEN,

Line 711: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

707: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
708: x_return_status := G_RET_STS_UNEXP_ERROR;
709: WHEN OTHERS THEN
710: -- store SQL error message on message stack for caller
711: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
712: p_msg_name => G_UNEXPECTED_ERROR,
713: p_token1 => G_SQLCODE_TOKEN,
714: p_token1_value => SQLCODE,
715: p_token2 => G_SQLERRM_TOKEN,