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

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

37: p_format IN VARCHAR2 )
38: RETURN NUMBER IS
39: l_api_version CONSTANT NUMBER := 1;
40: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_ACCT_BAL';
41: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
42: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
43: l_msg_count NUMBER;
44: l_msg_data VARCHAR2(2000);
45: x_request_id NUMBER;

Line 42: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;

38: RETURN NUMBER IS
39: l_api_version CONSTANT NUMBER := 1;
40: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_ACCT_BAL';
41: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
42: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
43: l_msg_count NUMBER;
44: l_msg_data VARCHAR2(2000);
45: x_request_id NUMBER;
46: BEGIN

Line 47: x_return_status := OKL_API.G_RET_STS_SUCCESS;

43: l_msg_count NUMBER;
44: l_msg_data VARCHAR2(2000);
45: x_request_id NUMBER;
46: BEGIN
47: x_return_status := OKL_API.G_RET_STS_SUCCESS;
48: l_return_status := OKL_API.START_ACTIVITY(l_api_name
49: ,G_PKG_NAME
50: ,p_init_msg_list
51: ,l_api_version

Line 48: l_return_status := OKL_API.START_ACTIVITY(l_api_name

44: l_msg_data VARCHAR2(2000);
45: x_request_id NUMBER;
46: BEGIN
47: x_return_status := OKL_API.G_RET_STS_SUCCESS;
48: l_return_status := OKL_API.START_ACTIVITY(l_api_name
49: ,G_PKG_NAME
50: ,p_init_msg_list
51: ,l_api_version
52: ,p_api_version

Line 55: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

51: ,l_api_version
52: ,p_api_version
53: ,'_PVT'
54: ,l_return_status);
55: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
56: RAISE okl_api.g_exception_unexpected_error;
57: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
58: RAISE okl_api.g_exception_error;
59: END IF;

Line 56: RAISE okl_api.g_exception_unexpected_error;

52: ,p_api_version
53: ,'_PVT'
54: ,l_return_status);
55: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
56: RAISE okl_api.g_exception_unexpected_error;
57: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
58: RAISE okl_api.g_exception_error;
59: END IF;
60: -- check for p_contract_number before submitting the request.

Line 57: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN

53: ,'_PVT'
54: ,l_return_status);
55: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
56: RAISE okl_api.g_exception_unexpected_error;
57: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
58: RAISE okl_api.g_exception_error;
59: END IF;
60: -- check for p_contract_number before submitting the request.
61: IF (p_contract_number IS NULL) OR (p_contract_number = Okl_Api.G_MISS_CHAR) THEN

Line 58: RAISE okl_api.g_exception_error;

54: ,l_return_status);
55: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
56: RAISE okl_api.g_exception_unexpected_error;
57: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
58: RAISE okl_api.g_exception_error;
59: END IF;
60: -- check for p_contract_number before submitting the request.
61: IF (p_contract_number IS NULL) OR (p_contract_number = Okl_Api.G_MISS_CHAR) THEN
62: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Contract Number');

Line 61: IF (p_contract_number IS NULL) OR (p_contract_number = Okl_Api.G_MISS_CHAR) THEN

57: ELSIF (l_return_Status = okl_api.g_ret_sts_error) THEN
58: RAISE okl_api.g_exception_error;
59: END IF;
60: -- check for p_contract_number before submitting the request.
61: IF (p_contract_number IS NULL) OR (p_contract_number = Okl_Api.G_MISS_CHAR) THEN
62: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Contract Number');
63: RAISE Okl_Api.G_EXCEPTION_ERROR;
64: END IF;
65:

Line 63: RAISE Okl_Api.G_EXCEPTION_ERROR;

59: END IF;
60: -- check for p_contract_number before submitting the request.
61: IF (p_contract_number IS NULL) OR (p_contract_number = Okl_Api.G_MISS_CHAR) THEN
62: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Contract Number');
63: RAISE Okl_Api.G_EXCEPTION_ERROR;
64: END IF;
65:
66: -- check for p_account_from before submitting the request.
67: IF (p_account_from IS NULL) OR (p_account_from = Okl_Api.G_MISS_CHAR) THEN

Line 67: IF (p_account_from IS NULL) OR (p_account_from = Okl_Api.G_MISS_CHAR) THEN

63: RAISE Okl_Api.G_EXCEPTION_ERROR;
64: END IF;
65:
66: -- check for p_account_from before submitting the request.
67: IF (p_account_from IS NULL) OR (p_account_from = Okl_Api.G_MISS_CHAR) THEN
68: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Account From');
69: RAISE Okl_Api.G_EXCEPTION_ERROR;
70: END IF;
71:

Line 69: RAISE Okl_Api.G_EXCEPTION_ERROR;

65:
66: -- check for p_account_from before submitting the request.
67: IF (p_account_from IS NULL) OR (p_account_from = Okl_Api.G_MISS_CHAR) THEN
68: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Account From');
69: RAISE Okl_Api.G_EXCEPTION_ERROR;
70: END IF;
71:
72: -- check for p_account_to before submitting the request.
73: IF (p_account_to IS NULL) OR (p_account_to = Okl_Api.G_MISS_CHAR) THEN

Line 73: IF (p_account_to IS NULL) OR (p_account_to = Okl_Api.G_MISS_CHAR) THEN

69: RAISE Okl_Api.G_EXCEPTION_ERROR;
70: END IF;
71:
72: -- check for p_account_to before submitting the request.
73: IF (p_account_to IS NULL) OR (p_account_to = Okl_Api.G_MISS_CHAR) THEN
74: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Account To');
75: RAISE Okl_Api.G_EXCEPTION_ERROR;
76: END IF;
77:

Line 75: RAISE Okl_Api.G_EXCEPTION_ERROR;

71:
72: -- check for p_account_to before submitting the request.
73: IF (p_account_to IS NULL) OR (p_account_to = Okl_Api.G_MISS_CHAR) THEN
74: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Account To');
75: RAISE Okl_Api.G_EXCEPTION_ERROR;
76: END IF;
77:
78:
79: -- Submit Concurrent Program Request for interest calculation

Line 101: RAISE okl_api.g_exception_error;

97: p_token1 => 'PROG_NAME',
98: p_token1_value => 'Account Balances Report',
99: p_token2 => 'REQUEST_ID',
100: p_token2_value => x_request_id);
101: RAISE okl_api.g_exception_error;
102: ELSE
103: -- Return the request Id if has been submitted successfully.
104: x_return_status := l_return_status;
105: okl_api.end_activity(x_msg_count, x_msg_data);

Line 105: okl_api.end_activity(x_msg_count, x_msg_data);

101: RAISE okl_api.g_exception_error;
102: ELSE
103: -- Return the request Id if has been submitted successfully.
104: x_return_status := l_return_status;
105: okl_api.end_activity(x_msg_count, x_msg_data);
106: END IF;
107: RETURN x_request_id;
108:
109: EXCEPTION

Line 111: WHEN okl_api.g_exception_error THEN

107: RETURN x_request_id;
108:
109: EXCEPTION
110:
111: WHEN okl_api.g_exception_error THEN
112: x_return_status := Okl_Api.handle_exceptions(l_api_name
113: ,g_pkg_name
114: ,'OKL_API.G_RET_STS_ERROR'
115: ,x_msg_count

Line 112: x_return_status := Okl_Api.handle_exceptions(l_api_name

108:
109: EXCEPTION
110:
111: WHEN okl_api.g_exception_error THEN
112: x_return_status := Okl_Api.handle_exceptions(l_api_name
113: ,g_pkg_name
114: ,'OKL_API.G_RET_STS_ERROR'
115: ,x_msg_count
116: ,x_msg_data

Line 114: ,'OKL_API.G_RET_STS_ERROR'

110:
111: WHEN okl_api.g_exception_error THEN
112: x_return_status := Okl_Api.handle_exceptions(l_api_name
113: ,g_pkg_name
114: ,'OKL_API.G_RET_STS_ERROR'
115: ,x_msg_count
116: ,x_msg_data
117: ,'_PVT');
118: RETURN x_request_id;

Line 119: WHEN okl_api.g_exception_unexpected_error THEN

115: ,x_msg_count
116: ,x_msg_data
117: ,'_PVT');
118: RETURN x_request_id;
119: WHEN okl_api.g_exception_unexpected_error THEN
120: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
121: ,g_pkg_name
122: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
123: ,x_msg_count

Line 120: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

116: ,x_msg_data
117: ,'_PVT');
118: RETURN x_request_id;
119: WHEN okl_api.g_exception_unexpected_error THEN
120: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
121: ,g_pkg_name
122: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
123: ,x_msg_count
124: ,x_msg_data

Line 122: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

118: RETURN x_request_id;
119: WHEN okl_api.g_exception_unexpected_error THEN
120: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
121: ,g_pkg_name
122: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
123: ,x_msg_count
124: ,x_msg_data
125: ,'_PVT');
126: RETURN x_request_id;

Line 128: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

124: ,x_msg_data
125: ,'_PVT');
126: RETURN x_request_id;
127: WHEN OTHERS THEN
128: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
129: (l_api_name,
130: G_PKG_NAME,
131: 'OTHERS',
132: x_msg_count,