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

Line 8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

4: -------------------------------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';

Line 15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: ------------------------------------------------------------------------------------
17: -- GLOBAL EXCEPTION
18: ------------------------------------------------------------------------------------
19: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 30: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

26: -----------------------------------------------------------------------------------
27:
28: Procedure allocate_streams(
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,
34: p_chr_id IN NUMBER) IS

Line 38: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

34: p_chr_id IN NUMBER) IS
35:
36: l_api_name CONSTANT VARCHAR2(30) := 'ALLOCATE_STREAMS';
37: l_api_version CONSTANT NUMBER := 1;
38: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
39: l_chr_id NUMBER := p_chr_id;
40:
41: BEGIN
42:

Line 43: x_return_status := OKL_API.START_ACTIVITY(

39: l_chr_id NUMBER := p_chr_id;
40:
41: BEGIN
42:
43: x_return_status := OKL_API.START_ACTIVITY(
44: p_api_name => l_api_name,
45: p_pkg_name => g_pkg_name,
46: p_init_msg_list => p_init_msg_list,
47: l_api_version => l_api_version,

Line 53: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

49: p_api_type => G_API_TYPE,
50: x_return_status => x_return_status);
51:
52: -- check if activity started successfully
53: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
54: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
56: raise OKL_API.G_EXCEPTION_ERROR;
57: End If;

Line 54: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

50: x_return_status => x_return_status);
51:
52: -- check if activity started successfully
53: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
54: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
56: raise OKL_API.G_EXCEPTION_ERROR;
57: End If;
58:

Line 55: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

51:
52: -- check if activity started successfully
53: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
54: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
56: raise OKL_API.G_EXCEPTION_ERROR;
57: End If;
58:
59:

Line 56: raise OKL_API.G_EXCEPTION_ERROR;

52: -- check if activity started successfully
53: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
54: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
56: raise OKL_API.G_EXCEPTION_ERROR;
57: End If;
58:
59:
60:

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

67: x_msg_data,
68: p_chr_id);
69:
70:
71: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;

Line 72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

68: p_chr_id);
69:
70:
71: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;
76:

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

69:
70:
71: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;
76:
77:

Line 74: RAISE OKL_API.G_EXCEPTION_ERROR;

70:
71: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;
76:
77:
78:

Line 80: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

76:
77:
78:
79:
80: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
81: Exception
82: when OKL_API.G_EXCEPTION_ERROR then
83: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
84: p_api_name => l_api_name,

Line 82: when OKL_API.G_EXCEPTION_ERROR then

78:
79:
80: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
81: Exception
82: when OKL_API.G_EXCEPTION_ERROR then
83: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
84: p_api_name => l_api_name,
85: p_pkg_name => g_pkg_name,
86: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 83: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

79:
80: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
81: Exception
82: when OKL_API.G_EXCEPTION_ERROR then
83: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
84: p_api_name => l_api_name,
85: p_pkg_name => g_pkg_name,
86: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
87: x_msg_count => x_msg_count,

Line 86: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

82: when OKL_API.G_EXCEPTION_ERROR then
83: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
84: p_api_name => l_api_name,
85: p_pkg_name => g_pkg_name,
86: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
87: x_msg_count => x_msg_count,
88: x_msg_data => x_msg_data,
89: p_api_type => g_api_type);
90:

Line 91: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

87: x_msg_count => x_msg_count,
88: x_msg_data => x_msg_data,
89: p_api_type => g_api_type);
90:
91: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
92: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
93: p_api_name => l_api_name,
94: p_pkg_name => g_pkg_name,
95: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 92: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

88: x_msg_data => x_msg_data,
89: p_api_type => g_api_type);
90:
91: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
92: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
93: p_api_name => l_api_name,
94: p_pkg_name => g_pkg_name,
95: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
96: x_msg_count => x_msg_count,

Line 95: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

91: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
92: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
93: p_api_name => l_api_name,
94: p_pkg_name => g_pkg_name,
95: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
96: x_msg_count => x_msg_count,
97: x_msg_data => x_msg_data,
98: p_api_type => g_api_type);
99:

Line 101: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

97: x_msg_data => x_msg_data,
98: p_api_type => g_api_type);
99:
100: when OTHERS then
101: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
102: p_api_name => l_api_name,
103: p_pkg_name => g_pkg_name,
104: p_exc_name => 'OTHERS',
105: x_msg_count => x_msg_count,

Line 125: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

121: x_trx_status OUT NOCOPY VARCHAR2) IS
122:
123: l_api_name CONSTANT VARCHAR2(30) := 'GEN_STREAM_PUB';
124: l_api_version CONSTANT NUMBER := 1;
125: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
126:
127: BEGIN
128:
129: x_return_status := OKL_API.START_ACTIVITY(

Line 129: x_return_status := OKL_API.START_ACTIVITY(

125: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
126:
127: BEGIN
128:
129: x_return_status := OKL_API.START_ACTIVITY(
130: p_api_name => l_api_name,
131: p_pkg_name => g_pkg_name,
132: p_init_msg_list => p_init_msg_list,
133: l_api_version => l_api_version,

Line 139: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

135: p_api_type => G_API_TYPE,
136: x_return_status => x_return_status);
137:
138: -- check if activity started successfully
139: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
140: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
142: raise OKL_API.G_EXCEPTION_ERROR;
143: End If;

Line 140: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

136: x_return_status => x_return_status);
137:
138: -- check if activity started successfully
139: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
140: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
142: raise OKL_API.G_EXCEPTION_ERROR;
143: End If;
144:

Line 141: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

137:
138: -- check if activity started successfully
139: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
140: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
142: raise OKL_API.G_EXCEPTION_ERROR;
143: End If;
144:
145:

Line 142: raise OKL_API.G_EXCEPTION_ERROR;

138: -- check if activity started successfully
139: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
140: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
142: raise OKL_API.G_EXCEPTION_ERROR;
143: End If;
144:
145:
146:

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

156: p_generation_ctx_code,
157: x_trx_number,
158: x_trx_status);
159:
160: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;

Line 161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

157: x_trx_number,
158: x_trx_status);
159:
160: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;
165:

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

158: x_trx_status);
159:
160: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;
165:
166:

Line 163: RAISE OKL_API.G_EXCEPTION_ERROR;

159:
160: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
163: RAISE OKL_API.G_EXCEPTION_ERROR;
164: END IF;
165:
166:
167:

Line 168: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

164: END IF;
165:
166:
167:
168: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
169: Exception
170: when OKL_API.G_EXCEPTION_ERROR then
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
172: p_api_name => l_api_name,

Line 170: when OKL_API.G_EXCEPTION_ERROR then

166:
167:
168: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
169: Exception
170: when OKL_API.G_EXCEPTION_ERROR then
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
172: p_api_name => l_api_name,
173: p_pkg_name => g_pkg_name,
174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

167:
168: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
169: Exception
170: when OKL_API.G_EXCEPTION_ERROR then
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
172: p_api_name => l_api_name,
173: p_pkg_name => g_pkg_name,
174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
175: x_msg_count => x_msg_count,

Line 174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

170: when OKL_API.G_EXCEPTION_ERROR then
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
172: p_api_name => l_api_name,
173: p_pkg_name => g_pkg_name,
174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
175: x_msg_count => x_msg_count,
176: x_msg_data => x_msg_data,
177: p_api_type => g_api_type);
178:

Line 179: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

175: x_msg_count => x_msg_count,
176: x_msg_data => x_msg_data,
177: p_api_type => g_api_type);
178:
179: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
181: p_api_name => l_api_name,
182: p_pkg_name => g_pkg_name,
183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

176: x_msg_data => x_msg_data,
177: p_api_type => g_api_type);
178:
179: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
181: p_api_name => l_api_name,
182: p_pkg_name => g_pkg_name,
183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
184: x_msg_count => x_msg_count,

Line 183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

179: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
181: p_api_name => l_api_name,
182: p_pkg_name => g_pkg_name,
183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data,
186: p_api_type => g_api_type);
187:

Line 189: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

185: x_msg_data => x_msg_data,
186: p_api_type => g_api_type);
187:
188: when OTHERS then
189: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
190: p_api_name => l_api_name,
191: p_pkg_name => g_pkg_name,
192: p_exc_name => 'OTHERS',
193: x_msg_count => x_msg_count,

Line 214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

210: x_trans_status OUT NOCOPY VARCHAR2) IS
211:
212: l_api_name CONSTANT VARCHAR2(30) := 'MAP_AND_GEN_STREAMS';
213: l_api_version CONSTANT NUMBER := 1;
214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
215:
216: l_chr_id NUMBER := p_chr_id;
217: l_generation_context VARCHAR2(256) := p_generation_context;
218: l_skip_prc_engine VARCHAR2(1) := p_skip_prc_engine;

Line 222: x_return_status := OKL_API.START_ACTIVITY(

218: l_skip_prc_engine VARCHAR2(1) := p_skip_prc_engine;
219:
220: BEGIN
221:
222: x_return_status := OKL_API.START_ACTIVITY(
223: p_api_name => l_api_name,
224: p_pkg_name => g_pkg_name,
225: p_init_msg_list => p_init_msg_list,
226: l_api_version => l_api_version,

Line 232: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

228: p_api_type => G_API_TYPE,
229: x_return_status => x_return_status);
230:
231: -- check if activity started successfully
232: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
233: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
234: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
235: raise OKL_API.G_EXCEPTION_ERROR;
236: End If;

Line 233: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

229: x_return_status => x_return_status);
230:
231: -- check if activity started successfully
232: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
233: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
234: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
235: raise OKL_API.G_EXCEPTION_ERROR;
236: End If;
237:

Line 234: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

230:
231: -- check if activity started successfully
232: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
233: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
234: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
235: raise OKL_API.G_EXCEPTION_ERROR;
236: End If;
237:
238:

Line 235: raise OKL_API.G_EXCEPTION_ERROR;

231: -- check if activity started successfully
232: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
233: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
234: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
235: raise OKL_API.G_EXCEPTION_ERROR;
236: End If;
237:
238:
239:

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

250: x_msg_data,
251: x_request_id,
252: x_trans_status);
253:
254: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
255: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;

Line 255: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

251: x_request_id,
252: x_trans_status);
253:
254: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
255: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259:

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

252: x_trans_status);
253:
254: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
255: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259:
260:

Line 257: RAISE OKL_API.G_EXCEPTION_ERROR;

253:
254: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
255: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259:
260:
261:

Line 262: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

258: END IF;
259:
260:
261:
262: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
263: Exception
264: when OKL_API.G_EXCEPTION_ERROR then
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,

Line 264: when OKL_API.G_EXCEPTION_ERROR then

260:
261:
262: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
263: Exception
264: when OKL_API.G_EXCEPTION_ERROR then
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => g_pkg_name,
268: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 265: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

261:
262: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
263: Exception
264: when OKL_API.G_EXCEPTION_ERROR then
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => g_pkg_name,
268: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
269: x_msg_count => x_msg_count,

Line 268: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

264: when OKL_API.G_EXCEPTION_ERROR then
265: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => g_pkg_name,
268: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
269: x_msg_count => x_msg_count,
270: x_msg_data => x_msg_data,
271: p_api_type => g_api_type);
272:

Line 273: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

269: x_msg_count => x_msg_count,
270: x_msg_data => x_msg_data,
271: p_api_type => g_api_type);
272:
273: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
274: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
275: p_api_name => l_api_name,
276: p_pkg_name => g_pkg_name,
277: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 274: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

270: x_msg_data => x_msg_data,
271: p_api_type => g_api_type);
272:
273: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
274: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
275: p_api_name => l_api_name,
276: p_pkg_name => g_pkg_name,
277: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
278: x_msg_count => x_msg_count,

Line 277: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

273: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
274: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
275: p_api_name => l_api_name,
276: p_pkg_name => g_pkg_name,
277: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
278: x_msg_count => x_msg_count,
279: x_msg_data => x_msg_data,
280: p_api_type => g_api_type);
281:

Line 283: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

279: x_msg_data => x_msg_data,
280: p_api_type => g_api_type);
281:
282: when OTHERS then
283: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
284: p_api_name => l_api_name,
285: p_pkg_name => g_pkg_name,
286: p_exc_name => 'OTHERS',
287: x_msg_count => x_msg_count,

Line 306: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

302: p_chr_yields IN yields_rec_type) IS
303:
304: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_YIELDS';
305: l_api_version CONSTANT NUMBER := 1;
306: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
307:
308: l_chr_id VARCHAR2(256) := p_chr_id;
309: l_chr_yields yields_rec_type := p_chr_yields;
310:

Line 313: x_return_status := OKL_API.START_ACTIVITY(

309: l_chr_yields yields_rec_type := p_chr_yields;
310:
311: begin
312:
313: x_return_status := OKL_API.START_ACTIVITY(
314: p_api_name => l_api_name,
315: p_pkg_name => g_pkg_name,
316: p_init_msg_list => p_init_msg_list,
317: l_api_version => l_api_version,

Line 323: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

319: p_api_type => G_API_TYPE,
320: x_return_status => x_return_status);
321:
322: -- check if activity started successfully
323: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
324: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
325: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
326: raise OKL_API.G_EXCEPTION_ERROR;
327: End If;

Line 324: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

320: x_return_status => x_return_status);
321:
322: -- check if activity started successfully
323: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
324: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
325: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
326: raise OKL_API.G_EXCEPTION_ERROR;
327: End If;
328:

Line 325: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

321:
322: -- check if activity started successfully
323: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
324: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
325: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
326: raise OKL_API.G_EXCEPTION_ERROR;
327: End If;
328:
329:

Line 326: raise OKL_API.G_EXCEPTION_ERROR;

322: -- check if activity started successfully
323: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
324: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
325: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
326: raise OKL_API.G_EXCEPTION_ERROR;
327: End If;
328:
329:
330:

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

337: p_chr_id,
338: p_chr_yields);
339:
340:
341: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF;

Line 342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

338: p_chr_yields);
339:
340:
341: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF;
346:

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

339:
340:
341: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF;
346:
347:

Line 344: RAISE OKL_API.G_EXCEPTION_ERROR;

340:
341: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
344: RAISE OKL_API.G_EXCEPTION_ERROR;
345: END IF;
346:
347:
348:

Line 349: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

345: END IF;
346:
347:
348:
349: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
350: Exception
351: when OKL_API.G_EXCEPTION_ERROR then
352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
353: p_api_name => l_api_name,

Line 351: when OKL_API.G_EXCEPTION_ERROR then

347:
348:
349: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
350: Exception
351: when OKL_API.G_EXCEPTION_ERROR then
352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
353: p_api_name => l_api_name,
354: p_pkg_name => g_pkg_name,
355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

348:
349: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
350: Exception
351: when OKL_API.G_EXCEPTION_ERROR then
352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
353: p_api_name => l_api_name,
354: p_pkg_name => g_pkg_name,
355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
356: x_msg_count => x_msg_count,

Line 355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

351: when OKL_API.G_EXCEPTION_ERROR then
352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
353: p_api_name => l_api_name,
354: p_pkg_name => g_pkg_name,
355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
356: x_msg_count => x_msg_count,
357: x_msg_data => x_msg_data,
358: p_api_type => g_api_type);
359:

Line 360: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

356: x_msg_count => x_msg_count,
357: x_msg_data => x_msg_data,
358: p_api_type => g_api_type);
359:
360: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
362: p_api_name => l_api_name,
363: p_pkg_name => g_pkg_name,
364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

357: x_msg_data => x_msg_data,
358: p_api_type => g_api_type);
359:
360: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
362: p_api_name => l_api_name,
363: p_pkg_name => g_pkg_name,
364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
365: x_msg_count => x_msg_count,

Line 364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

360: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
362: p_api_name => l_api_name,
363: p_pkg_name => g_pkg_name,
364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
365: x_msg_count => x_msg_count,
366: x_msg_data => x_msg_data,
367: p_api_type => g_api_type);
368:

Line 370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

366: x_msg_data => x_msg_data,
367: p_api_type => g_api_type);
368:
369: when OTHERS then
370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
371: p_api_name => l_api_name,
372: p_pkg_name => g_pkg_name,
373: p_exc_name => 'OTHERS',
374: x_msg_count => x_msg_count,

Line 385: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

381:
382:
383: Procedure extract_params_lease(
384: p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
386: p_chr_id IN VARCHAR2,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2,

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

396: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type) IS
397:
398: l_api_name CONSTANT VARCHAR2(30) := 'LEASE_PARAMS';
399: l_api_version CONSTANT NUMBER := 1;
400: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
401:
402: l_chr_id VARCHAR2(256) := p_chr_id;
403:
404: begin

Line 406: x_return_status := OKL_API.START_ACTIVITY(

402: l_chr_id VARCHAR2(256) := p_chr_id;
403:
404: begin
405:
406: x_return_status := OKL_API.START_ACTIVITY(
407: p_api_name => l_api_name,
408: p_pkg_name => g_pkg_name,
409: p_init_msg_list => p_init_msg_list,
410: l_api_version => l_api_version,

Line 416: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

412: p_api_type => G_API_TYPE,
413: x_return_status => x_return_status);
414:
415: -- check if activity started successfully
416: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
417: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
419: raise OKL_API.G_EXCEPTION_ERROR;
420: End If;

Line 417: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

413: x_return_status => x_return_status);
414:
415: -- check if activity started successfully
416: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
417: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
419: raise OKL_API.G_EXCEPTION_ERROR;
420: End If;
421:

Line 418: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

414:
415: -- check if activity started successfully
416: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
417: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
419: raise OKL_API.G_EXCEPTION_ERROR;
420: End If;
421:
422:

Line 419: raise OKL_API.G_EXCEPTION_ERROR;

415: -- check if activity started successfully
416: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
417: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
419: raise OKL_API.G_EXCEPTION_ERROR;
420: End If;
421:
422:
423:

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

435: x_req_stream_types_tbl,
436: x_csm_line_details_tbl,
437: x_rents_tbl);
438:
439: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;

Line 440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

436: x_csm_line_details_tbl,
437: x_rents_tbl);
438:
439: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:

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

437: x_rents_tbl);
438:
439: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
445:

Line 442: RAISE OKL_API.G_EXCEPTION_ERROR;

438:
439: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
445:
446:

Line 447: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

443: END IF;
444:
445:
446:
447: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
448: Exception
449: when OKL_API.G_EXCEPTION_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,

Line 449: when OKL_API.G_EXCEPTION_ERROR then

445:
446:
447: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
448: Exception
449: when OKL_API.G_EXCEPTION_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

446:
447: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
448: Exception
449: when OKL_API.G_EXCEPTION_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
454: x_msg_count => x_msg_count,

Line 453: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

449: when OKL_API.G_EXCEPTION_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
454: x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:

Line 458: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

454: x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:
458: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:
458: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
463: x_msg_count => x_msg_count,

Line 462: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

458: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_api_type => g_api_type);
466:

Line 468: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

464: x_msg_data => x_msg_data,
465: p_api_type => g_api_type);
466:
467: when OTHERS then
468: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
469: p_api_name => l_api_name,
470: p_pkg_name => g_pkg_name,
471: p_exc_name => 'OTHERS',
472: x_msg_count => x_msg_count,

Line 481: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

477: end extract_params_lease;
478:
479: Procedure extract_params_loan(
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
482: p_chr_id IN VARCHAR2,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
485: x_msg_data OUT NOCOPY VARCHAR2,

Line 496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

492: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) IS
493:
494: l_api_name CONSTANT VARCHAR2(30) := 'LOAN_PARAMS';
495: l_api_version CONSTANT NUMBER := 1;
496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
497:
498: l_chr_id VARCHAR2(256) := p_chr_id;
499:
500: begin

Line 502: x_return_status := OKL_API.START_ACTIVITY(

498: l_chr_id VARCHAR2(256) := p_chr_id;
499:
500: begin
501:
502: x_return_status := OKL_API.START_ACTIVITY(
503: p_api_name => l_api_name,
504: p_pkg_name => g_pkg_name,
505: p_init_msg_list => p_init_msg_list,
506: l_api_version => l_api_version,

Line 512: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

508: p_api_type => G_API_TYPE,
509: x_return_status => x_return_status);
510:
511: -- check if activity started successfully
512: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
513: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
515: raise OKL_API.G_EXCEPTION_ERROR;
516: End If;

Line 513: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

509: x_return_status => x_return_status);
510:
511: -- check if activity started successfully
512: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
513: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
515: raise OKL_API.G_EXCEPTION_ERROR;
516: End If;
517:

Line 514: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

510:
511: -- check if activity started successfully
512: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
513: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
515: raise OKL_API.G_EXCEPTION_ERROR;
516: End If;
517:
518:

Line 515: raise OKL_API.G_EXCEPTION_ERROR;

511: -- check if activity started successfully
512: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
513: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
515: raise OKL_API.G_EXCEPTION_ERROR;
516: End If;
517:
518:
519:

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

531: x_csm_periodic_expenses_tbl,
532: x_csm_yields_tbl,
533: x_csm_stream_types_tbl);
534:
535: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;

Line 536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

532: x_csm_yields_tbl,
533: x_csm_stream_types_tbl);
534:
535: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:

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

533: x_csm_stream_types_tbl);
534:
535: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541:

Line 538: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 543: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

539: END IF;
540:
541:
542:
543: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
544: Exception
545: when OKL_API.G_EXCEPTION_ERROR then
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: p_api_name => l_api_name,

Line 545: when OKL_API.G_EXCEPTION_ERROR then

541:
542:
543: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
544: Exception
545: when OKL_API.G_EXCEPTION_ERROR then
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: p_api_name => l_api_name,
548: p_pkg_name => g_pkg_name,
549: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

542:
543: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
544: Exception
545: when OKL_API.G_EXCEPTION_ERROR then
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: p_api_name => l_api_name,
548: p_pkg_name => g_pkg_name,
549: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
550: x_msg_count => x_msg_count,

Line 549: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

545: when OKL_API.G_EXCEPTION_ERROR then
546: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
547: p_api_name => l_api_name,
548: p_pkg_name => g_pkg_name,
549: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
550: x_msg_count => x_msg_count,
551: x_msg_data => x_msg_data,
552: p_api_type => g_api_type);
553:

Line 554: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

550: x_msg_count => x_msg_count,
551: x_msg_data => x_msg_data,
552: p_api_type => g_api_type);
553:
554: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
556: p_api_name => l_api_name,
557: p_pkg_name => g_pkg_name,
558: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

551: x_msg_data => x_msg_data,
552: p_api_type => g_api_type);
553:
554: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
556: p_api_name => l_api_name,
557: p_pkg_name => g_pkg_name,
558: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
559: x_msg_count => x_msg_count,

Line 558: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

554: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
556: p_api_name => l_api_name,
557: p_pkg_name => g_pkg_name,
558: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
559: x_msg_count => x_msg_count,
560: x_msg_data => x_msg_data,
561: p_api_type => g_api_type);
562:

Line 564: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

560: x_msg_data => x_msg_data,
561: p_api_type => g_api_type);
562:
563: when OTHERS then
564: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
565: p_api_name => l_api_name,
566: p_pkg_name => g_pkg_name,
567: p_exc_name => 'OTHERS',
568: x_msg_count => x_msg_count,

Line 577: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

573: end extract_params_loan;
574:
575: Procedure extract_params_loan_paydown(
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
578: p_chr_id IN VARCHAR2,
579: p_deal_type IN VARCHAR2,
580: p_paydown_type IN VARCHAR2,
581: p_paydown_date IN DATE,

Line 597: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

593: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) IS
594:
595: l_api_name CONSTANT VARCHAR2(30) := 'EXTRACT_PARAMS_LOAN_PPD';
596: l_api_version CONSTANT NUMBER := 1;
597: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
598:
599: l_chr_id VARCHAR2(256) := p_chr_id;
600:
601: begin

Line 603: x_return_status := OKL_API.START_ACTIVITY(

599: l_chr_id VARCHAR2(256) := p_chr_id;
600:
601: begin
602:
603: x_return_status := OKL_API.START_ACTIVITY(
604: p_api_name => l_api_name,
605: p_pkg_name => g_pkg_name,
606: p_init_msg_list => p_init_msg_list,
607: l_api_version => l_api_version,

Line 613: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

609: p_api_type => G_API_TYPE,
610: x_return_status => x_return_status);
611:
612: -- check if activity started successfully
613: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
616: raise OKL_API.G_EXCEPTION_ERROR;
617: End If;

Line 614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

610: x_return_status => x_return_status);
611:
612: -- check if activity started successfully
613: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
616: raise OKL_API.G_EXCEPTION_ERROR;
617: End If;
618:

Line 615: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

611:
612: -- check if activity started successfully
613: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
616: raise OKL_API.G_EXCEPTION_ERROR;
617: End If;
618:
619:

Line 616: raise OKL_API.G_EXCEPTION_ERROR;

612: -- check if activity started successfully
613: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
616: raise OKL_API.G_EXCEPTION_ERROR;
617: End If;
618:
619:
620:

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

637: x_csm_periodic_expenses_tbl,
638: x_csm_yields_tbl,
639: x_csm_stream_types_tbl);
640:
641: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
642: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
643: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
644: RAISE OKL_API.G_EXCEPTION_ERROR;
645: END IF;

Line 642: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

638: x_csm_yields_tbl,
639: x_csm_stream_types_tbl);
640:
641: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
642: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
643: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
644: RAISE OKL_API.G_EXCEPTION_ERROR;
645: END IF;
646:

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

639: x_csm_stream_types_tbl);
640:
641: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
642: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
643: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
644: RAISE OKL_API.G_EXCEPTION_ERROR;
645: END IF;
646:
647:

Line 644: RAISE OKL_API.G_EXCEPTION_ERROR;

640:
641: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
642: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
643: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
644: RAISE OKL_API.G_EXCEPTION_ERROR;
645: END IF;
646:
647:
648:

Line 649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

645: END IF;
646:
647:
648:
649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
650: Exception
651: when OKL_API.G_EXCEPTION_ERROR then
652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
653: p_api_name => l_api_name,

Line 651: when OKL_API.G_EXCEPTION_ERROR then

647:
648:
649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
650: Exception
651: when OKL_API.G_EXCEPTION_ERROR then
652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
653: p_api_name => l_api_name,
654: p_pkg_name => g_pkg_name,
655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

648:
649: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
650: Exception
651: when OKL_API.G_EXCEPTION_ERROR then
652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
653: p_api_name => l_api_name,
654: p_pkg_name => g_pkg_name,
655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
656: x_msg_count => x_msg_count,

Line 655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

651: when OKL_API.G_EXCEPTION_ERROR then
652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
653: p_api_name => l_api_name,
654: p_pkg_name => g_pkg_name,
655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data,
658: p_api_type => g_api_type);
659:

Line 660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

656: x_msg_count => x_msg_count,
657: x_msg_data => x_msg_data,
658: p_api_type => g_api_type);
659:
660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
662: p_api_name => l_api_name,
663: p_pkg_name => g_pkg_name,
664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

657: x_msg_data => x_msg_data,
658: p_api_type => g_api_type);
659:
660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
662: p_api_name => l_api_name,
663: p_pkg_name => g_pkg_name,
664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
665: x_msg_count => x_msg_count,

Line 664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
662: p_api_name => l_api_name,
663: p_pkg_name => g_pkg_name,
664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
665: x_msg_count => x_msg_count,
666: x_msg_data => x_msg_data,
667: p_api_type => g_api_type);
668:

Line 670: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

666: x_msg_data => x_msg_data,
667: p_api_type => g_api_type);
668:
669: when OTHERS then
670: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
671: p_api_name => l_api_name,
672: p_pkg_name => g_pkg_name,
673: p_exc_name => 'OTHERS',
674: x_msg_count => x_msg_count,

Line 684: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

680:
681: --Added by kthiruva for Bug 5161075
682: Procedure extract_params_loan_reamort(
683: p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
685: p_chr_id IN VARCHAR2,
686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,

Line 699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

695: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) IS
696:
697: l_api_name CONSTANT VARCHAR2(30) := 'LOAN_PARAMS';
698: l_api_version CONSTANT NUMBER := 1;
699: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
700:
701: l_chr_id VARCHAR2(256) := p_chr_id;
702:
703: begin

Line 705: x_return_status := OKL_API.START_ACTIVITY(

701: l_chr_id VARCHAR2(256) := p_chr_id;
702:
703: begin
704:
705: x_return_status := OKL_API.START_ACTIVITY(
706: p_api_name => l_api_name,
707: p_pkg_name => g_pkg_name,
708: p_init_msg_list => p_init_msg_list,
709: l_api_version => l_api_version,

Line 715: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

711: p_api_type => G_API_TYPE,
712: x_return_status => x_return_status);
713:
714: -- check if activity started successfully
715: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
716: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
717: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
718: raise OKL_API.G_EXCEPTION_ERROR;
719: End If;

Line 716: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

712: x_return_status => x_return_status);
713:
714: -- check if activity started successfully
715: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
716: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
717: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
718: raise OKL_API.G_EXCEPTION_ERROR;
719: End If;
720:

Line 717: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

713:
714: -- check if activity started successfully
715: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
716: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
717: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
718: raise OKL_API.G_EXCEPTION_ERROR;
719: End If;
720:
721:

Line 718: raise OKL_API.G_EXCEPTION_ERROR;

714: -- check if activity started successfully
715: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
716: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
717: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
718: raise OKL_API.G_EXCEPTION_ERROR;
719: End If;
720:
721:
722:

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

734: x_csm_periodic_expenses_tbl,
735: x_csm_yields_tbl,
736: x_csm_stream_types_tbl);
737:
738: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_ERROR;
742: END IF;

Line 739: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

735: x_csm_yields_tbl,
736: x_csm_stream_types_tbl);
737:
738: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_ERROR;
742: END IF;
743:

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

736: x_csm_stream_types_tbl);
737:
738: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_ERROR;
742: END IF;
743:
744:

Line 741: RAISE OKL_API.G_EXCEPTION_ERROR;

737:
738: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_ERROR;
742: END IF;
743:
744:
745:

Line 746: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

742: END IF;
743:
744:
745:
746: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
747: Exception
748: when OKL_API.G_EXCEPTION_ERROR then
749: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
750: p_api_name => l_api_name,

Line 748: when OKL_API.G_EXCEPTION_ERROR then

744:
745:
746: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
747: Exception
748: when OKL_API.G_EXCEPTION_ERROR then
749: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
750: p_api_name => l_api_name,
751: p_pkg_name => g_pkg_name,
752: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 749: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

745:
746: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
747: Exception
748: when OKL_API.G_EXCEPTION_ERROR then
749: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
750: p_api_name => l_api_name,
751: p_pkg_name => g_pkg_name,
752: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
753: x_msg_count => x_msg_count,

Line 752: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

748: when OKL_API.G_EXCEPTION_ERROR then
749: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
750: p_api_name => l_api_name,
751: p_pkg_name => g_pkg_name,
752: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
753: x_msg_count => x_msg_count,
754: x_msg_data => x_msg_data,
755: p_api_type => g_api_type);
756:

Line 757: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

753: x_msg_count => x_msg_count,
754: x_msg_data => x_msg_data,
755: p_api_type => g_api_type);
756:
757: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
759: p_api_name => l_api_name,
760: p_pkg_name => g_pkg_name,
761: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

754: x_msg_data => x_msg_data,
755: p_api_type => g_api_type);
756:
757: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
759: p_api_name => l_api_name,
760: p_pkg_name => g_pkg_name,
761: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
762: x_msg_count => x_msg_count,

Line 761: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

757: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
759: p_api_name => l_api_name,
760: p_pkg_name => g_pkg_name,
761: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
762: x_msg_count => x_msg_count,
763: x_msg_data => x_msg_data,
764: p_api_type => g_api_type);
765:

Line 767: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

763: x_msg_data => x_msg_data,
764: p_api_type => g_api_type);
765:
766: when OTHERS then
767: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
768: p_api_name => l_api_name,
769: p_pkg_name => g_pkg_name,
770: p_exc_name => 'OTHERS',
771: x_msg_count => x_msg_count,