eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STREAMS_PVT dependencies on OKC_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2: /* $Header: OKLCSTMB.pls 120.3 2005/07/05 05:25:47 mansrini noship $ */
3:
4: PROCEDURE create_streams(
5: p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_stmv_rec IN stmv_rec_type

Line 18: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

14: ) IS
15:
16: i NUMBER;
17: l_stmv_rec stmv_rec_type;
18: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
19: l_selv_tbl selv_tbl_type := p_selv_tbl;
20:
21: BEGIN
22: -- Populate streams table

Line 32: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

28: ,x_msg_data => x_msg_data
29: ,p_stmv_rec => p_stmv_rec
30: ,x_stmv_rec => x_stmv_rec);
31: -- rabhupat bug#4371472 user defined exceptions are not handled
32: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
33: RAISE G_EXCEPTION_HALT_VALIDATION;
34: END IF;
35: -- rabhupat bug#4371472 end
36: -- populate the foreign key for the stream elements

Line 56: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

52: ,x_msg_data => x_msg_data
53: ,p_selv_tbl => l_selv_tbl
54: ,x_selv_tbl => x_selv_tbl);
55: -- rabhupat bug#4371472 user defined exceptions are not handled
56: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
57: RAISE G_EXCEPTION_HALT_VALIDATION;
58: END IF;
59: -- rabhupat bug#4371472 end
60: EXCEPTION

Line 65: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

61: WHEN G_EXCEPTION_HALT_VALIDATION THEN
62: NULL;
63:
64: WHEN OTHERS THEN
65: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
66: ,p_msg_name => g_unexpected_error
67: ,p_token1 => g_sqlcode_token
68: ,p_token1_value => SQLCODE
69: ,p_token2 => g_sqlerrm_token

Line 71: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

67: ,p_token1 => g_sqlcode_token
68: ,p_token1_value => SQLCODE
69: ,p_token2 => g_sqlerrm_token
70: ,p_token2_value => SQLERRM);
71: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
72: END create_streams;
73:
74:
75: -- create streams(master-table,detail-table)

Line 78: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

74:
75: -- create streams(master-table,detail-table)
76: PROCEDURE create_streams(
77: p_api_version IN NUMBER
78: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_msg_count OUT NOCOPY NUMBER
81: ,x_msg_data OUT NOCOPY VARCHAR2
82: ,p_stmv_tbl IN stmv_tbl_type

Line 88: l_return_status VARCHAR2(1) :=OKC_API.G_RET_STS_SUCCESS;

84: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type
85: ,x_selv_tbl OUT NOCOPY selv_tbl_type
86: )
87: IS
88: l_return_status VARCHAR2(1) :=OKC_API.G_RET_STS_SUCCESS;
89: l_stmv_tbl stmv_tbl_type;
90: l_selv_tbl selv_tbl_type := p_selv_tbl;
91:
92: i BINARY_INTEGER;

Line 107: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

103: x_stmv_tbl);
104: okl_accounting_util.get_error_message(x_msg_count, x_msg_data);
105:
106: -- rabhupat bug#4371472 user defined exceptions are not handled
107: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
108: RAISE G_EXCEPTION_HALT_VALIDATION;
109: END IF;
110: -- rabhupat bug#4371472 end
111:

Line 144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

140: x_msg_data,
141: l_selv_tbl,
142: x_selv_tbl);
143:
144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
145: RAISE G_EXCEPTION_HALT_VALIDATION;
146: ELSE
147: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
148: l_return_status :=x_return_status;

Line 147: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

143:
144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
145: RAISE G_EXCEPTION_HALT_VALIDATION;
146: ELSE
147: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
148: l_return_status :=x_return_status;
149: END IF;
150: END IF;
151: EXCEPTION

Line 155: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

151: EXCEPTION
152: WHEN G_EXCEPTION_HALT_VALIDATION THEN
153: NULL;
154: WHEN OTHERS THEN
155: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
156: p_msg_name => g_unexpected_error,
157: p_token1 => g_sqlcode_token,
158: p_token1_value => SQLCODE,
159: p_token2 => g_sqlerrm_token,

Line 162: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

158: p_token1_value => SQLCODE,
159: p_token2 => g_sqlerrm_token,
160: p_token2_value => SQLERRM);
161:
162: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
163:
164: END create_streams;
165:
166: PROCEDURE create_streams(

Line 168: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

164: END create_streams;
165:
166: PROCEDURE create_streams(
167: p_api_version IN NUMBER
168: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
169: ,x_return_status OUT NOCOPY VARCHAR2
170: ,x_msg_count OUT NOCOPY NUMBER
171: ,x_msg_data OUT NOCOPY VARCHAR2
172: ,p_stmv_rec IN stmv_rec_type

Line 174: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

170: ,x_msg_count OUT NOCOPY NUMBER
171: ,x_msg_data OUT NOCOPY VARCHAR2
172: ,p_stmv_rec IN stmv_rec_type
173: ,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
174: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
175: BEGIN
176: Okl_Stm_Pvt.insert_row(
177: p_api_version => p_api_version
178: ,p_init_msg_list => p_init_msg_list

Line 186: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

182: ,p_stmv_rec => p_stmv_rec
183: ,x_stmv_rec => x_stmv_rec
184: );
185:
186: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
187: RAISE G_EXCEPTION_HALT_VALIDATION;
188: ELSE
189: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
190: l_return_status := x_return_status;

Line 189: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

185:
186: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
187: RAISE G_EXCEPTION_HALT_VALIDATION;
188: ELSE
189: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
190: l_return_status := x_return_status;
191: END IF;
192: END IF;
193: -- Custom code if any

Line 200: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

196: WHEN G_EXCEPTION_HALT_VALIDATION THEN
197: NULL;
198:
199: WHEN OTHERS THEN
200: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
201: ,p_msg_name => g_unexpected_error
202: ,p_token1 => g_sqlcode_token
203: ,p_token1_value => SQLCODE
204: ,p_token2 => g_sqlerrm_token

Line 206: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

202: ,p_token1 => g_sqlcode_token
203: ,p_token1_value => SQLCODE
204: ,p_token2 => g_sqlerrm_token
205: ,p_token2_value => SQLERRM);
206: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
207: END create_streams;
208:
209:
210:

Line 213: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

209:
210:
211: PROCEDURE create_streams(
212: p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
214: ,x_return_status OUT NOCOPY VARCHAR2
215: ,x_msg_count OUT NOCOPY NUMBER
216: ,x_msg_data OUT NOCOPY VARCHAR2
217: ,p_stmv_tbl IN stmv_tbl_type

Line 219: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

215: ,x_msg_count OUT NOCOPY NUMBER
216: ,x_msg_data OUT NOCOPY VARCHAR2
217: ,p_stmv_tbl IN stmv_tbl_type
218: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
219: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
220:
221: BEGIN
222: Okl_Stm_Pvt.insert_row(
223: p_api_version => p_api_version

Line 231: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

227: ,x_msg_data => x_msg_data
228: ,p_stmv_tbl => p_stmv_tbl
229: ,x_stmv_tbl => x_stmv_tbl
230: );
231: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
232: RAISE G_EXCEPTION_HALT_VALIDATION;
233: ELSE
234: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
235: l_return_status := x_return_status;

Line 234: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

230: );
231: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
232: RAISE G_EXCEPTION_HALT_VALIDATION;
233: ELSE
234: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
235: l_return_status := x_return_status;
236: END IF;
237: END IF;
238: -- Custom code if any

Line 245: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

241: WHEN G_EXCEPTION_HALT_VALIDATION THEN
242: NULL;
243:
244: WHEN OTHERS THEN
245: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
246: ,p_msg_name => g_unexpected_error
247: ,p_token1 => g_sqlcode_token
248: ,p_token1_value => SQLCODE
249: ,p_token2 => g_sqlerrm_token

Line 251: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

247: ,p_token1 => g_sqlcode_token
248: ,p_token1_value => SQLCODE
249: ,p_token2 => g_sqlerrm_token
250: ,p_token2_value => SQLERRM);
251: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
252:
253: END create_streams;
254:
255: -- Added by kthiruva on 12-May-2005 for Streams Performance

Line 260: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

256: -- Bug 4346646 - Start of Changes
257: -- create streams(master-table,detail-table)
258: PROCEDURE create_streams_perf(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
261: ,x_return_status OUT NOCOPY VARCHAR2
262: ,x_msg_count OUT NOCOPY NUMBER
263: ,x_msg_data OUT NOCOPY VARCHAR2
264: ,p_stmv_tbl IN stmv_tbl_type

Line 270: l_return_status VARCHAR2(1) :=OKC_API.G_RET_STS_SUCCESS;

266: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type
267: ,x_selv_tbl OUT NOCOPY selv_tbl_type
268: )
269: IS
270: l_return_status VARCHAR2(1) :=OKC_API.G_RET_STS_SUCCESS;
271: l_stmv_tbl stmv_tbl_type;
272: l_selv_tbl selv_tbl_type := p_selv_tbl;
273:
274: i BINARY_INTEGER;

Line 290: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

286: x_stmv_tbl);
287: okl_accounting_util.get_error_message(x_msg_count, x_msg_data);
288:
289: -- rabhupat bug#4371472 user defined exceptions are not handled
290: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
291: RAISE G_EXCEPTION_HALT_VALIDATION;
292: END IF;
293: -- rabhupat bug#4371472 end
294:

Line 320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

316: x_msg_data,
317: l_selv_tbl,
318: x_selv_tbl);
319:
320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE G_EXCEPTION_HALT_VALIDATION;
322: ELSE
323: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
324: l_return_status :=x_return_status;

Line 323: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

319:
320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE G_EXCEPTION_HALT_VALIDATION;
322: ELSE
323: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
324: l_return_status :=x_return_status;
325: END IF;
326: END IF;
327: EXCEPTION

Line 331: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

327: EXCEPTION
328: WHEN G_EXCEPTION_HALT_VALIDATION THEN
329: NULL;
330: WHEN OTHERS THEN
331: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
332: p_msg_name => g_unexpected_error,
333: p_token1 => g_sqlcode_token,
334: p_token1_value => SQLCODE,
335: p_token2 => g_sqlerrm_token,

Line 338: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

334: p_token1_value => SQLCODE,
335: p_token2 => g_sqlerrm_token,
336: p_token2_value => SQLERRM);
337:
338: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
339:
340: END create_streams_perf;
341: --Bug 4346646-End of Changes
342:

Line 346: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

342:
343: -- Object type procedure for update
344: PROCEDURE update_streams(
345: p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: p_stmv_rec IN stmv_rec_type,

Line 354: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

350: p_stmv_rec IN stmv_rec_type,
351: p_selv_tbl IN selv_tbl_type,
352: x_stmv_rec OUT NOCOPY stmv_rec_type,
353: x_selv_tbl OUT NOCOPY selv_tbl_type) IS
354: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
355: BEGIN
356: -- Update the master
357: update_streams(
358: p_api_version => p_api_version

Line 367: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

363: ,p_stmv_rec => p_stmv_rec
364: ,x_stmv_rec => x_stmv_rec
365: );
366: -- rabhupat bug#4371472 user defined exceptions are not handled
367: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
368: RAISE G_EXCEPTION_HALT_VALIDATION;
369: END IF;
370: -- rabhupat bug#4371472 end
371:

Line 383: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

379: ,p_selv_tbl => p_selv_tbl
380: ,x_selv_tbl => x_selv_tbl
381: );
382:
383: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
384: RAISE G_EXCEPTION_HALT_VALIDATION;
385: ELSE
386: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
387: l_return_status := x_return_status;

Line 386: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

382:
383: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
384: RAISE G_EXCEPTION_HALT_VALIDATION;
385: ELSE
386: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
387: l_return_status := x_return_status;
388: END IF;
389: END IF;
390:

Line 396: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

392: WHEN G_EXCEPTION_HALT_VALIDATION THEN
393: NULL;
394:
395: WHEN OTHERS THEN
396: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
397: ,p_msg_name => g_unexpected_error
398: ,p_token1 => g_sqlcode_token
399: ,p_token1_value => SQLCODE
400: ,p_token2 => g_sqlerrm_token

Line 402: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

398: ,p_token1 => g_sqlcode_token
399: ,p_token1_value => SQLCODE
400: ,p_token2 => g_sqlerrm_token
401: ,p_token2_value => SQLERRM);
402: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
403:
404: END update_streams;
405:
406: PROCEDURE validate_streams(

Line 408: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

404: END update_streams;
405:
406: PROCEDURE validate_streams(
407: p_api_version IN NUMBER
408: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
409: ,x_return_status OUT NOCOPY VARCHAR2
410: ,x_msg_count OUT NOCOPY NUMBER
411: ,x_msg_data OUT NOCOPY VARCHAR2
412: ,p_stmv_rec IN stmv_rec_type

Line 415: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

411: ,x_msg_data OUT NOCOPY VARCHAR2
412: ,p_stmv_rec IN stmv_rec_type
413: ,p_selv_tbl IN selv_tbl_type) IS
414:
415: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
416: BEGIN
417: -- Validate the master
418: validate_streams(
419: p_api_version => p_api_version

Line 428: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

424: ,p_stmv_rec => p_stmv_rec
425: );
426:
427: -- rabhupat bug#4371472 user defined exceptions are not handled
428: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
429: RAISE G_EXCEPTION_HALT_VALIDATION;
430: END IF;
431: -- rabhupat bug#4371472 end
432:

Line 443: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

439: ,x_msg_data => x_msg_data
440: ,p_selv_tbl => p_selv_tbl
441: );
442:
443: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
444: RAISE G_EXCEPTION_HALT_VALIDATION;
445: ELSE
446: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
447: l_return_status := x_return_status;

Line 446: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

442:
443: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
444: RAISE G_EXCEPTION_HALT_VALIDATION;
445: ELSE
446: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
447: l_return_status := x_return_status;
448: END IF;
449: END IF;
450:

Line 455: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

451: EXCEPTION
452: WHEN G_EXCEPTION_HALT_VALIDATION THEN
453: NULL;
454: WHEN OTHERS THEN
455: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
456: ,p_msg_name => g_unexpected_error
457: ,p_token1 => g_sqlcode_token
458: ,p_token1_value => SQLCODE
459: ,p_token2 => g_sqlerrm_token

Line 461: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

457: ,p_token1 => g_sqlcode_token
458: ,p_token1_value => SQLCODE
459: ,p_token2 => g_sqlerrm_token
460: ,p_token2_value => SQLERRM);
461: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
462:
463: END validate_streams;
464:
465: PROCEDURE lock_streams(

Line 467: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

463: END validate_streams;
464:
465: PROCEDURE lock_streams(
466: p_api_version IN NUMBER
467: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_msg_count OUT NOCOPY NUMBER
470: ,x_msg_data OUT NOCOPY VARCHAR2
471: ,p_stmv_rec IN stmv_rec_type) IS

Line 472: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_msg_count OUT NOCOPY NUMBER
470: ,x_msg_data OUT NOCOPY VARCHAR2
471: ,p_stmv_rec IN stmv_rec_type) IS
472: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
473:
474: BEGIN
475: Okl_Stm_Pvt.lock_row(
476: p_api_version => p_api_version

Line 483: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

479: ,x_msg_count => x_msg_count
480: ,x_msg_data => x_msg_data
481: ,p_stmv_rec => p_stmv_rec
482: );
483: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
484: RAISE G_EXCEPTION_HALT_VALIDATION;
485: ELSE
486: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
487: l_return_status := x_return_status;

Line 486: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

482: );
483: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
484: RAISE G_EXCEPTION_HALT_VALIDATION;
485: ELSE
486: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
487: l_return_status := x_return_status;
488: END IF;
489: END IF;
490:

Line 495: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

491: EXCEPTION
492: WHEN G_EXCEPTION_HALT_VALIDATION THEN
493: NULL;
494: WHEN OTHERS THEN
495: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
496: ,p_msg_name => g_unexpected_error
497: ,p_token1 => g_sqlcode_token
498: ,p_token1_value => SQLCODE
499: ,p_token2 => g_sqlerrm_token

Line 501: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

497: ,p_token1 => g_sqlcode_token
498: ,p_token1_value => SQLCODE
499: ,p_token2 => g_sqlerrm_token
500: ,p_token2_value => SQLERRM);
501: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
502: END lock_streams;
503:
504: PROCEDURE lock_streams(
505: p_api_version IN NUMBER

Line 506: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

502: END lock_streams;
503:
504: PROCEDURE lock_streams(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER
509: ,x_msg_data OUT NOCOPY VARCHAR2
510: ,p_stmv_tbl IN stmv_tbl_type) IS

Line 511: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER
509: ,x_msg_data OUT NOCOPY VARCHAR2
510: ,p_stmv_tbl IN stmv_tbl_type) IS
511: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
512:
513: BEGIN
514: Okl_Stm_Pvt.lock_row(
515: p_api_version => p_api_version

Line 522: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

518: ,x_msg_count => x_msg_count
519: ,x_msg_data => x_msg_data
520: ,p_stmv_tbl => p_stmv_tbl
521: );
522: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
523: RAISE G_EXCEPTION_HALT_VALIDATION;
524: ELSE
525: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
526: l_return_status := x_return_status;

Line 525: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

521: );
522: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
523: RAISE G_EXCEPTION_HALT_VALIDATION;
524: ELSE
525: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
526: l_return_status := x_return_status;
527: END IF;
528: END IF;
529:

Line 534: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

530: EXCEPTION
531: WHEN G_EXCEPTION_HALT_VALIDATION THEN
532: NULL;
533: WHEN OTHERS THEN
534: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
535: ,p_msg_name => g_unexpected_error
536: ,p_token1 => g_sqlcode_token
537: ,p_token1_value => SQLCODE
538: ,p_token2 => g_sqlerrm_token

Line 540: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

536: ,p_token1 => g_sqlcode_token
537: ,p_token1_value => SQLCODE
538: ,p_token2 => g_sqlerrm_token
539: ,p_token2_value => SQLERRM);
540: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
541: END lock_streams;
542:
543: PROCEDURE update_streams(
544: p_api_version IN NUMBER

Line 545: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

541: END lock_streams;
542:
543: PROCEDURE update_streams(
544: p_api_version IN NUMBER
545: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
546: ,x_return_status OUT NOCOPY VARCHAR2
547: ,x_msg_count OUT NOCOPY NUMBER
548: ,x_msg_data OUT NOCOPY VARCHAR2
549: ,p_stmv_rec IN stmv_rec_type

Line 551: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

547: ,x_msg_count OUT NOCOPY NUMBER
548: ,x_msg_data OUT NOCOPY VARCHAR2
549: ,p_stmv_rec IN stmv_rec_type
550: ,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
551: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
552:
553: BEGIN
554: Okl_Stm_Pvt.update_row(
555: p_api_version => p_api_version

Line 563: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

559: ,x_msg_data => x_msg_data
560: ,p_stmv_rec => p_stmv_rec
561: ,x_stmv_rec => x_stmv_rec
562: );
563: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
564: RAISE G_EXCEPTION_HALT_VALIDATION;
565: ELSE
566: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
567: l_return_status := x_return_status;

Line 566: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

562: );
563: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
564: RAISE G_EXCEPTION_HALT_VALIDATION;
565: ELSE
566: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
567: l_return_status := x_return_status;
568: END IF;
569: END IF;
570: EXCEPTION

Line 574: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

570: EXCEPTION
571: WHEN G_EXCEPTION_HALT_VALIDATION THEN
572: NULL;
573: WHEN OTHERS THEN
574: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
575: ,p_msg_name => g_unexpected_error
576: ,p_token1 => g_sqlcode_token
577: ,p_token1_value => SQLCODE
578: ,p_token2 => g_sqlerrm_token

Line 580: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

576: ,p_token1 => g_sqlcode_token
577: ,p_token1_value => SQLCODE
578: ,p_token2 => g_sqlerrm_token
579: ,p_token2_value => SQLERRM);
580: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
581: END update_streams;
582:
583: PROCEDURE update_streams(
584: p_api_version IN NUMBER

Line 585: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

581: END update_streams;
582:
583: PROCEDURE update_streams(
584: p_api_version IN NUMBER
585: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
586: ,x_return_status OUT NOCOPY VARCHAR2
587: ,x_msg_count OUT NOCOPY NUMBER
588: ,x_msg_data OUT NOCOPY VARCHAR2
589: ,p_stmv_tbl IN stmv_tbl_type

Line 591: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

587: ,x_msg_count OUT NOCOPY NUMBER
588: ,x_msg_data OUT NOCOPY VARCHAR2
589: ,p_stmv_tbl IN stmv_tbl_type
590: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
591: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
592: BEGIN
593: Okl_Stm_Pvt.update_row(
594: p_api_version => p_api_version
595: ,p_init_msg_list => p_init_msg_list

Line 602: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

598: ,x_msg_data => x_msg_data
599: ,p_stmv_tbl => p_stmv_tbl
600: ,x_stmv_tbl => x_stmv_tbl
601: );
602: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
603: RAISE G_EXCEPTION_HALT_VALIDATION;
604: ELSE
605: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
606: l_return_status := x_return_status;

Line 605: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

601: );
602: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
603: RAISE G_EXCEPTION_HALT_VALIDATION;
604: ELSE
605: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
606: l_return_status := x_return_status;
607: END IF;
608: END IF;
609: EXCEPTION

Line 613: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

609: EXCEPTION
610: WHEN G_EXCEPTION_HALT_VALIDATION THEN
611: NULL;
612: WHEN OTHERS THEN
613: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
614: ,p_msg_name => g_unexpected_error
615: ,p_token1 => g_sqlcode_token
616: ,p_token1_value => SQLCODE
617: ,p_token2 => g_sqlerrm_token

Line 619: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

615: ,p_token1 => g_sqlcode_token
616: ,p_token1_value => SQLCODE
617: ,p_token2 => g_sqlerrm_token
618: ,p_token2_value => SQLERRM);
619: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
620: END update_streams;
621:
622: --Put custom code for cascade delete by developer
623: PROCEDURE delete_streams(

Line 625: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

621:
622: --Put custom code for cascade delete by developer
623: PROCEDURE delete_streams(
624: p_api_version IN NUMBER
625: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
626: ,x_return_status OUT NOCOPY VARCHAR2
627: ,x_msg_count OUT NOCOPY NUMBER
628: ,x_msg_data OUT NOCOPY VARCHAR2
629: ,p_stmv_rec IN stmv_rec_type) IS

Line 631: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

627: ,x_msg_count OUT NOCOPY NUMBER
628: ,x_msg_data OUT NOCOPY VARCHAR2
629: ,p_stmv_rec IN stmv_rec_type) IS
630: i NUMBER :=0;
631: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
632: l_selv_tbl selv_tbl_type;
633:
634: CURSOR sel_csr IS
635: SELECT sel.id

Line 655: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

651: ,p_selv_tbl => l_selv_tbl
652: );
653:
654: -- rabhupat bug#4371472 user defined exceptions are not handled
655: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
656: RAISE G_EXCEPTION_HALT_VALIDATION;
657: END IF;
658: -- rabhupat bug#4371472 end
659: END IF;

Line 670: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

666: ,x_msg_data => x_msg_data
667: ,p_stmv_rec => p_stmv_rec
668: );
669:
670: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
671: RAISE G_EXCEPTION_HALT_VALIDATION;
672: ELSE
673: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
674: l_return_status := x_return_status;

Line 673: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

669:
670: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
671: RAISE G_EXCEPTION_HALT_VALIDATION;
672: ELSE
673: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
674: l_return_status := x_return_status;
675: END IF;
676: END IF;
677: EXCEPTION

Line 681: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

677: EXCEPTION
678: WHEN G_EXCEPTION_HALT_VALIDATION THEN
679: NULL;
680: WHEN OTHERS THEN
681: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
682: ,p_msg_name => g_unexpected_error
683: ,p_token1 => g_sqlcode_token
684: ,p_token1_value => SQLCODE
685: ,p_token2 => g_sqlerrm_token

Line 688: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

684: ,p_token1_value => SQLCODE
685: ,p_token2 => g_sqlerrm_token
686: ,p_token2_value => SQLERRM);
687:
688: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
689: END delete_streams;
690:
691: PROCEDURE delete_streams(
692: p_api_version IN NUMBER

Line 693: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

689: END delete_streams;
690:
691: PROCEDURE delete_streams(
692: p_api_version IN NUMBER
693: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
694: ,x_return_status OUT NOCOPY VARCHAR2
695: ,x_msg_count OUT NOCOPY NUMBER
696: ,x_msg_data OUT NOCOPY VARCHAR2
697: ,p_stmv_tbl IN stmv_tbl_type) IS

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

695: ,x_msg_count OUT NOCOPY NUMBER
696: ,x_msg_data OUT NOCOPY VARCHAR2
697: ,p_stmv_tbl IN stmv_tbl_type) IS
698: i NUMBER :=0;
699: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
700: BEGIN
701: --Initialize the return status
702: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
703: IF (p_stmv_tbl.COUNT > 0) THEN

Line 702: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

698: i NUMBER :=0;
699: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
700: BEGIN
701: --Initialize the return status
702: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
703: IF (p_stmv_tbl.COUNT > 0) THEN
704: i := p_stmv_tbl.FIRST;
705: LOOP
706: delete_streams(

Line 719: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

715: EXIT WHEN (i = p_stmv_tbl.LAST);
716: i := p_stmv_tbl.NEXT(i);
717: END LOOP;
718: END IF;
719: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
720: RAISE G_EXCEPTION_HALT_VALIDATION;
721: ELSE
722: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
723: l_return_status := x_return_status;

Line 722: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

718: END IF;
719: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
720: RAISE G_EXCEPTION_HALT_VALIDATION;
721: ELSE
722: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
723: l_return_status := x_return_status;
724: END IF;
725: END IF;
726: EXCEPTION

Line 730: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

726: EXCEPTION
727: WHEN G_EXCEPTION_HALT_VALIDATION THEN
728: NULL;
729: WHEN OTHERS THEN
730: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
731: ,p_msg_name => g_unexpected_error
732: ,p_token1 => g_sqlcode_token
733: ,p_token1_value => SQLCODE
734: ,p_token2 => g_sqlerrm_token

Line 736: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

732: ,p_token1 => g_sqlcode_token
733: ,p_token1_value => SQLCODE
734: ,p_token2 => g_sqlerrm_token
735: ,p_token2_value => SQLERRM);
736: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
737: END delete_streams;
738:
739: PROCEDURE validate_streams(
740: p_api_version IN NUMBER

Line 741: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

737: END delete_streams;
738:
739: PROCEDURE validate_streams(
740: p_api_version IN NUMBER
741: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
742: ,x_return_status OUT NOCOPY VARCHAR2
743: ,x_msg_count OUT NOCOPY NUMBER
744: ,x_msg_data OUT NOCOPY VARCHAR2
745: ,p_stmv_rec IN stmv_rec_type) IS

Line 746: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

742: ,x_return_status OUT NOCOPY VARCHAR2
743: ,x_msg_count OUT NOCOPY NUMBER
744: ,x_msg_data OUT NOCOPY VARCHAR2
745: ,p_stmv_rec IN stmv_rec_type) IS
746: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
747: BEGIN
748: Okl_Stm_Pvt.validate_row(
749: p_api_version => p_api_version
750: ,p_init_msg_list => p_init_msg_list

Line 756: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

752: ,x_msg_count => x_msg_count
753: ,x_msg_data => x_msg_data
754: ,p_stmv_rec => p_stmv_rec
755: );
756: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
757: RAISE G_EXCEPTION_HALT_VALIDATION;
758: ELSE
759: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
760: l_return_status := x_return_status;

Line 759: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

755: );
756: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
757: RAISE G_EXCEPTION_HALT_VALIDATION;
758: ELSE
759: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
760: l_return_status := x_return_status;
761: END IF;
762: END IF;
763: EXCEPTION

Line 767: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

763: EXCEPTION
764: WHEN G_EXCEPTION_HALT_VALIDATION THEN
765: NULL;
766: WHEN OTHERS THEN
767: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
768: ,p_msg_name => g_unexpected_error
769: ,p_token1 => g_sqlcode_token
770: ,p_token1_value => SQLCODE
771: ,p_token2 => g_sqlerrm_token

Line 773: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

769: ,p_token1 => g_sqlcode_token
770: ,p_token1_value => SQLCODE
771: ,p_token2 => g_sqlerrm_token
772: ,p_token2_value => SQLERRM);
773: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
774: END validate_streams;
775:
776: PROCEDURE validate_streams(
777: p_api_version IN NUMBER,

Line 778: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

774: END validate_streams;
775:
776: PROCEDURE validate_streams(
777: p_api_version IN NUMBER,
778: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
779: x_return_status OUT NOCOPY VARCHAR2,
780: x_msg_count OUT NOCOPY NUMBER,
781: x_msg_data OUT NOCOPY VARCHAR2,
782: p_stmv_tbl IN stmv_tbl_type) IS

Line 783: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

779: x_return_status OUT NOCOPY VARCHAR2,
780: x_msg_count OUT NOCOPY NUMBER,
781: x_msg_data OUT NOCOPY VARCHAR2,
782: p_stmv_tbl IN stmv_tbl_type) IS
783: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
784:
785: BEGIN
786: Okl_Stm_Pvt.validate_row(
787: p_api_version => p_api_version

Line 794: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

790: ,x_msg_count => x_msg_count
791: ,x_msg_data => x_msg_data
792: ,p_stmv_tbl => p_stmv_tbl
793: );
794: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
795: RAISE G_EXCEPTION_HALT_VALIDATION;
796: ELSE
797: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
798: l_return_status := x_return_status;

Line 797: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

793: );
794: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
795: RAISE G_EXCEPTION_HALT_VALIDATION;
796: ELSE
797: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
798: l_return_status := x_return_status;
799: END IF;
800: END IF;
801: EXCEPTION

Line 805: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

801: EXCEPTION
802: WHEN G_EXCEPTION_HALT_VALIDATION THEN
803: NULL;
804: WHEN OTHERS THEN
805: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
806: ,p_msg_name => g_unexpected_error
807: ,p_token1 => g_sqlcode_token
808: ,p_token1_value => SQLCODE
809: ,p_token2 => g_sqlerrm_token

Line 811: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

807: ,p_token1 => g_sqlcode_token
808: ,p_token1_value => SQLCODE
809: ,p_token2 => g_sqlerrm_token
810: ,p_token2_value => SQLERRM);
811: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
812: END validate_streams;
813:
814: PROCEDURE create_stream_elements(
815: p_api_version IN NUMBER

Line 816: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

812: END validate_streams;
813:
814: PROCEDURE create_stream_elements(
815: p_api_version IN NUMBER
816: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
817: ,x_return_status OUT NOCOPY VARCHAR2
818: ,x_msg_count OUT NOCOPY NUMBER
819: ,x_msg_data OUT NOCOPY VARCHAR2
820: ,p_selv_rec IN selv_rec_type

Line 822: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

818: ,x_msg_count OUT NOCOPY NUMBER
819: ,x_msg_data OUT NOCOPY VARCHAR2
820: ,p_selv_rec IN selv_rec_type
821: ,x_selv_rec OUT NOCOPY selv_rec_type) IS
822: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
823:
824: BEGIN
825: Okl_Sel_Pvt.insert_row(
826: p_api_version => p_api_version

Line 834: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

830: ,x_msg_data => x_msg_data
831: ,p_selv_rec => p_selv_rec
832: ,x_selv_rec => x_selv_rec
833: );
834: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
835: RAISE G_EXCEPTION_HALT_VALIDATION;
836: ELSE
837: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
838: l_return_status := x_return_status;

Line 837: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

833: );
834: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
835: RAISE G_EXCEPTION_HALT_VALIDATION;
836: ELSE
837: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
838: l_return_status := x_return_status;
839: END IF;
840: END IF;
841: EXCEPTION

Line 845: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

841: EXCEPTION
842: WHEN G_EXCEPTION_HALT_VALIDATION THEN
843: NULL;
844: WHEN OTHERS THEN
845: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
846: ,p_msg_name => g_unexpected_error
847: ,p_token1 => g_sqlcode_token
848: ,p_token1_value => SQLCODE
849: ,p_token2 => g_sqlerrm_token

Line 851: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

847: ,p_token1 => g_sqlcode_token
848: ,p_token1_value => SQLCODE
849: ,p_token2 => g_sqlerrm_token
850: ,p_token2_value => SQLERRM);
851: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
852: END create_stream_elements;
853:
854: PROCEDURE create_stream_elements(
855: p_api_version IN NUMBER

Line 856: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

852: END create_stream_elements;
853:
854: PROCEDURE create_stream_elements(
855: p_api_version IN NUMBER
856: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
857: ,x_return_status OUT NOCOPY VARCHAR2
858: ,x_msg_count OUT NOCOPY NUMBER
859: ,x_msg_data OUT NOCOPY VARCHAR2
860: ,p_selv_tbl IN selv_tbl_type

Line 862: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

858: ,x_msg_count OUT NOCOPY NUMBER
859: ,x_msg_data OUT NOCOPY VARCHAR2
860: ,p_selv_tbl IN selv_tbl_type
861: ,x_selv_tbl OUT NOCOPY selv_tbl_type) IS
862: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
863:
864: BEGIN
865: Okl_Sel_Pvt.insert_row(
866: p_api_version => p_api_version

Line 874: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

870: ,x_msg_data => x_msg_data
871: ,p_selv_tbl => p_selv_tbl
872: ,x_selv_tbl => x_selv_tbl
873: );
874: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
875: RAISE G_EXCEPTION_HALT_VALIDATION;
876: ELSE
877: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
878: l_return_status := x_return_status;

Line 877: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

873: );
874: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
875: RAISE G_EXCEPTION_HALT_VALIDATION;
876: ELSE
877: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
878: l_return_status := x_return_status;
879: END IF;
880: END IF;
881: EXCEPTION

Line 885: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

881: EXCEPTION
882: WHEN G_EXCEPTION_HALT_VALIDATION THEN
883: NULL;
884: WHEN OTHERS THEN
885: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
886: ,p_msg_name => g_unexpected_error
887: ,p_token1 => g_sqlcode_token
888: ,p_token1_value => SQLCODE
889: ,p_token2 => g_sqlerrm_token

Line 891: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

887: ,p_token1 => g_sqlcode_token
888: ,p_token1_value => SQLCODE
889: ,p_token2 => g_sqlerrm_token
890: ,p_token2_value => SQLERRM);
891: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
892: END create_stream_elements;
893:
894: PROCEDURE lock_stream_elements(
895: p_api_version IN NUMBER

Line 896: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

892: END create_stream_elements;
893:
894: PROCEDURE lock_stream_elements(
895: p_api_version IN NUMBER
896: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
897: ,x_return_status OUT NOCOPY VARCHAR2
898: ,x_msg_count OUT NOCOPY NUMBER
899: ,x_msg_data OUT NOCOPY VARCHAR2
900: ,p_selv_rec IN selv_rec_type) IS

Line 901: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

897: ,x_return_status OUT NOCOPY VARCHAR2
898: ,x_msg_count OUT NOCOPY NUMBER
899: ,x_msg_data OUT NOCOPY VARCHAR2
900: ,p_selv_rec IN selv_rec_type) IS
901: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
902: BEGIN
903: Okl_Sel_Pvt.lock_row(
904: p_api_version => p_api_version
905: ,p_init_msg_list => p_init_msg_list

Line 911: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

907: ,x_msg_count => x_msg_count
908: ,x_msg_data => x_msg_data
909: ,p_selv_rec => p_selv_rec
910: );
911: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
912: RAISE G_EXCEPTION_HALT_VALIDATION;
913: ELSE
914: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
915: l_return_status := x_return_status;

Line 914: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

910: );
911: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
912: RAISE G_EXCEPTION_HALT_VALIDATION;
913: ELSE
914: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
915: l_return_status := x_return_status;
916: END IF;
917: END IF;
918: EXCEPTION

Line 922: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

918: EXCEPTION
919: WHEN G_EXCEPTION_HALT_VALIDATION THEN
920: NULL;
921: WHEN OTHERS THEN
922: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
923: ,p_msg_name => g_unexpected_error
924: ,p_token1 => g_sqlcode_token
925: ,p_token1_value => SQLCODE
926: ,p_token2 => g_sqlerrm_token

Line 928: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

924: ,p_token1 => g_sqlcode_token
925: ,p_token1_value => SQLCODE
926: ,p_token2 => g_sqlerrm_token
927: ,p_token2_value => SQLERRM);
928: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
929:
930: END lock_stream_elements;
931:
932: PROCEDURE lock_stream_elements(

Line 934: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

930: END lock_stream_elements;
931:
932: PROCEDURE lock_stream_elements(
933: p_api_version IN NUMBER
934: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
935: ,x_return_status OUT NOCOPY VARCHAR2
936: ,x_msg_count OUT NOCOPY NUMBER
937: ,x_msg_data OUT NOCOPY VARCHAR2
938: ,p_selv_tbl IN selv_tbl_type) IS

Line 939: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

935: ,x_return_status OUT NOCOPY VARCHAR2
936: ,x_msg_count OUT NOCOPY NUMBER
937: ,x_msg_data OUT NOCOPY VARCHAR2
938: ,p_selv_tbl IN selv_tbl_type) IS
939: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
940:
941: BEGIN
942: Okl_Sel_Pvt.lock_row(
943: p_api_version => p_api_version

Line 950: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

946: ,x_msg_count => x_msg_count
947: ,x_msg_data => x_msg_data
948: ,p_selv_tbl => p_selv_tbl
949: );
950: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
951: RAISE G_EXCEPTION_HALT_VALIDATION;
952: ELSE
953: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
954: l_return_status := x_return_status;

Line 953: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

949: );
950: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
951: RAISE G_EXCEPTION_HALT_VALIDATION;
952: ELSE
953: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
954: l_return_status := x_return_status;
955: END IF;
956: END IF;
957: EXCEPTION

Line 961: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

957: EXCEPTION
958: WHEN G_EXCEPTION_HALT_VALIDATION THEN
959: NULL;
960: WHEN OTHERS THEN
961: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
962: ,p_msg_name => g_unexpected_error
963: ,p_token1 => g_sqlcode_token
964: ,p_token1_value => SQLCODE
965: ,p_token2 => g_sqlerrm_token

Line 967: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

963: ,p_token1 => g_sqlcode_token
964: ,p_token1_value => SQLCODE
965: ,p_token2 => g_sqlerrm_token
966: ,p_token2_value => SQLERRM);
967: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
968: END lock_stream_elements;
969:
970: PROCEDURE update_stream_elements(
971: p_api_version IN NUMBER

Line 972: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

968: END lock_stream_elements;
969:
970: PROCEDURE update_stream_elements(
971: p_api_version IN NUMBER
972: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
973: ,x_return_status OUT NOCOPY VARCHAR2
974: ,x_msg_count OUT NOCOPY NUMBER
975: ,x_msg_data OUT NOCOPY VARCHAR2
976: ,p_selv_rec IN selv_rec_type

Line 978: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

974: ,x_msg_count OUT NOCOPY NUMBER
975: ,x_msg_data OUT NOCOPY VARCHAR2
976: ,p_selv_rec IN selv_rec_type
977: ,x_selv_rec OUT NOCOPY selv_rec_type) IS
978: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
979:
980: BEGIN
981: Okl_Sel_Pvt.update_row(
982: p_api_version => p_api_version

Line 990: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

986: ,x_msg_data => x_msg_data
987: ,p_selv_rec => p_selv_rec
988: ,x_selv_rec => x_selv_rec
989: );
990: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
991: RAISE G_EXCEPTION_HALT_VALIDATION;
992: ELSE
993: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
994: l_return_status := x_return_status;

Line 993: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

989: );
990: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
991: RAISE G_EXCEPTION_HALT_VALIDATION;
992: ELSE
993: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
994: l_return_status := x_return_status;
995: END IF;
996: END IF;
997: EXCEPTION

Line 1001: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

997: EXCEPTION
998: WHEN G_EXCEPTION_HALT_VALIDATION THEN
999: NULL;
1000: WHEN OTHERS THEN
1001: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1002: ,p_msg_name => g_unexpected_error
1003: ,p_token1 => g_sqlcode_token
1004: ,p_token1_value => SQLCODE
1005: ,p_token2 => g_sqlerrm_token

Line 1007: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1003: ,p_token1 => g_sqlcode_token
1004: ,p_token1_value => SQLCODE
1005: ,p_token2 => g_sqlerrm_token
1006: ,p_token2_value => SQLERRM);
1007: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1008: END update_stream_elements;
1009:
1010: PROCEDURE update_stream_elements(
1011: p_api_version IN NUMBER

Line 1012: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

1008: END update_stream_elements;
1009:
1010: PROCEDURE update_stream_elements(
1011: p_api_version IN NUMBER
1012: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_selv_tbl IN selv_tbl_type

Line 1018: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1014: ,x_msg_count OUT NOCOPY NUMBER
1015: ,x_msg_data OUT NOCOPY VARCHAR2
1016: ,p_selv_tbl IN selv_tbl_type
1017: ,x_selv_tbl OUT NOCOPY selv_tbl_type) IS
1018: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1019:
1020: BEGIN
1021: Okl_Sel_Pvt.update_row(
1022: p_api_version => p_api_version

Line 1030: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1026: ,x_msg_data => x_msg_data
1027: ,p_selv_tbl => p_selv_tbl
1028: ,x_selv_tbl => x_selv_tbl
1029: );
1030: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1031: RAISE G_EXCEPTION_HALT_VALIDATION;
1032: ELSE
1033: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1034: l_return_status := x_return_status;

Line 1033: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1029: );
1030: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1031: RAISE G_EXCEPTION_HALT_VALIDATION;
1032: ELSE
1033: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1034: l_return_status := x_return_status;
1035: END IF;
1036: END IF;
1037: EXCEPTION

Line 1041: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1037: EXCEPTION
1038: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1039: NULL;
1040: WHEN OTHERS THEN
1041: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1042: ,p_msg_name => g_unexpected_error
1043: ,p_token1 => g_sqlcode_token
1044: ,p_token1_value => SQLCODE
1045: ,p_token2 => g_sqlerrm_token

Line 1047: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1043: ,p_token1 => g_sqlcode_token
1044: ,p_token1_value => SQLCODE
1045: ,p_token2 => g_sqlerrm_token
1046: ,p_token2_value => SQLERRM);
1047: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1048: END update_stream_elements;
1049:
1050: --Put custom code for cascade delete by developer
1051: PROCEDURE delete_stream_elements(

Line 1053: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

1049:
1050: --Put custom code for cascade delete by developer
1051: PROCEDURE delete_stream_elements(
1052: p_api_version IN NUMBER
1053: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
1054: ,x_return_status OUT NOCOPY VARCHAR2
1055: ,x_msg_count OUT NOCOPY NUMBER
1056: ,x_msg_data OUT NOCOPY VARCHAR2
1057: ,p_selv_rec IN selv_rec_type) IS

Line 1059: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1055: ,x_msg_count OUT NOCOPY NUMBER
1056: ,x_msg_data OUT NOCOPY VARCHAR2
1057: ,p_selv_rec IN selv_rec_type) IS
1058: i NUMBER :=0;
1059: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1060: BEGIN
1061: Okl_Sel_Pvt.delete_row(
1062: p_api_version => p_api_version
1063: ,p_init_msg_list => p_init_msg_list

Line 1068: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1064: ,x_return_status => x_return_status
1065: ,x_msg_count => x_msg_count
1066: ,x_msg_data => x_msg_data
1067: ,p_selv_rec => p_selv_rec);
1068: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE G_EXCEPTION_HALT_VALIDATION;
1070: ELSE
1071: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1072: l_return_status := x_return_status;

Line 1071: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1067: ,p_selv_rec => p_selv_rec);
1068: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE G_EXCEPTION_HALT_VALIDATION;
1070: ELSE
1071: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1072: l_return_status := x_return_status;
1073: END IF;
1074: END IF;
1075: EXCEPTION

Line 1079: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1075: EXCEPTION
1076: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1077: NULL;
1078: WHEN OTHERS THEN
1079: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1080: ,p_msg_name => g_unexpected_error
1081: ,p_token1 => g_sqlcode_token
1082: ,p_token1_value => SQLCODE
1083: ,p_token2 => g_sqlerrm_token

Line 1085: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1081: ,p_token1 => g_sqlcode_token
1082: ,p_token1_value => SQLCODE
1083: ,p_token2 => g_sqlerrm_token
1084: ,p_token2_value => SQLERRM);
1085: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1086: END delete_stream_elements;
1087:
1088: PROCEDURE delete_stream_elements(
1089: p_api_version IN NUMBER

Line 1090: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

1086: END delete_stream_elements;
1087:
1088: PROCEDURE delete_stream_elements(
1089: p_api_version IN NUMBER
1090: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
1091: ,x_return_status OUT NOCOPY VARCHAR2
1092: ,x_msg_count OUT NOCOPY NUMBER
1093: ,x_msg_data OUT NOCOPY VARCHAR2
1094: ,p_selv_tbl IN selv_tbl_type) IS

Line 1097: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1093: ,x_msg_data OUT NOCOPY VARCHAR2
1094: ,p_selv_tbl IN selv_tbl_type) IS
1095:
1096: i NUMBER :=0;
1097: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1098: BEGIN
1099: --Initialize the return status
1100: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1101: IF (p_selv_tbl.COUNT > 0) THEN

Line 1100: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1096: i NUMBER :=0;
1097: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1098: BEGIN
1099: --Initialize the return status
1100: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1101: IF (p_selv_tbl.COUNT > 0) THEN
1102: i := p_selv_tbl.FIRST;
1103: LOOP
1104: delete_stream_elements(

Line 1115: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1111: EXIT WHEN (i = p_selv_tbl.LAST);
1112: i := p_selv_tbl.NEXT(i);
1113: END LOOP;
1114: END IF;
1115: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE G_EXCEPTION_HALT_VALIDATION;
1117: ELSE
1118: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1119: l_return_status := x_return_status;

Line 1118: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1114: END IF;
1115: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE G_EXCEPTION_HALT_VALIDATION;
1117: ELSE
1118: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1119: l_return_status := x_return_status;
1120: END IF;
1121: END IF;
1122: EXCEPTION

Line 1126: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1122: EXCEPTION
1123: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1124: NULL;
1125: WHEN OTHERS THEN
1126: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1127: ,p_msg_name => g_unexpected_error
1128: ,p_token1 => g_sqlcode_token
1129: ,p_token1_value => SQLCODE
1130: ,p_token2 => g_sqlerrm_token

Line 1132: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1128: ,p_token1 => g_sqlcode_token
1129: ,p_token1_value => SQLCODE
1130: ,p_token2 => g_sqlerrm_token
1131: ,p_token2_value => SQLERRM);
1132: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1133: END delete_stream_elements;
1134:
1135: PROCEDURE validate_stream_elements(
1136: p_api_version IN NUMBER

Line 1137: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

1133: END delete_stream_elements;
1134:
1135: PROCEDURE validate_stream_elements(
1136: p_api_version IN NUMBER
1137: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
1138: ,x_return_status OUT NOCOPY VARCHAR2
1139: ,x_msg_count OUT NOCOPY NUMBER
1140: ,x_msg_data OUT NOCOPY VARCHAR2
1141: ,p_selv_rec IN selv_rec_type) IS

Line 1142: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1138: ,x_return_status OUT NOCOPY VARCHAR2
1139: ,x_msg_count OUT NOCOPY NUMBER
1140: ,x_msg_data OUT NOCOPY VARCHAR2
1141: ,p_selv_rec IN selv_rec_type) IS
1142: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1143: BEGIN
1144: Okl_Sel_Pvt.validate_row(
1145: p_api_version => p_api_version
1146: ,p_init_msg_list => p_init_msg_list

Line 1152: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1148: ,x_msg_count => x_msg_count
1149: ,x_msg_data => x_msg_data
1150: ,p_selv_rec => p_selv_rec
1151: );
1152: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1153: RAISE G_EXCEPTION_HALT_VALIDATION;
1154: ELSE
1155: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1156: l_return_status := x_return_status;

Line 1155: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1151: );
1152: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1153: RAISE G_EXCEPTION_HALT_VALIDATION;
1154: ELSE
1155: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1156: l_return_status := x_return_status;
1157: END IF;
1158: END IF;
1159: EXCEPTION

Line 1163: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1159: EXCEPTION
1160: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1161: NULL;
1162: WHEN OTHERS THEN
1163: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1164: ,p_msg_name => g_unexpected_error
1165: ,p_token1 => g_sqlcode_token
1166: ,p_token1_value => SQLCODE
1167: ,p_token2 => g_sqlerrm_token

Line 1169: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1165: ,p_token1 => g_sqlcode_token
1166: ,p_token1_value => SQLCODE
1167: ,p_token2 => g_sqlerrm_token
1168: ,p_token2_value => SQLERRM);
1169: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1170: END validate_stream_elements;
1171:
1172: PROCEDURE validate_stream_elements(
1173: p_api_version IN NUMBER

Line 1174: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

1170: END validate_stream_elements;
1171:
1172: PROCEDURE validate_stream_elements(
1173: p_api_version IN NUMBER
1174: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
1175: ,x_return_status OUT NOCOPY VARCHAR2
1176: ,x_msg_count OUT NOCOPY NUMBER
1177: ,x_msg_data OUT NOCOPY VARCHAR2
1178: ,p_selv_tbl IN selv_tbl_type) IS

Line 1179: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1175: ,x_return_status OUT NOCOPY VARCHAR2
1176: ,x_msg_count OUT NOCOPY NUMBER
1177: ,x_msg_data OUT NOCOPY VARCHAR2
1178: ,p_selv_tbl IN selv_tbl_type) IS
1179: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1180: BEGIN
1181: Okl_Sel_Pvt.validate_row(
1182: p_api_version => p_api_version
1183: ,p_init_msg_list => p_init_msg_list

Line 1189: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1185: ,x_msg_count => x_msg_count
1186: ,x_msg_data => x_msg_data
1187: ,p_selv_tbl => p_selv_tbl
1188: );
1189: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1190: RAISE G_EXCEPTION_HALT_VALIDATION;
1191: ELSE
1192: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1193: l_return_status := x_return_status;

Line 1192: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1188: );
1189: IF x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1190: RAISE G_EXCEPTION_HALT_VALIDATION;
1191: ELSE
1192: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1193: l_return_status := x_return_status;
1194: END IF;
1195: END IF;
1196: EXCEPTION

Line 1200: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1196: EXCEPTION
1197: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1198: NULL;
1199: WHEN OTHERS THEN
1200: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1201: ,p_msg_name => g_unexpected_error
1202: ,p_token1 => g_sqlcode_token
1203: ,p_token1_value => SQLCODE
1204: ,p_token2 => g_sqlerrm_token

Line 1206: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1202: ,p_token1 => g_sqlcode_token
1203: ,p_token1_value => SQLCODE
1204: ,p_token2 => g_sqlerrm_token
1205: ,p_token2_value => SQLERRM);
1206: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1207: END validate_stream_elements;
1208:
1209: PROCEDURE create_version(
1210: p_api_version IN NUMBER,

Line 1211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1207: END validate_stream_elements;
1208:
1209: PROCEDURE create_version(
1210: p_api_version IN NUMBER,
1211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1212: x_return_status OUT NOCOPY VARCHAR2,
1213: x_msg_count OUT NOCOPY NUMBER,
1214: x_msg_data OUT NOCOPY VARCHAR2,
1215: p_khr_id IN NUMBER,

Line 1221: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1217:
1218:
1219: BEGIN
1220:
1221: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1222:
1223:
1224: INSERT INTO OKL_STREAMS_H
1225: (

Line 1302: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

1298: EXCEPTION
1299: -- other appropriate handlers
1300: WHEN OTHERS THEN
1301: -- store SQL error message on message stack
1302: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
1303: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
1304: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
1305: p_token1_value => sqlcode,
1306: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 1310: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1306: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
1307: p_token2_value => sqlerrm);
1308:
1309: -- notify UNEXPECTED error
1310: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1311:
1312:
1313: END create_version;
1314:

Line 1317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1313: END create_version;
1314:
1315: PROCEDURE create_strm_element_version(
1316: p_api_version IN NUMBER,
1317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1318: x_return_status OUT NOCOPY VARCHAR2,
1319: x_msg_count OUT NOCOPY NUMBER,
1320: x_msg_data OUT NOCOPY VARCHAR2,
1321: p_khr_id IN NUMBER,

Line 1324: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

1320: x_msg_data OUT NOCOPY VARCHAR2,
1321: p_khr_id IN NUMBER,
1322: p_major_version IN NUMBER) IS
1323:
1324: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
1325:
1326: BEGIN
1327:
1328:

Line 1392: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

1388: EXCEPTION
1389: -- other appropriate handlers
1390: WHEN OTHERS THEN
1391: -- store SQL error message on message stack
1392: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
1393: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
1394: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
1395: p_token1_value => sqlcode,
1396: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 1400: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1396: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
1397: p_token2_value => sqlerrm);
1398:
1399: -- notify UNEXPECTED error
1400: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1401:
1402: END create_strm_element_version;
1403:
1404: PROCEDURE version_stream(

Line 1406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1402: END create_strm_element_version;
1403:
1404: PROCEDURE version_stream(
1405: p_api_version IN NUMBER,
1406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1407: x_return_status OUT NOCOPY VARCHAR2,
1408: x_msg_count OUT NOCOPY NUMBER,
1409: x_msg_data OUT NOCOPY VARCHAR2,
1410: p_khr_id IN NUMBER,

Line 1413: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

1409: x_msg_data OUT NOCOPY VARCHAR2,
1410: p_khr_id IN NUMBER,
1411: p_major_version IN NUMBER) IS
1412:
1413: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
1414:
1415: Cursor l_valid_contract_csr(l_khr_id NUMBER) Is
1416: select 'x'
1417: from OKL_K_HEADERS

Line 1433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1429: FETCH l_valid_contract_csr into l_cntrct_val;
1430:
1431:
1432: IF l_valid_contract_csr%NOTFOUND THEN
1433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1434: p_msg_name => 'OKL_INVALID_CONTRACT_ID',
1435: p_token1 => 'CONT_ID',
1436: p_token1_value => to_char(p_khr_id));
1437:

Line 1438: l_return_status := OKC_API.G_RET_STS_ERROR;

1434: p_msg_name => 'OKL_INVALID_CONTRACT_ID',
1435: p_token1 => 'CONT_ID',
1436: p_token1_value => to_char(p_khr_id));
1437:
1438: l_return_status := OKC_API.G_RET_STS_ERROR;
1439: RAISE G_EXCEPTION_HALT_VALIDATION;
1440:
1441: ELSE
1442: null;

Line 1455: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1451: IF l_strm_csr%NOTFOUND THEN
1452: null;
1453: ELSE
1454:
1455: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1456: p_msg_name => 'OKL_UNIQUE_CONTRACT_VERSION',
1457: p_token1 => 'CONT_VERSION',
1458: p_token1_value => p_major_version);
1459:

Line 1460: l_return_status := OKC_API.G_RET_STS_ERROR;

1456: p_msg_name => 'OKL_UNIQUE_CONTRACT_VERSION',
1457: p_token1 => 'CONT_VERSION',
1458: p_token1_value => p_major_version);
1459:
1460: l_return_status := OKC_API.G_RET_STS_ERROR;
1461: RAISE G_EXCEPTION_HALT_VALIDATION;
1462:
1463: END IF;
1464: CLOSE l_strm_csr;

Line 1496: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

1492: NULL;
1493: -- other appropriate handlers
1494: WHEN OTHERS THEN
1495: -- store SQL error message on message stack
1496: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
1497: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
1498: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
1499: p_token1_value => sqlcode,
1500: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 1504: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1500: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
1501: p_token2_value => sqlerrm);
1502:
1503: -- notify UNEXPECTED error
1504: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1505:
1506:
1507:
1508: