APPS.OKL_COPY_CONTRACT_PUB dependencies on OKL_API

Line 6: G_INIT_MSG_LIST CONSTANT VARCHAR2(10) := OKL_API.G_FALSE;

2: /* $Header: OKLPCOPB.pls 120.3 2005/10/14 19:35:40 apaul noship $ */
3:
4: G_API_VERSION CONSTANT NUMBER := 1;
5: G_SCOPE CONSTANT varchar2(4) := '_PUB';
6: G_INIT_MSG_LIST CONSTANT VARCHAR2(10) := OKL_API.G_FALSE;
7:
8:
9: FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN IS
10: BEGIN

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

57: p_lines_tbl IN api_lines_tbl,
58: x_chr_id OUT NOCOPY NUMBER) IS
59:
60: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_COMPONENTS';
61: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
62: BEGIN
63: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
64: G_PKG_NAME,
65: p_init_msg_list,

Line 63: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

59:
60: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_COMPONENTS';
61: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
62: BEGIN
63: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
64: G_PKG_NAME,
65: p_init_msg_list,
66: G_API_VERSION,
67: p_api_version,

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

66: G_API_VERSION,
67: p_api_version,
68: G_SCOPE,
69: x_return_status);
70: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
71: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
72: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_ERROR;
74: END IF;

Line 71: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

68: G_SCOPE,
69: x_return_status);
70: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
71: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
72: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_ERROR;
74: END IF;
75:
76: --Customer pre-processing Section

Line 73: RAISE OKL_API.G_EXCEPTION_ERROR;

69: x_return_status);
70: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
71: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
72: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_ERROR;
74: END IF;
75:
76: --Customer pre-processing Section
77: --Vertical Industry pre-processing Section

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

95: p_components_tbl => p_components_tbl,
96: p_lines_tbl => p_lines_tbl,
97: x_chr_id => x_chr_id);
98:
99: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_ERROR;
103: END IF;

Line 100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

96: p_lines_tbl => p_lines_tbl,
97: x_chr_id => x_chr_id);
98:
99: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_ERROR;
103: END IF;
104:

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

97: x_chr_id => x_chr_id);
98:
99: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_ERROR;
103: END IF;
104:
105: --Vertical post-processing Section

Line 102: RAISE OKL_API.G_EXCEPTION_ERROR;

98:
99: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_ERROR;
103: END IF;
104:
105: --Vertical post-processing Section
106:

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

105: --Vertical post-processing Section
106:
107: --Customer post-processing Section
108:
109: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
110:
111: EXCEPTION
112: WHEN OKL_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 112: WHEN OKL_API.G_EXCEPTION_ERROR THEN

108:
109: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
110:
111: EXCEPTION
112: WHEN OKL_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKL_API.HANDLE_EXCEPTIONS
114: (substr(l_api_name,1,26),
115: G_PKG_NAME,
116: --bug# 2518454

Line 113: x_return_status := OKL_API.HANDLE_EXCEPTIONS

109: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
110:
111: EXCEPTION
112: WHEN OKL_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKL_API.HANDLE_EXCEPTIONS
114: (substr(l_api_name,1,26),
115: G_PKG_NAME,
116: --bug# 2518454
117: --'OKC_API.G_RET_STS_ERROR',

Line 118: 'OKL_API.G_RET_STS_ERROR',

114: (substr(l_api_name,1,26),
115: G_PKG_NAME,
116: --bug# 2518454
117: --'OKC_API.G_RET_STS_ERROR',
118: 'OKL_API.G_RET_STS_ERROR',
119: x_msg_count,
120: x_msg_data,
121: G_SCOPE);
122: -- Resetting the global transaction id.

Line 124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

120: x_msg_data,
121: G_SCOPE);
122: -- Resetting the global transaction id.
123: okc_cvm_pvt.g_trans_id := 'XXX';
124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
126: (substr(l_api_name,1,26),
127: G_PKG_NAME,
128: --bug# 2518454

Line 125: x_return_status := OKL_API.HANDLE_EXCEPTIONS

121: G_SCOPE);
122: -- Resetting the global transaction id.
123: okc_cvm_pvt.g_trans_id := 'XXX';
124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
126: (substr(l_api_name,1,26),
127: G_PKG_NAME,
128: --bug# 2518454
129: --'OKC_API.G_RET_STS_ERROR',

Line 130: 'OKL_API.G_RET_STS_ERROR',

126: (substr(l_api_name,1,26),
127: G_PKG_NAME,
128: --bug# 2518454
129: --'OKC_API.G_RET_STS_ERROR',
130: 'OKL_API.G_RET_STS_ERROR',
131: x_msg_count,
132: x_msg_data,
133: G_SCOPE);
134: -- Resetting the global transaction id.

Line 138: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

134: -- Resetting the global transaction id.
135: okc_cvm_pvt.g_trans_id := 'XXX';
136: WHEN OTHERS THEN
137: -- store SQL error message on message stack for caller
138: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
139: x_return_status := OKL_API.HANDLE_EXCEPTIONS
140: (substr(l_api_name,1,26),
141: G_PKG_NAME,
142: 'OTHERS',

Line 139: x_return_status := OKL_API.HANDLE_EXCEPTIONS

135: okc_cvm_pvt.g_trans_id := 'XXX';
136: WHEN OTHERS THEN
137: -- store SQL error message on message stack for caller
138: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
139: x_return_status := OKL_API.HANDLE_EXCEPTIONS
140: (substr(l_api_name,1,26),
141: G_PKG_NAME,
142: 'OTHERS',
143: x_msg_count,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

149: END copy_components;
150:
151: PROCEDURE copy_contract(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_commit IN VARCHAR2 DEFAULT 'F',

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

163: p_override_org IN VARCHAR2 DEFAULT 'N',
164: x_chr_id OUT NOCOPY NUMBER) IS
165:
166: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT';
167: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
168: BEGIN
169: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
170: G_PKG_NAME,
171: p_init_msg_list,

Line 169: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

165:
166: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT';
167: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
168: BEGIN
169: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
170: G_PKG_NAME,
171: p_init_msg_list,
172: G_API_VERSION,
173: p_api_version,

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

173: p_api_version,
174: G_SCOPE,
175: x_return_status);
176: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;

Line 178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

174: G_SCOPE,
175: x_return_status);
176: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;
182:

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

175: x_return_status);
176: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;
182:
183: --Customer pre-processing Section

Line 180: RAISE OKL_API.G_EXCEPTION_ERROR;

176: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;
182:
183: --Customer pre-processing Section
184:

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

198: p_renew_ref_yn => p_renew_ref_yn,
199: p_copy_lines_yn => 'Y',
200: x_chr_id => x_chr_id);
201:
202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_ERROR;
206: END IF;

Line 203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

199: p_copy_lines_yn => 'Y',
200: x_chr_id => x_chr_id);
201:
202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_ERROR;
206: END IF;
207:

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

200: x_chr_id => x_chr_id);
201:
202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_ERROR;
206: END IF;
207:
208:

Line 205: RAISE OKL_API.G_EXCEPTION_ERROR;

201:
202: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
204: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_ERROR;
206: END IF;
207:
208:
209:

Line 210: IF p_commit = OKL_API.G_TRUE THEN

206: END IF;
207:
208:
209:
210: IF p_commit = OKL_API.G_TRUE THEN
211: commit;
212: END IF;
213:
214: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

210: IF p_commit = OKL_API.G_TRUE THEN
211: commit;
212: END IF;
213:
214: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
215:
216: EXCEPTION
217: WHEN OKL_API.G_EXCEPTION_ERROR THEN
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 217: WHEN OKL_API.G_EXCEPTION_ERROR THEN

213:
214: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
215:
216: EXCEPTION
217: WHEN OKL_API.G_EXCEPTION_ERROR THEN
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: --bug# 2518454

Line 218: x_return_status := OKL_API.HANDLE_EXCEPTIONS

214: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
215:
216: EXCEPTION
217: WHEN OKL_API.G_EXCEPTION_ERROR THEN
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: --bug# 2518454
222: --'OKC_API.G_RET_STS_ERROR',

Line 223: 'OKL_API.G_RET_STS_ERROR',

219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: --bug# 2518454
222: --'OKC_API.G_RET_STS_ERROR',
223: 'OKL_API.G_RET_STS_ERROR',
224: x_msg_count,
225: x_msg_data,
226: G_SCOPE);
227: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 227: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

223: 'OKL_API.G_RET_STS_ERROR',
224: x_msg_count,
225: x_msg_data,
226: G_SCOPE);
227: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
229: (substr(l_api_name,1,26),
230: G_PKG_NAME,
231: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 228: x_return_status := OKL_API.HANDLE_EXCEPTIONS

224: x_msg_count,
225: x_msg_data,
226: G_SCOPE);
227: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
229: (substr(l_api_name,1,26),
230: G_PKG_NAME,
231: 'OKL_API.G_RET_STS_UNEXP_ERROR',
232: x_msg_count,

Line 231: 'OKL_API.G_RET_STS_UNEXP_ERROR',

227: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
229: (substr(l_api_name,1,26),
230: G_PKG_NAME,
231: 'OKL_API.G_RET_STS_UNEXP_ERROR',
232: x_msg_count,
233: x_msg_data,
234: G_SCOPE);
235: WHEN OTHERS THEN

Line 237: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

233: x_msg_data,
234: G_SCOPE);
235: WHEN OTHERS THEN
236: -- store SQL error message on message stack for caller
237: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
238: x_return_status := OKL_API.HANDLE_EXCEPTIONS
239: (substr(l_api_name,1,26),
240: G_PKG_NAME,
241: 'OTHERS',

Line 238: x_return_status := OKL_API.HANDLE_EXCEPTIONS

234: G_SCOPE);
235: WHEN OTHERS THEN
236: -- store SQL error message on message stack for caller
237: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
238: x_return_status := OKL_API.HANDLE_EXCEPTIONS
239: (substr(l_api_name,1,26),
240: G_PKG_NAME,
241: 'OTHERS',
242: x_msg_count,

Line 252: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

248:
249:
250: PROCEDURE copy_lease_contract(
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256: p_commit IN VARCHAR2 DEFAULT 'F',

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

263: p_trans_type IN VARCHAR2,
264: x_chr_id OUT NOCOPY NUMBER) IS
265:
266: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
267: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
268: BEGIN
269: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
270: G_PKG_NAME,
271: p_init_msg_list,

Line 269: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

265:
266: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
267: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
268: BEGIN
269: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
270: G_PKG_NAME,
271: p_init_msg_list,
272: G_API_VERSION,
273: p_api_version,

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

273: p_api_version,
274: G_SCOPE,
275: x_return_status);
276: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
277: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
280: RAISE OKL_API.G_EXCEPTION_ERROR;
281: END IF;

Line 278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

274: G_SCOPE,
275: x_return_status);
276: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
277: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
280: RAISE OKL_API.G_EXCEPTION_ERROR;
281: END IF;
282:

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

275: x_return_status);
276: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
277: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
280: RAISE OKL_API.G_EXCEPTION_ERROR;
281: END IF;
282:
283: --Customer pre-processing Section

Line 280: RAISE OKL_API.G_EXCEPTION_ERROR;

276: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
277: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
278: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
280: RAISE OKL_API.G_EXCEPTION_ERROR;
281: END IF;
282:
283: --Customer pre-processing Section
284:

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

299: p_copy_lines_yn => 'Y',
300: p_override_org => p_override_org,
301: p_trans_type => p_trans_type,
302: x_chr_id => x_chr_id);
303: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
306: RAISE OKL_API.G_EXCEPTION_ERROR;
307: END IF;

Line 304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

300: p_override_org => p_override_org,
301: p_trans_type => p_trans_type,
302: x_chr_id => x_chr_id);
303: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
306: RAISE OKL_API.G_EXCEPTION_ERROR;
307: END IF;
308:

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

301: p_trans_type => p_trans_type,
302: x_chr_id => x_chr_id);
303: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
306: RAISE OKL_API.G_EXCEPTION_ERROR;
307: END IF;
308:
309:

Line 306: RAISE OKL_API.G_EXCEPTION_ERROR;

302: x_chr_id => x_chr_id);
303: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
306: RAISE OKL_API.G_EXCEPTION_ERROR;
307: END IF;
308:
309:
310:

Line 311: IF p_commit = OKL_API.G_TRUE THEN

307: END IF;
308:
309:
310:
311: IF p_commit = OKL_API.G_TRUE THEN
312: commit;
313: END IF;
314:
315: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

311: IF p_commit = OKL_API.G_TRUE THEN
312: commit;
313: END IF;
314:
315: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
316:
317: EXCEPTION
318: WHEN OKL_API.G_EXCEPTION_ERROR THEN
319: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 318: WHEN OKL_API.G_EXCEPTION_ERROR THEN

314:
315: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
316:
317: EXCEPTION
318: WHEN OKL_API.G_EXCEPTION_ERROR THEN
319: x_return_status := OKL_API.HANDLE_EXCEPTIONS
320: (substr(l_api_name,1,26),
321: G_PKG_NAME,
322: --bug# 2518454

Line 319: x_return_status := OKL_API.HANDLE_EXCEPTIONS

315: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
316:
317: EXCEPTION
318: WHEN OKL_API.G_EXCEPTION_ERROR THEN
319: x_return_status := OKL_API.HANDLE_EXCEPTIONS
320: (substr(l_api_name,1,26),
321: G_PKG_NAME,
322: --bug# 2518454
323: --'OKC_API.G_RET_STS_ERROR',

Line 324: 'OKL_API.G_RET_STS_ERROR',

320: (substr(l_api_name,1,26),
321: G_PKG_NAME,
322: --bug# 2518454
323: --'OKC_API.G_RET_STS_ERROR',
324: 'OKL_API.G_RET_STS_ERROR',
325: x_msg_count,
326: x_msg_data,
327: G_SCOPE);
328: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 328: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

324: 'OKL_API.G_RET_STS_ERROR',
325: x_msg_count,
326: x_msg_data,
327: G_SCOPE);
328: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
329: x_return_status := OKL_API.HANDLE_EXCEPTIONS
330: (substr(l_api_name,1,26),
331: G_PKG_NAME,
332: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 329: x_return_status := OKL_API.HANDLE_EXCEPTIONS

325: x_msg_count,
326: x_msg_data,
327: G_SCOPE);
328: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
329: x_return_status := OKL_API.HANDLE_EXCEPTIONS
330: (substr(l_api_name,1,26),
331: G_PKG_NAME,
332: 'OKL_API.G_RET_STS_UNEXP_ERROR',
333: x_msg_count,

Line 332: 'OKL_API.G_RET_STS_UNEXP_ERROR',

328: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
329: x_return_status := OKL_API.HANDLE_EXCEPTIONS
330: (substr(l_api_name,1,26),
331: G_PKG_NAME,
332: 'OKL_API.G_RET_STS_UNEXP_ERROR',
333: x_msg_count,
334: x_msg_data,
335: G_SCOPE);
336: WHEN OTHERS THEN

Line 338: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

334: x_msg_data,
335: G_SCOPE);
336: WHEN OTHERS THEN
337: -- store SQL error message on message stack for caller
338: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
339: x_return_status := OKL_API.HANDLE_EXCEPTIONS
340: (substr(l_api_name,1,26),
341: G_PKG_NAME,
342: 'OTHERS',

Line 339: x_return_status := OKL_API.HANDLE_EXCEPTIONS

335: G_SCOPE);
336: WHEN OTHERS THEN
337: -- store SQL error message on message stack for caller
338: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
339: x_return_status := OKL_API.HANDLE_EXCEPTIONS
340: (substr(l_api_name,1,26),
341: G_PKG_NAME,
342: 'OTHERS',
343: x_msg_count,

Line 351: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

347: END copy_lease_contract;
348:
349: PROCEDURE copy_lease_contract(
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2,
355: p_commit IN VARCHAR2 DEFAULT 'F',

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

363: p_trans_type IN VARCHAR2,
364: x_chr_id OUT NOCOPY NUMBER) IS
365:
366: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
367: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
368: BEGIN
369: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
370: G_PKG_NAME,
371: p_init_msg_list,

Line 369: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

365:
366: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
367: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
368: BEGIN
369: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
370: G_PKG_NAME,
371: p_init_msg_list,
372: G_API_VERSION,
373: p_api_version,

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

373: p_api_version,
374: G_SCOPE,
375: x_return_status);
376: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
377: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
380: RAISE OKL_API.G_EXCEPTION_ERROR;
381: END IF;

Line 378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

374: G_SCOPE,
375: x_return_status);
376: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
377: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
380: RAISE OKL_API.G_EXCEPTION_ERROR;
381: END IF;
382:

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

375: x_return_status);
376: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
377: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
380: RAISE OKL_API.G_EXCEPTION_ERROR;
381: END IF;
382:
383: --Customer pre-processing Section

Line 380: RAISE OKL_API.G_EXCEPTION_ERROR;

376: --dbms_output.put_line('In Public :'||l_api_name||G_SCOPE);
377: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
379: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
380: RAISE OKL_API.G_EXCEPTION_ERROR;
381: END IF;
382:
383: --Customer pre-processing Section
384:

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

399: p_copy_lines_yn => p_copy_lines_yn,
400: p_override_org => p_override_org,
401: p_trans_type => p_trans_type,
402: x_chr_id => x_chr_id);
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;

Line 404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

400: p_override_org => p_override_org,
401: p_trans_type => p_trans_type,
402: x_chr_id => x_chr_id);
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:

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

401: p_trans_type => p_trans_type,
402: x_chr_id => x_chr_id);
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409:

Line 406: RAISE OKL_API.G_EXCEPTION_ERROR;

402: x_chr_id => x_chr_id);
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409:
410:

Line 411: IF p_commit = OKL_API.G_TRUE THEN

407: END IF;
408:
409:
410:
411: IF p_commit = OKL_API.G_TRUE THEN
412: commit;
413: END IF;
414:
415: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

411: IF p_commit = OKL_API.G_TRUE THEN
412: commit;
413: END IF;
414:
415: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
416:
417: EXCEPTION
418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 418: WHEN OKL_API.G_EXCEPTION_ERROR THEN

414:
415: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
416:
417: EXCEPTION
418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.HANDLE_EXCEPTIONS
420: (substr(l_api_name,1,26),
421: G_PKG_NAME,
422: --bug# 2518454

Line 419: x_return_status := OKL_API.HANDLE_EXCEPTIONS

415: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
416:
417: EXCEPTION
418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.HANDLE_EXCEPTIONS
420: (substr(l_api_name,1,26),
421: G_PKG_NAME,
422: --bug# 2518454
423: --'OKC_API.G_RET_STS_ERROR',

Line 424: 'OKL_API.G_RET_STS_ERROR',

420: (substr(l_api_name,1,26),
421: G_PKG_NAME,
422: --bug# 2518454
423: --'OKC_API.G_RET_STS_ERROR',
424: 'OKL_API.G_RET_STS_ERROR',
425: x_msg_count,
426: x_msg_data,
427: G_SCOPE);
428: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 428: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

424: 'OKL_API.G_RET_STS_ERROR',
425: x_msg_count,
426: x_msg_data,
427: G_SCOPE);
428: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
429: x_return_status := OKL_API.HANDLE_EXCEPTIONS
430: (substr(l_api_name,1,26),
431: G_PKG_NAME,
432: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 429: x_return_status := OKL_API.HANDLE_EXCEPTIONS

425: x_msg_count,
426: x_msg_data,
427: G_SCOPE);
428: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
429: x_return_status := OKL_API.HANDLE_EXCEPTIONS
430: (substr(l_api_name,1,26),
431: G_PKG_NAME,
432: 'OKL_API.G_RET_STS_UNEXP_ERROR',
433: x_msg_count,

Line 432: 'OKL_API.G_RET_STS_UNEXP_ERROR',

428: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
429: x_return_status := OKL_API.HANDLE_EXCEPTIONS
430: (substr(l_api_name,1,26),
431: G_PKG_NAME,
432: 'OKL_API.G_RET_STS_UNEXP_ERROR',
433: x_msg_count,
434: x_msg_data,
435: G_SCOPE);
436: WHEN OTHERS THEN

Line 438: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

434: x_msg_data,
435: G_SCOPE);
436: WHEN OTHERS THEN
437: -- store SQL error message on message stack for caller
438: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
439: x_return_status := OKL_API.HANDLE_EXCEPTIONS
440: (substr(l_api_name,1,26),
441: G_PKG_NAME,
442: 'OTHERS',

Line 439: x_return_status := OKL_API.HANDLE_EXCEPTIONS

435: G_SCOPE);
436: WHEN OTHERS THEN
437: -- store SQL error message on message stack for caller
438: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
439: x_return_status := OKL_API.HANDLE_EXCEPTIONS
440: (substr(l_api_name,1,26),
441: G_PKG_NAME,
442: 'OTHERS',
443: x_msg_count,

Line 452: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

448:
449:
450: PROCEDURE copy_lease_contract_new(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_commit IN VARCHAR2 DEFAULT 'F',

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

464: x_chr_id OUT NOCOPY NUMBER,
465: p_rbk_date IN DATE DEFAULT NULL) IS
466:
467: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
468: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
469: BEGIN
470: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
471: G_PKG_NAME,
472: p_init_msg_list,

Line 470: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

466:
467: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
468: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
469: BEGIN
470: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
471: G_PKG_NAME,
472: p_init_msg_list,
473: G_API_VERSION,
474: p_api_version,

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

473: G_API_VERSION,
474: p_api_version,
475: G_SCOPE,
476: x_return_status);
477: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;

Line 478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

474: p_api_version,
475: G_SCOPE,
476: x_return_status);
477: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;
482:

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

475: G_SCOPE,
476: x_return_status);
477: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;
482:
483: --Customer pre-processing Section

Line 480: RAISE OKL_API.G_EXCEPTION_ERROR;

476: x_return_status);
477: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;
482:
483: --Customer pre-processing Section
484:

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

500: p_override_org => p_override_org,
501: p_trans_type => p_trans_type,
502: x_chr_id => x_chr_id,
503: p_rbk_date => p_rbk_date);
504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;

Line 505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

501: p_trans_type => p_trans_type,
502: x_chr_id => x_chr_id,
503: p_rbk_date => p_rbk_date);
504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509:

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

502: x_chr_id => x_chr_id,
503: p_rbk_date => p_rbk_date);
504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509:
510:

Line 507: RAISE OKL_API.G_EXCEPTION_ERROR;

503: p_rbk_date => p_rbk_date);
504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509:
510:
511:

Line 512: IF p_commit = OKL_API.G_TRUE THEN

508: END IF;
509:
510:
511:
512: IF p_commit = OKL_API.G_TRUE THEN
513: commit;
514: END IF;
515:
516: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

512: IF p_commit = OKL_API.G_TRUE THEN
513: commit;
514: END IF;
515:
516: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
517:
518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 519: WHEN OKL_API.G_EXCEPTION_ERROR THEN

515:
516: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
517:
518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS
521: (substr(l_api_name,1,26),
522: G_PKG_NAME,
523: --bug# 2518454

Line 520: x_return_status := OKL_API.HANDLE_EXCEPTIONS

516: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
517:
518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS
521: (substr(l_api_name,1,26),
522: G_PKG_NAME,
523: --bug# 2518454
524: --'OKC_API.G_RET_STS_ERROR',

Line 525: 'OKL_API.G_RET_STS_ERROR',

521: (substr(l_api_name,1,26),
522: G_PKG_NAME,
523: --bug# 2518454
524: --'OKC_API.G_RET_STS_ERROR',
525: 'OKL_API.G_RET_STS_ERROR',
526: x_msg_count,
527: x_msg_data,
528: G_SCOPE);
529: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 529: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

525: 'OKL_API.G_RET_STS_ERROR',
526: x_msg_count,
527: x_msg_data,
528: G_SCOPE);
529: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
530: x_return_status := OKL_API.HANDLE_EXCEPTIONS
531: (substr(l_api_name,1,26),
532: G_PKG_NAME,
533: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 530: x_return_status := OKL_API.HANDLE_EXCEPTIONS

526: x_msg_count,
527: x_msg_data,
528: G_SCOPE);
529: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
530: x_return_status := OKL_API.HANDLE_EXCEPTIONS
531: (substr(l_api_name,1,26),
532: G_PKG_NAME,
533: 'OKL_API.G_RET_STS_UNEXP_ERROR',
534: x_msg_count,

Line 533: 'OKL_API.G_RET_STS_UNEXP_ERROR',

529: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
530: x_return_status := OKL_API.HANDLE_EXCEPTIONS
531: (substr(l_api_name,1,26),
532: G_PKG_NAME,
533: 'OKL_API.G_RET_STS_UNEXP_ERROR',
534: x_msg_count,
535: x_msg_data,
536: G_SCOPE);
537: WHEN OTHERS THEN

Line 539: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

535: x_msg_data,
536: G_SCOPE);
537: WHEN OTHERS THEN
538: -- store SQL error message on message stack for caller
539: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
540: x_return_status := OKL_API.HANDLE_EXCEPTIONS
541: (substr(l_api_name,1,26),
542: G_PKG_NAME,
543: 'OTHERS',

Line 540: x_return_status := OKL_API.HANDLE_EXCEPTIONS

536: G_SCOPE);
537: WHEN OTHERS THEN
538: -- store SQL error message on message stack for caller
539: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
540: x_return_status := OKL_API.HANDLE_EXCEPTIONS
541: (substr(l_api_name,1,26),
542: G_PKG_NAME,
543: 'OTHERS',
544: x_msg_count,

Line 552: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

548: END copy_lease_contract_new;
549:
550: PROCEDURE copy_lease_contract_new(
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: p_commit IN VARCHAR2 DEFAULT 'F',

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

564: p_trans_type IN VARCHAR2,
565: x_chr_id OUT NOCOPY NUMBER) IS
566:
567: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
568: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
569: BEGIN
570: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
571: G_PKG_NAME,
572: p_init_msg_list,

Line 570: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

566:
567: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LEASE_CONTRACT';
568: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
569: BEGIN
570: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
571: G_PKG_NAME,
572: p_init_msg_list,
573: G_API_VERSION,
574: p_api_version,

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

573: G_API_VERSION,
574: p_api_version,
575: G_SCOPE,
576: x_return_status);
577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
580: RAISE OKL_API.G_EXCEPTION_ERROR;
581: END IF;

Line 578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

574: p_api_version,
575: G_SCOPE,
576: x_return_status);
577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
580: RAISE OKL_API.G_EXCEPTION_ERROR;
581: END IF;
582:

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

575: G_SCOPE,
576: x_return_status);
577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
580: RAISE OKL_API.G_EXCEPTION_ERROR;
581: END IF;
582:
583: --Customer pre-processing Section

Line 580: RAISE OKL_API.G_EXCEPTION_ERROR;

576: x_return_status);
577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
580: RAISE OKL_API.G_EXCEPTION_ERROR;
581: END IF;
582:
583: --Customer pre-processing Section
584:

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

599: p_copy_lines_yn => p_copy_lines_yn,
600: p_override_org => p_override_org,
601: p_trans_type => p_trans_type,
602: x_chr_id => x_chr_id);
603: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;

Line 604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

600: p_override_org => p_override_org,
601: p_trans_type => p_trans_type,
602: x_chr_id => x_chr_id);
603: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608:

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

601: p_trans_type => p_trans_type,
602: x_chr_id => x_chr_id);
603: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608:
609:

Line 606: RAISE OKL_API.G_EXCEPTION_ERROR;

602: x_chr_id => x_chr_id);
603: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608:
609:
610:

Line 611: IF p_commit = OKL_API.G_TRUE THEN

607: END IF;
608:
609:
610:
611: IF p_commit = OKL_API.G_TRUE THEN
612: commit;
613: END IF;
614:
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

611: IF p_commit = OKL_API.G_TRUE THEN
612: commit;
613: END IF;
614:
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616:
617: EXCEPTION
618: WHEN OKL_API.G_EXCEPTION_ERROR THEN
619: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 618: WHEN OKL_API.G_EXCEPTION_ERROR THEN

614:
615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616:
617: EXCEPTION
618: WHEN OKL_API.G_EXCEPTION_ERROR THEN
619: x_return_status := OKL_API.HANDLE_EXCEPTIONS
620: (substr(l_api_name,1,26),
621: G_PKG_NAME,
622: --bug# 2518454

Line 619: x_return_status := OKL_API.HANDLE_EXCEPTIONS

615: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
616:
617: EXCEPTION
618: WHEN OKL_API.G_EXCEPTION_ERROR THEN
619: x_return_status := OKL_API.HANDLE_EXCEPTIONS
620: (substr(l_api_name,1,26),
621: G_PKG_NAME,
622: --bug# 2518454
623: --'OKC_API.G_RET_STS_ERROR',

Line 624: 'OKL_API.G_RET_STS_ERROR',

620: (substr(l_api_name,1,26),
621: G_PKG_NAME,
622: --bug# 2518454
623: --'OKC_API.G_RET_STS_ERROR',
624: 'OKL_API.G_RET_STS_ERROR',
625: x_msg_count,
626: x_msg_data,
627: G_SCOPE);
628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

624: 'OKL_API.G_RET_STS_ERROR',
625: x_msg_count,
626: x_msg_data,
627: G_SCOPE);
628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
630: (substr(l_api_name,1,26),
631: G_PKG_NAME,
632: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 629: x_return_status := OKL_API.HANDLE_EXCEPTIONS

625: x_msg_count,
626: x_msg_data,
627: G_SCOPE);
628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
630: (substr(l_api_name,1,26),
631: G_PKG_NAME,
632: 'OKL_API.G_RET_STS_UNEXP_ERROR',
633: x_msg_count,

Line 632: 'OKL_API.G_RET_STS_UNEXP_ERROR',

628: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
630: (substr(l_api_name,1,26),
631: G_PKG_NAME,
632: 'OKL_API.G_RET_STS_UNEXP_ERROR',
633: x_msg_count,
634: x_msg_data,
635: G_SCOPE);
636: WHEN OTHERS THEN

Line 638: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

634: x_msg_data,
635: G_SCOPE);
636: WHEN OTHERS THEN
637: -- store SQL error message on message stack for caller
638: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS
640: (substr(l_api_name,1,26),
641: G_PKG_NAME,
642: 'OTHERS',

Line 639: x_return_status := OKL_API.HANDLE_EXCEPTIONS

635: G_SCOPE);
636: WHEN OTHERS THEN
637: -- store SQL error message on message stack for caller
638: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS
640: (substr(l_api_name,1,26),
641: G_PKG_NAME,
642: 'OTHERS',
643: x_msg_count,

Line 651: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

647: END copy_lease_contract_new;
648:
649: PROCEDURE copy_contract(
650: p_api_version IN NUMBER,
651: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
652: x_return_status OUT NOCOPY VARCHAR2,
653: x_msg_count OUT NOCOPY NUMBER,
654: x_msg_data OUT NOCOPY VARCHAR2,
655: p_commit IN VARCHAR2 DEFAULT 'F',

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

662: p_override_org IN VARCHAR2 DEFAULT 'N',
663: x_chr_id OUT NOCOPY NUMBER) IS
664:
665: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT';
666: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
667: BEGIN
668: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
669: G_PKG_NAME,
670: p_init_msg_list,

Line 668: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

664:
665: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT';
666: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
667: BEGIN
668: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
669: G_PKG_NAME,
670: p_init_msg_list,
671: G_API_VERSION,
672: p_api_version,

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

671: G_API_VERSION,
672: p_api_version,
673: G_SCOPE,
674: x_return_status);
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;

Line 676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

672: p_api_version,
673: G_SCOPE,
674: x_return_status);
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:

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

673: G_SCOPE,
674: x_return_status);
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:
681: --Customer pre-processing Section

Line 678: RAISE OKL_API.G_EXCEPTION_ERROR;

674: x_return_status);
675: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:
681: --Customer pre-processing Section
682: --Vertical pre_processing section

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

696: p_renew_ref_yn => p_renew_ref_yn,
697: p_copy_lines_yn => p_copy_lines_yn,
698: x_chr_id => x_chr_id);
699:
700: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
702: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;

Line 701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

697: p_copy_lines_yn => p_copy_lines_yn,
698: x_chr_id => x_chr_id);
699:
700: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
702: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;
705:

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

698: x_chr_id => x_chr_id);
699:
700: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
702: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;
705:
706: --Vertical post_processing section

Line 703: RAISE OKL_API.G_EXCEPTION_ERROR;

699:
700: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
702: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;
705:
706: --Vertical post_processing section
707:

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

710: IF p_commit = 'T' THEN
711: commit;
712: END IF;
713:
714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
715:
716: EXCEPTION
717: WHEN OKL_API.G_EXCEPTION_ERROR THEN
718: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 717: WHEN OKL_API.G_EXCEPTION_ERROR THEN

713:
714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
715:
716: EXCEPTION
717: WHEN OKL_API.G_EXCEPTION_ERROR THEN
718: x_return_status := OKL_API.HANDLE_EXCEPTIONS
719: (substr(l_api_name,1,26),
720: G_PKG_NAME,
721: --bug# 2518454

Line 718: x_return_status := OKL_API.HANDLE_EXCEPTIONS

714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
715:
716: EXCEPTION
717: WHEN OKL_API.G_EXCEPTION_ERROR THEN
718: x_return_status := OKL_API.HANDLE_EXCEPTIONS
719: (substr(l_api_name,1,26),
720: G_PKG_NAME,
721: --bug# 2518454
722: --'OKC_API.G_RET_STS_ERROR',

Line 723: 'OKL_API.G_RET_STS_ERROR',

719: (substr(l_api_name,1,26),
720: G_PKG_NAME,
721: --bug# 2518454
722: --'OKC_API.G_RET_STS_ERROR',
723: 'OKL_API.G_RET_STS_ERROR',
724: x_msg_count,
725: x_msg_data,
726: G_SCOPE);
727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

723: 'OKL_API.G_RET_STS_ERROR',
724: x_msg_count,
725: x_msg_data,
726: G_SCOPE);
727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS
729: (substr(l_api_name,1,26),
730: G_PKG_NAME,
731: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 728: x_return_status := OKL_API.HANDLE_EXCEPTIONS

724: x_msg_count,
725: x_msg_data,
726: G_SCOPE);
727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS
729: (substr(l_api_name,1,26),
730: G_PKG_NAME,
731: 'OKL_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count,

Line 731: 'OKL_API.G_RET_STS_UNEXP_ERROR',

727: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKL_API.HANDLE_EXCEPTIONS
729: (substr(l_api_name,1,26),
730: G_PKG_NAME,
731: 'OKL_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count,
733: x_msg_data,
734: G_SCOPE);
735: WHEN OTHERS THEN

Line 737: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

733: x_msg_data,
734: G_SCOPE);
735: WHEN OTHERS THEN
736: -- store SQL error message on message stack for caller
737: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
738: x_return_status := OKL_API.HANDLE_EXCEPTIONS
739: (substr(l_api_name,1,26),
740: G_PKG_NAME,
741: 'OTHERS',

Line 738: x_return_status := OKL_API.HANDLE_EXCEPTIONS

734: G_SCOPE);
735: WHEN OTHERS THEN
736: -- store SQL error message on message stack for caller
737: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
738: x_return_status := OKL_API.HANDLE_EXCEPTIONS
739: (substr(l_api_name,1,26),
740: G_PKG_NAME,
741: 'OTHERS',
742: x_msg_count,

Line 750: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

746: END copy_contract;
747:
748: PROCEDURE copy_contract_lines(
749: p_api_version IN NUMBER,
750: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
751: x_return_status OUT NOCOPY VARCHAR2,
752: x_msg_count OUT NOCOPY NUMBER,
753: x_msg_data OUT NOCOPY VARCHAR2,
754: p_from_cle_id IN NUMBER,

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

760: p_renew_ref_yn IN VARCHAR2,
761: x_cle_id OUT NOCOPY NUMBER) is
762:
763: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT_LINES';
764: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
765: BEGIN
766: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
767: G_PKG_NAME,
768: p_init_msg_list,

Line 766: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

762:
763: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_CONTRACT_LINES';
764: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
765: BEGIN
766: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
767: G_PKG_NAME,
768: p_init_msg_list,
769: G_API_VERSION,
770: p_api_version,

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

769: G_API_VERSION,
770: p_api_version,
771: G_SCOPE,
772: x_return_status);
773: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;

Line 774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

770: p_api_version,
771: G_SCOPE,
772: x_return_status);
773: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778:

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

771: G_SCOPE,
772: x_return_status);
773: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778:
779: --Custom pre_processing section

Line 776: RAISE OKL_API.G_EXCEPTION_ERROR;

772: x_return_status);
773: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778:
779: --Custom pre_processing section
780:

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

794: p_copy_line_party_yn => p_copy_line_party_yn,
795: p_renew_ref_yn => p_renew_ref_yn,
796: x_cle_id => x_cle_id);
797:
798: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;

Line 799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

795: p_renew_ref_yn => p_renew_ref_yn,
796: x_cle_id => x_cle_id);
797:
798: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: --Vertical Industry post_processing section

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

796: x_cle_id => x_cle_id);
797:
798: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: --Vertical Industry post_processing section
804: --Custom post_processing section

Line 801: RAISE OKL_API.G_EXCEPTION_ERROR;

797:
798: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: --Vertical Industry post_processing section
804: --Custom post_processing section
805:

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

802: END IF;
803: --Vertical Industry post_processing section
804: --Custom post_processing section
805:
806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
807:
808: EXCEPTION
809: WHEN OKL_API.G_EXCEPTION_ERROR THEN
810: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 809: WHEN OKL_API.G_EXCEPTION_ERROR THEN

805:
806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
807:
808: EXCEPTION
809: WHEN OKL_API.G_EXCEPTION_ERROR THEN
810: x_return_status := OKL_API.HANDLE_EXCEPTIONS
811: (substr(l_api_name,1,26),
812: G_PKG_NAME,
813: 'OKL_API.G_RET_STS_ERROR',

Line 810: x_return_status := OKL_API.HANDLE_EXCEPTIONS

806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
807:
808: EXCEPTION
809: WHEN OKL_API.G_EXCEPTION_ERROR THEN
810: x_return_status := OKL_API.HANDLE_EXCEPTIONS
811: (substr(l_api_name,1,26),
812: G_PKG_NAME,
813: 'OKL_API.G_RET_STS_ERROR',
814: x_msg_count,

Line 813: 'OKL_API.G_RET_STS_ERROR',

809: WHEN OKL_API.G_EXCEPTION_ERROR THEN
810: x_return_status := OKL_API.HANDLE_EXCEPTIONS
811: (substr(l_api_name,1,26),
812: G_PKG_NAME,
813: 'OKL_API.G_RET_STS_ERROR',
814: x_msg_count,
815: x_msg_data,
816: G_SCOPE);
817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

813: 'OKL_API.G_RET_STS_ERROR',
814: x_msg_count,
815: x_msg_data,
816: G_SCOPE);
817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
818: x_return_status := OKL_API.HANDLE_EXCEPTIONS
819: (substr(l_api_name,1,26),
820: G_PKG_NAME,
821: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 818: x_return_status := OKL_API.HANDLE_EXCEPTIONS

814: x_msg_count,
815: x_msg_data,
816: G_SCOPE);
817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
818: x_return_status := OKL_API.HANDLE_EXCEPTIONS
819: (substr(l_api_name,1,26),
820: G_PKG_NAME,
821: 'OKL_API.G_RET_STS_UNEXP_ERROR',
822: x_msg_count,

Line 821: 'OKL_API.G_RET_STS_UNEXP_ERROR',

817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
818: x_return_status := OKL_API.HANDLE_EXCEPTIONS
819: (substr(l_api_name,1,26),
820: G_PKG_NAME,
821: 'OKL_API.G_RET_STS_UNEXP_ERROR',
822: x_msg_count,
823: x_msg_data,
824: G_SCOPE);
825: WHEN OTHERS THEN

Line 827: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

823: x_msg_data,
824: G_SCOPE);
825: WHEN OTHERS THEN
826: -- store SQL error message on message stack for caller
827: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
828: x_return_status := OKL_API.HANDLE_EXCEPTIONS
829: (substr(l_api_name,1,26),
830: G_PKG_NAME,
831: 'OTHERS',

Line 828: x_return_status := OKL_API.HANDLE_EXCEPTIONS

824: G_SCOPE);
825: WHEN OTHERS THEN
826: -- store SQL error message on message stack for caller
827: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
828: x_return_status := OKL_API.HANDLE_EXCEPTIONS
829: (substr(l_api_name,1,26),
830: G_PKG_NAME,
831: 'OTHERS',
832: x_msg_count,

Line 839: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

835: END copy_contract_lines;
836:
837: PROCEDURE copy_rules(
838: p_api_version IN NUMBER,
839: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,
843: p_rgp_id IN NUMBER,

Line 844: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,
843: p_rgp_id IN NUMBER,
844: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
845: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
846: p_to_template_yn IN VARCHAR2,
847: x_rgp_id OUT NOCOPY NUMBER) IS
848:

Line 845: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,
843: p_rgp_id IN NUMBER,
844: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
845: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
846: p_to_template_yn IN VARCHAR2,
847: x_rgp_id OUT NOCOPY NUMBER) IS
848:
849: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_RULES';

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

846: p_to_template_yn IN VARCHAR2,
847: x_rgp_id OUT NOCOPY NUMBER) IS
848:
849: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_RULES';
850: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
851: BEGIN
852: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
853: G_PKG_NAME,
854: p_init_msg_list,

Line 852: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

848:
849: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_RULES';
850: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
851: BEGIN
852: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
853: G_PKG_NAME,
854: p_init_msg_list,
855: G_API_VERSION,
856: p_api_version,

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

855: G_API_VERSION,
856: p_api_version,
857: G_SCOPE,
858: x_return_status);
859: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
862: RAISE OKL_API.G_EXCEPTION_ERROR;
863: END IF;

Line 860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

856: p_api_version,
857: G_SCOPE,
858: x_return_status);
859: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
862: RAISE OKL_API.G_EXCEPTION_ERROR;
863: END IF;
864:

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

857: G_SCOPE,
858: x_return_status);
859: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
862: RAISE OKL_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: --Custom pre_processing section

Line 862: RAISE OKL_API.G_EXCEPTION_ERROR;

858: x_return_status);
859: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
862: RAISE OKL_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: --Custom pre_processing section
866:

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

877: p_chr_id => p_chr_id,
878: p_to_template_yn => p_to_template_yn,
879: x_rgp_id => x_rgp_id);
880:
881: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;

Line 882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

878: p_to_template_yn => p_to_template_yn,
879: x_rgp_id => x_rgp_id);
880:
881: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;
886:

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

879: x_rgp_id => x_rgp_id);
880:
881: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;
886:
887: --Vertical Industry post_processing section

Line 884: RAISE OKL_API.G_EXCEPTION_ERROR;

880:
881: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;
886:
887: --Vertical Industry post_processing section
888:

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

887: --Vertical Industry post_processing section
888:
889: --Custom post_processing section
890:
891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
892:
893: EXCEPTION
894: WHEN OKL_API.G_EXCEPTION_ERROR THEN
895: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 894: WHEN OKL_API.G_EXCEPTION_ERROR THEN

890:
891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
892:
893: EXCEPTION
894: WHEN OKL_API.G_EXCEPTION_ERROR THEN
895: x_return_status := OKL_API.HANDLE_EXCEPTIONS
896: (substr(l_api_name,1,26),
897: G_PKG_NAME,
898: 'OKL_API.G_RET_STS_ERROR',

Line 895: x_return_status := OKL_API.HANDLE_EXCEPTIONS

891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
892:
893: EXCEPTION
894: WHEN OKL_API.G_EXCEPTION_ERROR THEN
895: x_return_status := OKL_API.HANDLE_EXCEPTIONS
896: (substr(l_api_name,1,26),
897: G_PKG_NAME,
898: 'OKL_API.G_RET_STS_ERROR',
899: x_msg_count,

Line 898: 'OKL_API.G_RET_STS_ERROR',

894: WHEN OKL_API.G_EXCEPTION_ERROR THEN
895: x_return_status := OKL_API.HANDLE_EXCEPTIONS
896: (substr(l_api_name,1,26),
897: G_PKG_NAME,
898: 'OKL_API.G_RET_STS_ERROR',
899: x_msg_count,
900: x_msg_data,
901: G_SCOPE);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

898: 'OKL_API.G_RET_STS_ERROR',
899: x_msg_count,
900: x_msg_data,
901: G_SCOPE);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
903: x_return_status := OKL_API.HANDLE_EXCEPTIONS
904: (substr(l_api_name,1,26),
905: G_PKG_NAME,
906: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 903: x_return_status := OKL_API.HANDLE_EXCEPTIONS

899: x_msg_count,
900: x_msg_data,
901: G_SCOPE);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
903: x_return_status := OKL_API.HANDLE_EXCEPTIONS
904: (substr(l_api_name,1,26),
905: G_PKG_NAME,
906: 'OKL_API.G_RET_STS_UNEXP_ERROR',
907: x_msg_count,

Line 906: 'OKL_API.G_RET_STS_UNEXP_ERROR',

902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
903: x_return_status := OKL_API.HANDLE_EXCEPTIONS
904: (substr(l_api_name,1,26),
905: G_PKG_NAME,
906: 'OKL_API.G_RET_STS_UNEXP_ERROR',
907: x_msg_count,
908: x_msg_data,
909: G_SCOPE);
910: WHEN OTHERS THEN

Line 912: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

908: x_msg_data,
909: G_SCOPE);
910: WHEN OTHERS THEN
911: -- store SQL error message on message stack for caller
912: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
913: x_return_status := OKL_API.HANDLE_EXCEPTIONS
914: (substr(l_api_name,1,26),
915: G_PKG_NAME,
916: 'OTHERS',

Line 913: x_return_status := OKL_API.HANDLE_EXCEPTIONS

909: G_SCOPE);
910: WHEN OTHERS THEN
911: -- store SQL error message on message stack for caller
912: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
913: x_return_status := OKL_API.HANDLE_EXCEPTIONS
914: (substr(l_api_name,1,26),
915: G_PKG_NAME,
916: 'OTHERS',
917: x_msg_count,

Line 925: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

921: END copy_rules;
922:
923: PROCEDURE copy_party_roles(
924: p_api_version IN NUMBER,
925: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
926: x_return_status OUT NOCOPY VARCHAR2,
927: x_msg_count OUT NOCOPY NUMBER,
928: x_msg_data OUT NOCOPY VARCHAR2,
929: p_cpl_id IN NUMBER,

Line 930: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

926: x_return_status OUT NOCOPY VARCHAR2,
927: x_msg_count OUT NOCOPY NUMBER,
928: x_msg_data OUT NOCOPY VARCHAR2,
929: p_cpl_id IN NUMBER,
930: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
931: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
932: P_rle_code IN VARCHAR2,
933: x_cpl_id OUT NOCOPY NUMBER) IS
934:

Line 931: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

927: x_msg_count OUT NOCOPY NUMBER,
928: x_msg_data OUT NOCOPY VARCHAR2,
929: p_cpl_id IN NUMBER,
930: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
931: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
932: P_rle_code IN VARCHAR2,
933: x_cpl_id OUT NOCOPY NUMBER) IS
934:
935: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_PARTY_ROLES';

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

932: P_rle_code IN VARCHAR2,
933: x_cpl_id OUT NOCOPY NUMBER) IS
934:
935: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_PARTY_ROLES';
936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
937: BEGIN
938: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
939: G_PKG_NAME,
940: p_init_msg_list,

Line 938: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

934:
935: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_PARTY_ROLES';
936: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
937: BEGIN
938: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
939: G_PKG_NAME,
940: p_init_msg_list,
941: G_API_VERSION,
942: p_api_version,

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

941: G_API_VERSION,
942: p_api_version,
943: G_SCOPE,
944: x_return_status);
945: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_ERROR;
949: END IF;

Line 946: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

942: p_api_version,
943: G_SCOPE,
944: x_return_status);
945: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_ERROR;
949: END IF;
950:

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

943: G_SCOPE,
944: x_return_status);
945: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_ERROR;
949: END IF;
950:
951: --Custom pre processing section

Line 948: RAISE OKL_API.G_EXCEPTION_ERROR;

944: x_return_status);
945: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_ERROR;
949: END IF;
950:
951: --Custom pre processing section
952:

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

964: p_rle_code => p_rle_code,
965: x_cpl_id => x_cpl_id);
966:
967:
968: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_ERROR;
972: END IF;

Line 969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

965: x_cpl_id => x_cpl_id);
966:
967:
968: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_ERROR;
972: END IF;
973:

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

966:
967:
968: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_ERROR;
972: END IF;
973:
974: --Vertical Industry post processing section

Line 971: RAISE OKL_API.G_EXCEPTION_ERROR;

967:
968: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_ERROR;
972: END IF;
973:
974: --Vertical Industry post processing section
975:

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

974: --Vertical Industry post processing section
975:
976: --Custom post processing section
977:
978: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
979:
980: EXCEPTION
981: WHEN OKL_API.G_EXCEPTION_ERROR THEN
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 981: WHEN OKL_API.G_EXCEPTION_ERROR THEN

977:
978: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
979:
980: EXCEPTION
981: WHEN OKL_API.G_EXCEPTION_ERROR THEN
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS
983: (substr(l_api_name,1,26),
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_ERROR',

Line 982: x_return_status := OKL_API.HANDLE_EXCEPTIONS

978: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
979:
980: EXCEPTION
981: WHEN OKL_API.G_EXCEPTION_ERROR THEN
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS
983: (substr(l_api_name,1,26),
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_ERROR',
986: x_msg_count,

Line 985: 'OKL_API.G_RET_STS_ERROR',

981: WHEN OKL_API.G_EXCEPTION_ERROR THEN
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS
983: (substr(l_api_name,1,26),
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_ERROR',
986: x_msg_count,
987: x_msg_data,
988: G_SCOPE);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

985: 'OKL_API.G_RET_STS_ERROR',
986: x_msg_count,
987: x_msg_data,
988: G_SCOPE);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
990: x_return_status := OKL_API.HANDLE_EXCEPTIONS
991: (substr(l_api_name,1,26),
992: G_PKG_NAME,
993: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 990: x_return_status := OKL_API.HANDLE_EXCEPTIONS

986: x_msg_count,
987: x_msg_data,
988: G_SCOPE);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
990: x_return_status := OKL_API.HANDLE_EXCEPTIONS
991: (substr(l_api_name,1,26),
992: G_PKG_NAME,
993: 'OKL_API.G_RET_STS_UNEXP_ERROR',
994: x_msg_count,

Line 993: 'OKL_API.G_RET_STS_UNEXP_ERROR',

989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
990: x_return_status := OKL_API.HANDLE_EXCEPTIONS
991: (substr(l_api_name,1,26),
992: G_PKG_NAME,
993: 'OKL_API.G_RET_STS_UNEXP_ERROR',
994: x_msg_count,
995: x_msg_data,
996: G_SCOPE);
997: WHEN OTHERS THEN

Line 999: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

995: x_msg_data,
996: G_SCOPE);
997: WHEN OTHERS THEN
998: -- store SQL error message on message stack for caller
999: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1000: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1001: (substr(l_api_name,1,26),
1002: G_PKG_NAME,
1003: 'OTHERS',

Line 1000: x_return_status := OKL_API.HANDLE_EXCEPTIONS

996: G_SCOPE);
997: WHEN OTHERS THEN
998: -- store SQL error message on message stack for caller
999: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1000: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1001: (substr(l_api_name,1,26),
1002: G_PKG_NAME,
1003: 'OTHERS',
1004: x_msg_count,

Line 1012: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1008: END copy_party_roles;
1009:
1010: PROCEDURE copy_articles(
1011: p_api_version IN NUMBER,
1012: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1013: x_return_status OUT NOCOPY VARCHAR2,
1014: x_msg_count OUT NOCOPY NUMBER,
1015: x_msg_data OUT NOCOPY VARCHAR2,
1016: p_cat_id IN NUMBER,

Line 1017: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

1013: x_return_status OUT NOCOPY VARCHAR2,
1014: x_msg_count OUT NOCOPY NUMBER,
1015: x_msg_data OUT NOCOPY VARCHAR2,
1016: p_cat_id IN NUMBER,
1017: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1018: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1019: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
1020: x_cat_id OUT NOCOPY NUMBER) IS
1021:

Line 1018: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

1014: x_msg_count OUT NOCOPY NUMBER,
1015: x_msg_data OUT NOCOPY VARCHAR2,
1016: p_cat_id IN NUMBER,
1017: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1018: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1019: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
1020: x_cat_id OUT NOCOPY NUMBER) IS
1021:
1022:

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

1020: x_cat_id OUT NOCOPY NUMBER) IS
1021:
1022:
1023: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_ARTICLES';
1024: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1025: BEGIN
1026: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
1027: G_PKG_NAME,
1028: p_init_msg_list,

Line 1026: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

1022:
1023: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_ARTICLES';
1024: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1025: BEGIN
1026: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
1027: G_PKG_NAME,
1028: p_init_msg_list,
1029: G_API_VERSION,
1030: p_api_version,

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

1029: G_API_VERSION,
1030: p_api_version,
1031: G_SCOPE,
1032: x_return_status);
1033: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;

Line 1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1030: p_api_version,
1031: G_SCOPE,
1032: x_return_status);
1033: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:

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

1031: G_SCOPE,
1032: x_return_status);
1033: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: --Custom pre processing section

Line 1036: RAISE OKL_API.G_EXCEPTION_ERROR;

1032: x_return_status);
1033: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: --Custom pre processing section
1040:

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

1051: p_chr_id => p_chr_id,
1052: p_sav_sav_release => p_sav_sav_release,
1053: x_cat_id => x_cat_id);
1054:
1055: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1057: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_ERROR;
1059: END IF;

Line 1056: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1052: p_sav_sav_release => p_sav_sav_release,
1053: x_cat_id => x_cat_id);
1054:
1055: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1057: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_ERROR;
1059: END IF;
1060:

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

1053: x_cat_id => x_cat_id);
1054:
1055: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1057: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_ERROR;
1059: END IF;
1060:
1061: --Vertical post processing section

Line 1058: RAISE OKL_API.G_EXCEPTION_ERROR;

1054:
1055: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1057: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_ERROR;
1059: END IF;
1060:
1061: --Vertical post processing section
1062:

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

1061: --Vertical post processing section
1062:
1063: --Custom post processing section
1064:
1065: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1066:
1067: EXCEPTION
1068: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1068: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1064:
1065: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1066:
1067: EXCEPTION
1068: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1070: (substr(l_api_name,1,26),
1071: G_PKG_NAME,
1072: 'OKL_API.G_RET_STS_ERROR',

Line 1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1065: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1066:
1067: EXCEPTION
1068: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1070: (substr(l_api_name,1,26),
1071: G_PKG_NAME,
1072: 'OKL_API.G_RET_STS_ERROR',
1073: x_msg_count,

Line 1072: 'OKL_API.G_RET_STS_ERROR',

1068: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1070: (substr(l_api_name,1,26),
1071: G_PKG_NAME,
1072: 'OKL_API.G_RET_STS_ERROR',
1073: x_msg_count,
1074: x_msg_data,
1075: G_SCOPE);
1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1072: 'OKL_API.G_RET_STS_ERROR',
1073: x_msg_count,
1074: x_msg_data,
1075: G_SCOPE);
1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1078: (substr(l_api_name,1,26),
1079: G_PKG_NAME,
1080: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1077: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1073: x_msg_count,
1074: x_msg_data,
1075: G_SCOPE);
1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1078: (substr(l_api_name,1,26),
1079: G_PKG_NAME,
1080: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1081: x_msg_count,

Line 1080: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1078: (substr(l_api_name,1,26),
1079: G_PKG_NAME,
1080: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1081: x_msg_count,
1082: x_msg_data,
1083: G_SCOPE);
1084: WHEN OTHERS THEN

Line 1086: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1082: x_msg_data,
1083: G_SCOPE);
1084: WHEN OTHERS THEN
1085: -- store SQL error message on message stack for caller
1086: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1087: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1088: (substr(l_api_name,1,26),
1089: G_PKG_NAME,
1090: 'OTHERS',

Line 1087: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1083: G_SCOPE);
1084: WHEN OTHERS THEN
1085: -- store SQL error message on message stack for caller
1086: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1087: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1088: (substr(l_api_name,1,26),
1089: G_PKG_NAME,
1090: 'OTHERS',
1091: x_msg_count,

Line 1099: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1095: END copy_articles;
1096:
1097: PROCEDURE copy_latest_articles(
1098: p_api_version IN NUMBER,
1099: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1100: x_return_status OUT NOCOPY VARCHAR2,
1101: x_msg_count OUT NOCOPY NUMBER,
1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_cat_id IN NUMBER,

Line 1104: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

1100: x_return_status OUT NOCOPY VARCHAR2,
1101: x_msg_count OUT NOCOPY NUMBER,
1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_cat_id IN NUMBER,
1104: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1105: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1106: x_cat_id OUT NOCOPY NUMBER) IS
1107:
1108:

Line 1105: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

1101: x_msg_count OUT NOCOPY NUMBER,
1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_cat_id IN NUMBER,
1104: p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1105: p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
1106: x_cat_id OUT NOCOPY NUMBER) IS
1107:
1108:
1109: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LATEST_ARTICLES';

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

1106: x_cat_id OUT NOCOPY NUMBER) IS
1107:
1108:
1109: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LATEST_ARTICLES';
1110: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1111: BEGIN
1112: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
1113: G_PKG_NAME,
1114: p_init_msg_list,

Line 1112: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),

1108:
1109: l_api_name CONSTANT VARCHAR2(30) := 'OKL_COPY_LATEST_ARTICLES';
1110: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1111: BEGIN
1112: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
1113: G_PKG_NAME,
1114: p_init_msg_list,
1115: G_API_VERSION,
1116: p_api_version,

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

1115: G_API_VERSION,
1116: p_api_version,
1117: G_SCOPE,
1118: x_return_status);
1119: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;

Line 1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1116: p_api_version,
1117: G_SCOPE,
1118: x_return_status);
1119: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:

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

1117: G_SCOPE,
1118: x_return_status);
1119: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:
1125: --Custom pre processing section

Line 1122: RAISE OKL_API.G_EXCEPTION_ERROR;

1118: x_return_status);
1119: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:
1125: --Custom pre processing section
1126:

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

1136: p_cle_id => p_cle_id,
1137: p_chr_id => p_chr_id,
1138: x_cat_id => x_cat_id);
1139:
1140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_ERROR;
1144: END IF;

Line 1141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1137: p_chr_id => p_chr_id,
1138: x_cat_id => x_cat_id);
1139:
1140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_ERROR;
1144: END IF;
1145:

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

1138: x_cat_id => x_cat_id);
1139:
1140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_ERROR;
1144: END IF;
1145:
1146: --Vertical Industry post processing section

Line 1143: RAISE OKL_API.G_EXCEPTION_ERROR;

1139:
1140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_ERROR;
1144: END IF;
1145:
1146: --Vertical Industry post processing section
1147:

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

1146: --Vertical Industry post processing section
1147:
1148: --Custom post processing section
1149:
1150: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1151:
1152: EXCEPTION
1153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1154: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1153: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1149:
1150: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1151:
1152: EXCEPTION
1153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1155: (substr(l_api_name,1,26),
1156: G_PKG_NAME,
1157: 'OKL_API.G_RET_STS_ERROR',

Line 1154: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1150: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1151:
1152: EXCEPTION
1153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1155: (substr(l_api_name,1,26),
1156: G_PKG_NAME,
1157: 'OKL_API.G_RET_STS_ERROR',
1158: x_msg_count,

Line 1157: 'OKL_API.G_RET_STS_ERROR',

1153: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1154: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1155: (substr(l_api_name,1,26),
1156: G_PKG_NAME,
1157: 'OKL_API.G_RET_STS_ERROR',
1158: x_msg_count,
1159: x_msg_data,
1160: G_SCOPE);
1161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1157: 'OKL_API.G_RET_STS_ERROR',
1158: x_msg_count,
1159: x_msg_data,
1160: G_SCOPE);
1161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1162: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),
1164: G_PKG_NAME,
1165: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1162: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1158: x_msg_count,
1159: x_msg_data,
1160: G_SCOPE);
1161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1162: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),
1164: G_PKG_NAME,
1165: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1166: x_msg_count,

Line 1165: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1162: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1163: (substr(l_api_name,1,26),
1164: G_PKG_NAME,
1165: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1166: x_msg_count,
1167: x_msg_data,
1168: G_SCOPE);
1169: WHEN OTHERS THEN

Line 1171: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

1167: x_msg_data,
1168: G_SCOPE);
1169: WHEN OTHERS THEN
1170: -- store SQL error message on message stack for caller
1171: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1172: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1173: (substr(l_api_name,1,26),
1174: G_PKG_NAME,
1175: 'OTHERS',

Line 1172: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1168: G_SCOPE);
1169: WHEN OTHERS THEN
1170: -- store SQL error message on message stack for caller
1171: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1172: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1173: (substr(l_api_name,1,26),
1174: G_PKG_NAME,
1175: 'OTHERS',
1176: x_msg_count,