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

Line 75: x_return_status := OKL_API.G_RET_STS_SUCCESS;

71:
72:
73: BEGIN
74:
75: x_return_status := OKL_API.G_RET_STS_SUCCESS;
76:
77: l_return_status := OKL_API.START_ACTIVITY(
78: p_api_name => l_api_name,
79: p_pkg_name => g_pkg_name,

Line 77: l_return_status := OKL_API.START_ACTIVITY(

73: BEGIN
74:
75: x_return_status := OKL_API.G_RET_STS_SUCCESS;
76:
77: l_return_status := OKL_API.START_ACTIVITY(
78: p_api_name => l_api_name,
79: p_pkg_name => g_pkg_name,
80: p_init_msg_list => p_init_msg_list,
81: l_api_version => l_api_version,

Line 86: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

82: p_api_version => p_api_version,
83: p_api_type => '_PVT',
84: x_return_status => l_return_status);
85:
86: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;

Line 87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

83: p_api_type => '_PVT',
84: x_return_status => l_return_status);
85:
86: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:

Line 88: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

84: x_return_status => l_return_status);
85:
86: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:
92:

Line 89: RAISE OKL_API.G_EXCEPTION_ERROR;

85:
86: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
87: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
88: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:
92:
93: -- dbms_output.put_line('Count of Rec: '||l_cntr_bill_tbl.COUNT);

Line 171: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

167: RAISE l_clc_ext;
168: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
169: RAISE l_clc_ext;
170: END IF;
171: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
172:
173: EXCEPTION
174: WHEN l_clc_ext THEN
175: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 175: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

171: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
172:
173: EXCEPTION
174: WHEN l_clc_ext THEN
175: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: l_msg_data := 'Problems with Calculate';
178: x_msg_data := l_msg_data ;
179:

Line 182: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

178: x_msg_data := l_msg_data ;
179:
180: WHEN others THEN
181: --dbms_output.put_line('In Exception '||l_msg_count||'data: '||l_msg_data);
182: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: l_msg_data := '';
185: x_msg_data := l_msg_data ;
186:

Line 334: x_return_status := OKL_API.G_RET_STS_SUCCESS;

330: WHERE counter_id = l_cntr_num; */
331:
332: BEGIN
333:
334: x_return_status := OKL_API.G_RET_STS_SUCCESS;
335:
336: l_return_status := OKL_API.START_ACTIVITY(
337: p_api_name => l_api_name,
338: p_pkg_name => g_pkg_name,

Line 336: l_return_status := OKL_API.START_ACTIVITY(

332: BEGIN
333:
334: x_return_status := OKL_API.G_RET_STS_SUCCESS;
335:
336: l_return_status := OKL_API.START_ACTIVITY(
337: p_api_name => l_api_name,
338: p_pkg_name => g_pkg_name,
339: p_init_msg_list => p_init_msg_list,
340: l_api_version => l_api_version,

Line 458: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

454: ELSE
455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose USAGE_PAYMENT.');
456: END IF;
457:
458: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
461: RAISE Okl_Api.G_EXCEPTION_ERROR;
462: END IF;

Line 459: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- ERROR: Could not retrieve Stream Id for purpose USAGE_PAYMENT.');
456: END IF;
457:
458: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
461: RAISE Okl_Api.G_EXCEPTION_ERROR;
462: END IF;
463:

Line 460: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

456: END IF;
457:
458: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
461: RAISE Okl_Api.G_EXCEPTION_ERROR;
462: END IF;
463:
464: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Stream Type => '||l_sty_id);

Line 461: RAISE Okl_Api.G_EXCEPTION_ERROR;

457:
458: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
461: RAISE Okl_Api.G_EXCEPTION_ERROR;
462: END IF;
463:
464: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Stream Type => '||l_sty_id);
465:

Line 510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

506: );
507:
508: --dbms_output.put_line('success?'||x_return_status);
509:
510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
513: RAISE Okl_Api.G_EXCEPTION_ERROR;
514: END IF;

Line 511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

507:
508: --dbms_output.put_line('success?'||x_return_status);
509:
510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
513: RAISE Okl_Api.G_EXCEPTION_ERROR;
514: END IF;
515:

Line 512: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

508: --dbms_output.put_line('success?'||x_return_status);
509:
510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
513: RAISE Okl_Api.G_EXCEPTION_ERROR;
514: END IF;
515:
516: END IF; -- Bug 4902775

Line 513: RAISE Okl_Api.G_EXCEPTION_ERROR;

509:
510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
511: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
512: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
513: RAISE Okl_Api.G_EXCEPTION_ERROR;
514: END IF;
515:
516: END IF; -- Bug 4902775
517:

Line 597: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

593: RAISE l_ins_ext;
594: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
595: RAISE l_ins_ext;
596: END IF;
597: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
598:
599: EXCEPTION
600: WHEN l_ins_ext THEN
601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

597: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
598:
599: EXCEPTION
600: WHEN l_ins_ext THEN
601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
602: x_msg_count := l_msg_count ;
603: l_msg_data := 'Problems with Insert into internal tables';
604: x_msg_data := l_msg_data ;
605:

Line 607: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

603: l_msg_data := 'Problems with Insert into internal tables';
604: x_msg_data := l_msg_data ;
605:
606: WHEN others THEN
607: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
608: x_msg_count := l_msg_count ;
609: l_msg_data := '';
610: x_msg_data := l_msg_data ;
611: