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';
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';
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';
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;
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
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:
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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(
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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;
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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:
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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,
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
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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,
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
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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,
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
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,
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,
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
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,
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;
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:
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:
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:
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;
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:
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:
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:
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,
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',
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,
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:
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',
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,
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:
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,