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

Line 42: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

38: -- Procedure Name : is_khr_securitized
39: -- Description : Checks if a contract is securitized on the given date
40: -- Business Rules :
41: -- Parameters :
42: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
43: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
44: -- Version : 1.0
45: -- End of comments
46: ----------------------------------------------------------------------------------

Line 43: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR

39: -- Description : Checks if a contract is securitized on the given date
40: -- Business Rules :
41: -- Parameters :
42: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
43: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
44: -- Version : 1.0
45: -- End of comments
46: ----------------------------------------------------------------------------------
47: FUNCTION is_khr_securitized(

Line 55: x_value VARCHAR2(1) := Okl_Api.G_FALSE;

51: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE DEFAULT NULL
52: ) RETURN VARCHAR
53: IS
54: l_dummy VARCHAR2(1);
55: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
56: l_row_found BOOLEAN := FALSE;
57: v_sql VARCHAR2(4000);
58:
59: -- case 1

Line 178: x_value := Okl_Api.G_TRUE;

174: END IF;
175:
176:
177: IF l_row_found THEN
178: x_value := Okl_Api.G_TRUE;
179: ELSE
180: x_value := Okl_Api.G_FALSE;
181: END IF;
182:

Line 180: x_value := Okl_Api.G_FALSE;

176:
177: IF l_row_found THEN
178: x_value := Okl_Api.G_TRUE;
179: ELSE
180: x_value := Okl_Api.G_FALSE;
181: END IF;
182:
183:
184: RETURN x_value;

Line 187: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

183:
184: RETURN x_value;
185: EXCEPTION
186: WHEN OTHERS THEN
187: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
188: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
189: p_msg_name => 'OKL_UNEXPECTED_ERROR',
190: p_token1 => 'OKL_SQLCODE',
191: p_token1_value => SQLCODE,

Line 188: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,

184: RETURN x_value;
185: EXCEPTION
186: WHEN OTHERS THEN
187: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
188: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
189: p_msg_name => 'OKL_UNEXPECTED_ERROR',
190: p_token1 => 'OKL_SQLCODE',
191: p_token1_value => SQLCODE,
192: p_token2 => 'OKL_SQLERRM',

Line 205: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

201: -- Procedure Name : check_khr_securitized
202: -- Description : Checks if a contract is securitized on the given date
203: -- Business Rules :
204: -- Parameters :
205: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
206: -- Version : 1.0
207: -- End of comments
208: -----------------------------------------------------------------------
209: PROCEDURE check_khr_securitized(

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

224: IS
225: l_api_name CONSTANT VARCHAR2(30) := 'check_khr_securitized_pvt';
226: l_api_version CONSTANT NUMBER := 1.0;
227: i NUMBER;
228: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
229:
230: CURSOR c_inv_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
231: SELECT ph.khr_id -- inv agreemnet id
232: FROM okl_pools ph

Line 250: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

246: p_api_version,
247: l_api_name,
248: G_PKG_NAME ))
249: THEN
250: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
251: END IF;
252:
253: -- Initialize message list if requested
254: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 259: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

255: Fnd_Msg_Pub.initialize;
256: END IF;
257:
258: -- Initialize API status to success
259: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
260:
261:
262: /*** Begin API body ****************************************************/
263: -- 1. get flag

Line 294: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

290: (p_count => x_msg_count,
291: p_data => x_msg_data);
292:
293: EXCEPTION
294: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
295: ROLLBACK TO check_khr_securitized_pvt;
296: x_return_status := Okl_Api.G_RET_STS_ERROR;
297: Fnd_Msg_Pub.Count_And_Get
298: (p_count => x_msg_count,

Line 296: x_return_status := Okl_Api.G_RET_STS_ERROR;

292:
293: EXCEPTION
294: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
295: ROLLBACK TO check_khr_securitized_pvt;
296: x_return_status := Okl_Api.G_RET_STS_ERROR;
297: Fnd_Msg_Pub.Count_And_Get
298: (p_count => x_msg_count,
299: p_data => x_msg_data);
300:

Line 301: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

297: Fnd_Msg_Pub.Count_And_Get
298: (p_count => x_msg_count,
299: p_data => x_msg_data);
300:
301: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
302: ROLLBACK TO check_khr_securitized_pvt;
303: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
304: Fnd_Msg_Pub.Count_And_Get
305: (p_count => x_msg_count,

Line 303: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

299: p_data => x_msg_data);
300:
301: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
302: ROLLBACK TO check_khr_securitized_pvt;
303: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
304: Fnd_Msg_Pub.Count_And_Get
305: (p_count => x_msg_count,
306: p_data => x_msg_data);
307:

Line 310: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

306: p_data => x_msg_data);
307:
308: WHEN OTHERS THEN
309: ROLLBACK TO check_khr_securitized_pvt;
310: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
311: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
312: p_msg_name => G_UNEXPECTED_ERROR,
313: p_token1 => G_SQLCODE_TOKEN,
314: p_token1_value => SQLCODE,

Line 311: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

307:
308: WHEN OTHERS THEN
309: ROLLBACK TO check_khr_securitized_pvt;
310: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
311: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
312: p_msg_name => G_UNEXPECTED_ERROR,
313: p_token1 => G_SQLCODE_TOKEN,
314: p_token1_value => SQLCODE,
315: p_token2 => G_SQLERRM_TOKEN,

Line 330: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

326: -- Procedure Name : is_kle_securitized
327: -- Description : Checks if an Asset is securitized on the given date
328: -- Business Rules :
329: -- Parameters :
330: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
331: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
332: -- Version : 1.0
333: -- End of comments
334: ----------------------------------------------------------------------------------

Line 331: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR

327: -- Description : Checks if an Asset is securitized on the given date
328: -- Business Rules :
329: -- Parameters :
330: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
331: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
332: -- Version : 1.0
333: -- End of comments
334: ----------------------------------------------------------------------------------
335: FUNCTION is_kle_securitized(

Line 345: x_value VARCHAR2(1) := Okl_Api.G_FALSE;

341: -- cklee 08-08-2003 11.5.10
342: ) RETURN VARCHAR
343: IS
344: l_dummy VARCHAR2(1);
345: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
346: l_row_found BOOLEAN := FALSE;
347:
348: -- case 1
349: CURSOR c_kle_def(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS

Line 470: x_value := Okl_Api.G_TRUE;

466:
467: END IF;
468:
469: IF l_row_found THEN
470: x_value := Okl_Api.G_TRUE;
471: ELSE
472: x_value := Okl_Api.G_FALSE;
473: END IF;
474:

Line 472: x_value := Okl_Api.G_FALSE;

468:
469: IF l_row_found THEN
470: x_value := Okl_Api.G_TRUE;
471: ELSE
472: x_value := Okl_Api.G_FALSE;
473: END IF;
474:
475: RETURN x_value;
476: EXCEPTION

Line 478: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

474:
475: RETURN x_value;
476: EXCEPTION
477: WHEN OTHERS THEN
478: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
479:
480: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
481: p_msg_name => 'OKL_UNEXPECTED_ERROR',
482: p_token1 => 'OKL_SQLCODE',

Line 480: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,

476: EXCEPTION
477: WHEN OTHERS THEN
478: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
479:
480: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
481: p_msg_name => 'OKL_UNEXPECTED_ERROR',
482: p_token1 => 'OKL_SQLCODE',
483: p_token1_value => SQLCODE,
484: p_token2 => 'OKL_SQLERRM',

Line 498: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

494: -- Procedure Name : check_kle_securitized
495: -- Description : Checks if an Asset is securitized on the given date
496: -- Business Rules :
497: -- Parameters :
498: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
499: -- Version : 1.0
500: -- End of comments
501: -----------------------------------------------------------------------
502: PROCEDURE check_kle_securitized(

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

517: IS
518: l_api_name CONSTANT VARCHAR2(30) := 'check_kle_securitized_pvt';
519: l_api_version CONSTANT NUMBER := 1.0;
520: i NUMBER;
521: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
522:
523: CURSOR c_inv_khr(p_kle_id okc_k_lines_b.id%TYPE) IS
524: SELECT ph.khr_id -- inv agreemnet id
525: FROM okl_pools ph

Line 544: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

540: p_api_version,
541: l_api_name,
542: G_PKG_NAME ))
543: THEN
544: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
545: END IF;
546:
547: -- Initialize message list if requested
548: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 553: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

549: Fnd_Msg_Pub.initialize;
550: END IF;
551:
552: -- Initialize API status to success
553: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
554:
555:
556: /*** Begin API body ****************************************************/
557:

Line 589: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

585: (p_count => x_msg_count,
586: p_data => x_msg_data);
587:
588: EXCEPTION
589: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
590: ROLLBACK TO check_kle_securitized_pvt;
591: x_return_status := Okl_Api.G_RET_STS_ERROR;
592: Fnd_Msg_Pub.Count_And_Get
593: (p_count => x_msg_count,

Line 591: x_return_status := Okl_Api.G_RET_STS_ERROR;

587:
588: EXCEPTION
589: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
590: ROLLBACK TO check_kle_securitized_pvt;
591: x_return_status := Okl_Api.G_RET_STS_ERROR;
592: Fnd_Msg_Pub.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data);
595:

Line 596: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

592: Fnd_Msg_Pub.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data);
595:
596: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
597: ROLLBACK TO check_kle_securitized_pvt;
598: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
599: Fnd_Msg_Pub.Count_And_Get
600: (p_count => x_msg_count,

Line 598: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

594: p_data => x_msg_data);
595:
596: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
597: ROLLBACK TO check_kle_securitized_pvt;
598: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
599: Fnd_Msg_Pub.Count_And_Get
600: (p_count => x_msg_count,
601:
602: p_data => x_msg_data);

Line 606: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

602: p_data => x_msg_data);
603:
604: WHEN OTHERS THEN
605: ROLLBACK TO check_kle_securitized_pvt;
606: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
607: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
608: p_msg_name => G_UNEXPECTED_ERROR,
609: p_token1 => G_SQLCODE_TOKEN,
610: p_token1_value => SQLCODE,

Line 607: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

603:
604: WHEN OTHERS THEN
605: ROLLBACK TO check_kle_securitized_pvt;
606: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
607: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
608: p_msg_name => G_UNEXPECTED_ERROR,
609: p_token1 => G_SQLCODE_TOKEN,
610: p_token1_value => SQLCODE,
611:

Line 633: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

629: -- Procedure Name : check_sty_securitized
630: -- Description : Checks if a StreamType is securitized on the given date
631: -- Business Rules :
632: -- Parameters :
633: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
634: -- Version : 1.0
635: -- End of comments
636: -----------------------------------------------------------------------
637: PROCEDURE check_sty_securitized(

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

710: AND pocb.sty_id = styb.id;
711:
712: l_api_name CONSTANT VARCHAR2(30) := 'check_sty_securitized';
713: l_api_version CONSTANT NUMBER := 1.0;
714: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
715:
716: l_value VARCHAR2(1) := Okl_Api.G_FALSE;
717:
718: BEGIN

Line 716: l_value VARCHAR2(1) := Okl_Api.G_FALSE;

712: l_api_name CONSTANT VARCHAR2(30) := 'check_sty_securitized';
713: l_api_version CONSTANT NUMBER := 1.0;
714: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
715:
716: l_value VARCHAR2(1) := Okl_Api.G_FALSE;
717:
718: BEGIN
719:
720: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

Line 720: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

716: l_value VARCHAR2(1) := Okl_Api.G_FALSE;
717:
718: BEGIN
719:
720: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
721: p_pkg_name => G_PKG_NAME,
722: p_init_msg_list => p_init_msg_list,
723: l_api_version => l_api_version,
724: p_api_version => p_api_version,

Line 737: l_value := Okl_Api.G_TRUE;

733:
734: IF (p_effective_date_operator = G_GREATER_THAN) THEN
735: FOR l_okl_sty_grt_rec IN l_okl_sty_grt_csr
736: LOOP
737: l_value := Okl_Api.G_TRUE;
738: x_inv_agmt_chr_id := l_okl_sty_grt_rec.khr_id;
739: END LOOP;
740: ELSIF (p_effective_date_operator = G_LESS_THAN) THEN
741: FOR l_okl_sty_les_rec IN l_okl_sty_les_csr

Line 743: l_value := Okl_Api.G_TRUE;

739: END LOOP;
740: ELSIF (p_effective_date_operator = G_LESS_THAN) THEN
741: FOR l_okl_sty_les_rec IN l_okl_sty_les_csr
742: LOOP
743: l_value := Okl_Api.G_TRUE;
744: x_inv_agmt_chr_id := l_okl_sty_les_rec.khr_id;
745: END LOOP;
746: ELSIF (p_effective_date_operator = G_EQUAL_TO) THEN
747: FOR l_okl_sty_eql_rec IN l_okl_sty_eql_csr

Line 749: l_value := Okl_Api.G_TRUE;

745: END LOOP;
746: ELSIF (p_effective_date_operator = G_EQUAL_TO) THEN
747: FOR l_okl_sty_eql_rec IN l_okl_sty_eql_csr
748: LOOP
749: l_value := Okl_Api.G_TRUE;
750: x_inv_agmt_chr_id := l_okl_sty_eql_rec.khr_id;
751: END LOOP;
752: ELSIF (p_effective_date_operator = G_GREATER_THAN_EQUAL_TO) THEN
753: FOR l_okl_sty_geq_rec IN l_okl_sty_geq_csr

Line 755: l_value := Okl_Api.G_TRUE;

751: END LOOP;
752: ELSIF (p_effective_date_operator = G_GREATER_THAN_EQUAL_TO) THEN
753: FOR l_okl_sty_geq_rec IN l_okl_sty_geq_csr
754: LOOP
755: l_value := Okl_Api.G_TRUE;
756: x_inv_agmt_chr_id := l_okl_sty_geq_rec.khr_id;
757: END LOOP;
758: END IF; -- p_effective_date_operator
759:

Line 762: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

758: END IF; -- p_effective_date_operator
759:
760: x_value := l_value;
761:
762: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
763: ,x_msg_data => x_msg_data);
764:
765: x_return_status := l_return_status;
766:

Line 770: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

766:
767: EXCEPTION
768: WHEN G_EXCEPTION_ERROR THEN
769:
770: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
771: p_pkg_name => G_PKG_NAME,
772: p_exc_name => G_EXC_NAME_ERROR,
773: x_msg_count => x_msg_count,
774: x_msg_data => x_msg_data,

Line 779: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

775: p_api_type => G_API_TYPE);
776:
777: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
778:
779: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,
781: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
782: x_msg_count => x_msg_count,
783: x_msg_data => x_msg_data,

Line 787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

783: x_msg_data => x_msg_data,
784: p_api_type => G_API_TYPE);
785: WHEN OTHERS THEN
786:
787: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
788: p_pkg_name => G_PKG_NAME,
789: p_exc_name => G_EXC_NAME_OTHERS,
790: x_msg_count => x_msg_count,
791: x_msg_data => x_msg_data,

Line 802: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

798: -- Procedure Name : is_stm_securitized
799: -- Description : Checks if any of the Streams Element under a streams header is securitized
800: -- Business Rules :
801: -- Parameters :
802: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
803: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
804: -- Version : 1.0
805:
806: -- End of comments

Line 803: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR

799: -- Description : Checks if any of the Streams Element under a streams header is securitized
800: -- Business Rules :
801: -- Parameters :
802: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
803: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
804: -- Version : 1.0
805:
806: -- End of comments
807: ----------------------------------------------------------------------------------

Line 814: x_value VARCHAR2(1) := Okl_Api.G_FALSE;

810: ,p_effective_date IN DATE
811: ) RETURN VARCHAR
812: IS
813: l_dummy VARCHAR2(1);
814: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
815: l_row_found BOOLEAN := FALSE;
816:
817: CURSOR c_stm(p_stm_id okl_streams.ID%TYPE, p_effective_date DATE) IS
818: SELECT '1'

Line 851: x_value := Okl_Api.G_TRUE;

847: l_row_found := c_stm%FOUND;
848: CLOSE c_stm;
849:
850: IF l_row_found THEN
851: x_value := Okl_Api.G_TRUE;
852: ELSE
853: x_value := Okl_Api.G_FALSE;
854: END IF;
855:

Line 853: x_value := Okl_Api.G_FALSE;

849:
850: IF l_row_found THEN
851: x_value := Okl_Api.G_TRUE;
852: ELSE
853: x_value := Okl_Api.G_FALSE;
854: END IF;
855:
856: RETURN x_value;
857: EXCEPTION

Line 859: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

855:
856: RETURN x_value;
857: EXCEPTION
858: WHEN OTHERS THEN
859: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
860: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
861: p_msg_name => 'OKL_UNEXPECTED_ERROR',
862: p_token1 => 'OKL_SQLCODE',
863: p_token1_value => SQLCODE,

Line 860: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,

856: RETURN x_value;
857: EXCEPTION
858: WHEN OTHERS THEN
859: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
860: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
861: p_msg_name => 'OKL_UNEXPECTED_ERROR',
862: p_token1 => 'OKL_SQLCODE',
863: p_token1_value => SQLCODE,
864: p_token2 => 'OKL_SQLERRM',

Line 877: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

873: -- Procedure Name : check_stm_securitized
874: -- Description : Checks if any of the Streams Element under a streams header is securitized
875: -- Business Rules :
876: -- Parameters :
877: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
878: -- Version : 1.0
879: -- End of comments
880: -----------------------------------------------------------------------
881: PROCEDURE check_stm_securitized(

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

891: IS
892: l_api_name CONSTANT VARCHAR2(30) := 'check_stm_securitized_pvt';
893: l_api_version CONSTANT NUMBER := 1.0;
894: i NUMBER;
895: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
896:
897: BEGIN
898: -- Set API savepoint
899: SAVEPOINT check_stm_securitized_pvt;

Line 907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

903: p_api_version,
904: l_api_name,
905: G_PKG_NAME ))
906: THEN
907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
908: END IF;
909:
910: -- Initialize message list if requested
911: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 916: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

912: Fnd_Msg_Pub.initialize;
913: END IF;
914:
915: -- Initialize API status to success
916: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
917:
918:
919: /*** Begin API body ****************************************************/
920:

Line 932: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

928: (p_count => x_msg_count,
929: p_data => x_msg_data);
930:
931: EXCEPTION
932: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
933: ROLLBACK TO check_stm_securitized_pvt;
934: x_return_status := Okl_Api.G_RET_STS_ERROR;
935: Fnd_Msg_Pub.Count_And_Get
936: (p_count => x_msg_count,

Line 934: x_return_status := Okl_Api.G_RET_STS_ERROR;

930:
931: EXCEPTION
932: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
933: ROLLBACK TO check_stm_securitized_pvt;
934: x_return_status := Okl_Api.G_RET_STS_ERROR;
935: Fnd_Msg_Pub.Count_And_Get
936: (p_count => x_msg_count,
937: p_data => x_msg_data);
938:

Line 939: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

935: Fnd_Msg_Pub.Count_And_Get
936: (p_count => x_msg_count,
937: p_data => x_msg_data);
938:
939: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
940: ROLLBACK TO check_stm_securitized_pvt;
941: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
942: Fnd_Msg_Pub.Count_And_Get
943:

Line 941: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

937: p_data => x_msg_data);
938:
939: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
940: ROLLBACK TO check_stm_securitized_pvt;
941: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
942: Fnd_Msg_Pub.Count_And_Get
943:
944: (p_count => x_msg_count,
945: p_data => x_msg_data);

Line 949: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

945: p_data => x_msg_data);
946:
947: WHEN OTHERS THEN
948: ROLLBACK TO check_stm_securitized_pvt;
949: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
950: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
951: p_msg_name => G_UNEXPECTED_ERROR,
952: p_token1 => G_SQLCODE_TOKEN,
953: p_token1_value => SQLCODE,

Line 950: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

946:
947: WHEN OTHERS THEN
948: ROLLBACK TO check_stm_securitized_pvt;
949: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
950: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
951: p_msg_name => G_UNEXPECTED_ERROR,
952: p_token1 => G_SQLCODE_TOKEN,
953: p_token1_value => SQLCODE,
954: p_token2 => G_SQLERRM_TOKEN,

Line 968: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

964: -- Procedure Name : is_sel_securitized
965: -- Description : Checks if passed in entity is securitized
966: -- Business Rules :
967: -- Parameters :
968: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
969: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
970: -- Version : 1.0
971: -- End of comments
972: ----------------------------------------------------------------------------------

Line 969: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR

965: -- Description : Checks if passed in entity is securitized
966: -- Business Rules :
967: -- Parameters :
968: -- : return: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
969: -- OKL_API.G_RET_STS_ERROR, OKL_API.G_RET_STS_UNEXP_ERROR
970: -- Version : 1.0
971: -- End of comments
972: ----------------------------------------------------------------------------------
973: FUNCTION is_sel_securitized(

Line 979: x_value VARCHAR2(1) := Okl_Api.G_FALSE;

975: ,p_effective_date IN DATE
976: ) RETURN VARCHAR
977: IS
978: l_dummy VARCHAR2(1);
979: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
980: l_row_found BOOLEAN := FALSE;
981:
982: CURSOR c_sel(p_sel_id okl_strm_elements.ID%TYPE, p_effective_date DATE) IS
983: SELECT '1'

Line 1018: x_value := Okl_Api.G_TRUE;

1014: l_row_found := c_sel%FOUND;
1015: CLOSE c_sel;
1016:
1017: IF l_row_found THEN
1018: x_value := Okl_Api.G_TRUE;
1019: ELSE
1020: x_value := Okl_Api.G_FALSE;
1021: END IF;
1022:

Line 1020: x_value := Okl_Api.G_FALSE;

1016:
1017: IF l_row_found THEN
1018: x_value := Okl_Api.G_TRUE;
1019: ELSE
1020: x_value := Okl_Api.G_FALSE;
1021: END IF;
1022:
1023: RETURN x_value;
1024: EXCEPTION

Line 1026: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1022:
1023: RETURN x_value;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1027: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
1028: p_msg_name => 'OKL_UNEXPECTED_ERROR',
1029: p_token1 => 'OKL_SQLCODE',
1030: p_token1_value => SQLCODE,

Line 1027: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,

1023: RETURN x_value;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: --l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1027: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
1028: p_msg_name => 'OKL_UNEXPECTED_ERROR',
1029: p_token1 => 'OKL_SQLCODE',
1030: p_token1_value => SQLCODE,
1031: p_token2 => 'OKL_SQLERRM',

Line 1044: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,

1040: -- Procedure Name : check_sel_securitized
1041: -- Description : Checks if a Stream Element is securitized
1042: -- Business Rules :
1043: -- Parameters :
1044: -- : x_value: OKL_API.G_TRUE: true, OKL_API.G_FALSE false,
1045: -- Version : 1.0
1046: -- End of comments
1047: -----------------------------------------------------------------------
1048: PROCEDURE check_sel_securitized(

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

1058: IS
1059: l_api_name CONSTANT VARCHAR2(30) := 'check_sel_securitized_pvt';
1060: l_api_version CONSTANT NUMBER := 1.0;
1061: i NUMBER;
1062: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1063:
1064: BEGIN
1065: -- Set API savepoint
1066: SAVEPOINT check_sel_securitized_pvt;

Line 1074: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1070: p_api_version,
1071: l_api_name,
1072: G_PKG_NAME ))
1073: THEN
1074: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1075: END IF;
1076:
1077: -- Initialize message list if requested
1078: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 1083: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1079: Fnd_Msg_Pub.initialize;
1080: END IF;
1081:
1082: -- Initialize API status to success
1083: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1084:
1085:
1086: /*** Begin API body ****************************************************/
1087:

Line 1100: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1096: (p_count => x_msg_count,
1097: p_data => x_msg_data);
1098:
1099: EXCEPTION
1100: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1101:
1102: ROLLBACK TO check_sel_securitized_pvt;
1103: x_return_status := Okl_Api.G_RET_STS_ERROR;
1104: Fnd_Msg_Pub.Count_And_Get

Line 1103: x_return_status := Okl_Api.G_RET_STS_ERROR;

1099: EXCEPTION
1100: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1101:
1102: ROLLBACK TO check_sel_securitized_pvt;
1103: x_return_status := Okl_Api.G_RET_STS_ERROR;
1104: Fnd_Msg_Pub.Count_And_Get
1105: (p_count => x_msg_count,
1106: p_data => x_msg_data);
1107:

Line 1108: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1104: Fnd_Msg_Pub.Count_And_Get
1105: (p_count => x_msg_count,
1106: p_data => x_msg_data);
1107:
1108: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1109: ROLLBACK TO check_sel_securitized_pvt;
1110: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1111: Fnd_Msg_Pub.Count_And_Get
1112: (p_count => x_msg_count,

Line 1110: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1106: p_data => x_msg_data);
1107:
1108: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1109: ROLLBACK TO check_sel_securitized_pvt;
1110: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1111: Fnd_Msg_Pub.Count_And_Get
1112: (p_count => x_msg_count,
1113: p_data => x_msg_data);
1114:

Line 1117: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

1113: p_data => x_msg_data);
1114:
1115: WHEN OTHERS THEN
1116: ROLLBACK TO check_sel_securitized_pvt;
1117: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1118: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1119: p_msg_name => G_UNEXPECTED_ERROR,
1120: p_token1 => G_SQLCODE_TOKEN,
1121: p_token1_value => SQLCODE,

Line 1118: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

1114:
1115: WHEN OTHERS THEN
1116: ROLLBACK TO check_sel_securitized_pvt;
1117: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1118: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1119: p_msg_name => G_UNEXPECTED_ERROR,
1120: p_token1 => G_SQLCODE_TOKEN,
1121: p_token1_value => SQLCODE,
1122: p_token2 => G_SQLERRM_TOKEN,

Line 1142: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

1138: -- End of comments
1139: ----------------------------------------------------------------------------------
1140: PROCEDURE check_khr_ia_associated(
1141: p_api_version IN NUMBER
1142: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
1143: ,x_return_status OUT NOCOPY VARCHAR2
1144: ,x_msg_count OUT NOCOPY NUMBER
1145: ,x_msg_data OUT NOCOPY VARCHAR2
1146: ,p_khr_id IN NUMBER

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

1152: IS
1153: l_api_name CONSTANT VARCHAR2(30) := 'check_khr_ia_associated';
1154: l_api_version CONSTANT NUMBER := 1.0;
1155: i NUMBER;
1156: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1157: l_trx_date DATE; -- cklee fixed bug: 7017824(R12)/OKL.H bug#6964174
1158:
1159: CURSOR investor_code (p_ia_chr_id IN NUMBER) IS
1160: SELECT rule_information1

Line 1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1228: p_api_version,
1229: l_api_name,
1230: G_PKG_NAME ))
1231: THEN
1232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1233: END IF;
1234:
1235: -- Initialize message list if requested
1236: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 1241: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1237: Fnd_Msg_Pub.initialize;
1238: END IF;
1239:
1240: -- Initialize API status to success
1241: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1242:
1243: /*** Begin API body ****************************************************/
1244:
1245: -- scs_code is INVESTOR, return null

Line 1333: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1329: (p_count => x_msg_count,
1330: p_data => x_msg_data);
1331:
1332: EXCEPTION
1333: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1334: ROLLBACK TO check_khr_ia_associated_pvt;
1335: x_return_status := Okl_Api.G_RET_STS_ERROR;
1336: Fnd_Msg_Pub.Count_And_Get
1337: (p_count => x_msg_count,

Line 1335: x_return_status := Okl_Api.G_RET_STS_ERROR;

1331:
1332: EXCEPTION
1333: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1334: ROLLBACK TO check_khr_ia_associated_pvt;
1335: x_return_status := Okl_Api.G_RET_STS_ERROR;
1336: Fnd_Msg_Pub.Count_And_Get
1337: (p_count => x_msg_count,
1338: p_data => x_msg_data);
1339:

Line 1340: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1336: Fnd_Msg_Pub.Count_And_Get
1337: (p_count => x_msg_count,
1338: p_data => x_msg_data);
1339:
1340: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: ROLLBACK TO check_khr_ia_associated_pvt;
1342: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1343: Fnd_Msg_Pub.Count_And_Get
1344: (p_count => x_msg_count,

Line 1342: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1338: p_data => x_msg_data);
1339:
1340: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341: ROLLBACK TO check_khr_ia_associated_pvt;
1342: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1343: Fnd_Msg_Pub.Count_And_Get
1344: (p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:

Line 1349: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

1345: p_data => x_msg_data);
1346:
1347: WHEN OTHERS THEN
1348: ROLLBACK TO check_khr_ia_associated_pvt;
1349: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1350: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1351: p_msg_name => G_UNEXPECTED_ERROR,
1352: p_token1 => G_SQLCODE_TOKEN,
1353: p_token1_value => SQLCODE,

Line 1350: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

1346:
1347: WHEN OTHERS THEN
1348: ROLLBACK TO check_khr_ia_associated_pvt;
1349: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1350: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1351: p_msg_name => G_UNEXPECTED_ERROR,
1352: p_token1 => G_SQLCODE_TOKEN,
1353: p_token1_value => SQLCODE,
1354: p_token2 => G_SQLERRM_TOKEN,

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

1437: IS
1438: l_api_name CONSTANT VARCHAR2(30) := 'process_khr_investor_rules';
1439: l_api_version CONSTANT NUMBER := 1.0;
1440: i NUMBER;
1441: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1442:
1443: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;
1444: l_action NUMBER;
1445:

Line 1443: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;

1439: l_api_version CONSTANT NUMBER := 1.0;
1440: i NUMBER;
1441: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1442:
1443: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;
1444: l_action NUMBER;
1445:
1446: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1447: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,

Line 1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1495: p_api_version,
1496: l_api_name,
1497: G_PKG_NAME ))
1498: THEN
1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1500: END IF;
1501:
1502: -- Initialize message list if requested
1503: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 1508: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1504: Fnd_Msg_Pub.initialize;
1505: END IF;
1506:
1507: -- Initialize API status to success
1508: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1509:
1510:
1511: /*** Begin API body ****************************************************/
1512: /*

Line 1528: IF l_flag = Okl_Api.G_TRUE THEN

1524: -- 1. get flag
1525: l_flag := is_khr_securitized(p_khr_id => p_khr_id
1526: ,p_effective_date => p_effective_date);
1527:
1528: IF l_flag = Okl_Api.G_TRUE THEN
1529:
1530: OPEN c_action(p_rgd_code
1531: ,NVL(p_rdf_code, G_PROCESS_RULE_CODE)
1532:

Line 1550: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1546: x_msg_data => x_msg_data,
1547: p_khr_id => p_khr_id,
1548: p_effective_date => p_effective_date);
1549:
1550: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1553: RAISE Okl_Api.G_EXCEPTION_ERROR;
1554: END IF;

Line 1551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1547: p_khr_id => p_khr_id,
1548: p_effective_date => p_effective_date);
1549:
1550: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1553: RAISE Okl_Api.G_EXCEPTION_ERROR;
1554: END IF;
1555: -- set message

Line 1552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1548: p_effective_date => p_effective_date);
1549:
1550: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1553: RAISE Okl_Api.G_EXCEPTION_ERROR;
1554: END IF;
1555: -- set message
1556:

Line 1553: RAISE Okl_Api.G_EXCEPTION_ERROR;

1549:
1550: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1553: RAISE Okl_Api.G_EXCEPTION_ERROR;
1554: END IF;
1555: -- set message
1556:
1557: ELSIF l_action = G_PRIORITY_1 THEN

Line 1559: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

1555: -- set message
1556:
1557: ELSIF l_action = G_PRIORITY_1 THEN
1558: x_process_code := G_PROCESS_NOT_ALLOWED;
1559: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1560: p_msg_name => 'OKL_LLA_BUYBACK_NOT_ALLOWED');
1561:
1562: END IF;
1563:

Line 1592: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1588: (p_count => x_msg_count,
1589: p_data => x_msg_data);
1590:
1591: EXCEPTION
1592: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1593: ROLLBACK TO process_khr_investor_rules;
1594: x_return_status := Okl_Api.G_RET_STS_ERROR;
1595: Fnd_Msg_Pub.Count_And_Get
1596: (p_count => x_msg_count,

Line 1594: x_return_status := Okl_Api.G_RET_STS_ERROR;

1590:
1591: EXCEPTION
1592: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1593: ROLLBACK TO process_khr_investor_rules;
1594: x_return_status := Okl_Api.G_RET_STS_ERROR;
1595: Fnd_Msg_Pub.Count_And_Get
1596: (p_count => x_msg_count,
1597: p_data => x_msg_data);
1598:

Line 1599: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1595: Fnd_Msg_Pub.Count_And_Get
1596: (p_count => x_msg_count,
1597: p_data => x_msg_data);
1598:
1599: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO process_khr_investor_rules;
1601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1602: Fnd_Msg_Pub.Count_And_Get
1603: (p_count => x_msg_count,

Line 1601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1597: p_data => x_msg_data);
1598:
1599: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO process_khr_investor_rules;
1601: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1602: Fnd_Msg_Pub.Count_And_Get
1603: (p_count => x_msg_count,
1604: p_data => x_msg_data);
1605:

Line 1608: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

1604: p_data => x_msg_data);
1605:
1606: WHEN OTHERS THEN
1607: ROLLBACK TO process_khr_investor_rules;
1608: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1609: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1610: p_msg_name => G_UNEXPECTED_ERROR,
1611: p_token1 => G_SQLCODE_TOKEN,
1612: p_token1_value => SQLCODE,

Line 1609: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

1605:
1606: WHEN OTHERS THEN
1607: ROLLBACK TO process_khr_investor_rules;
1608: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1609: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1610: p_msg_name => G_UNEXPECTED_ERROR,
1611: p_token1 => G_SQLCODE_TOKEN,
1612: p_token1_value => SQLCODE,
1613: p_token2 => G_SQLERRM_TOKEN,

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

1646: IS
1647: l_api_name CONSTANT VARCHAR2(30) := 'process_kle_investor_rules';
1648: l_api_version CONSTANT NUMBER := 1.0;
1649: i NUMBER;
1650: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1651:
1652: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;
1653: l_action NUMBER;
1654:

Line 1652: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;

1648: l_api_version CONSTANT NUMBER := 1.0;
1649: i NUMBER;
1650: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1651:
1652: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;
1653: l_action NUMBER;
1654:
1655: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1656: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,

Line 1709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1705: p_api_version,
1706: l_api_name,
1707: G_PKG_NAME ))
1708: THEN
1709: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1710: END IF;
1711:
1712: -- Initialize message list if requested
1713: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN

Line 1719: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1715: END IF;
1716:
1717:
1718: -- Initialize API status to success
1719: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1720:
1721:
1722: /*** Begin API body ****************************************************/
1723: /*

Line 1739: IF l_flag = Okl_Api.G_TRUE THEN

1735: -- 1. get flag
1736: l_flag := is_kle_securitized(p_kle_id => p_kle_id
1737: ,p_effective_date => p_effective_date);
1738:
1739: IF l_flag = Okl_Api.G_TRUE THEN
1740:
1741: OPEN c_action(p_rgd_code
1742: ,NVL(p_rdf_code, G_PROCESS_RULE_CODE)
1743: ,p_kle_id);

Line 1760: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1756: x_msg_data => x_msg_data,
1757: p_kle_id => p_kle_id,
1758: p_effective_date => p_effective_date);
1759:
1760: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1761: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1762: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1763: RAISE Okl_Api.G_EXCEPTION_ERROR;
1764: END IF;

Line 1761: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1757: p_kle_id => p_kle_id,
1758: p_effective_date => p_effective_date);
1759:
1760: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1761: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1762: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1763: RAISE Okl_Api.G_EXCEPTION_ERROR;
1764: END IF;
1765: -- set message

Line 1762: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1758: p_effective_date => p_effective_date);
1759:
1760: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1761: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1762: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1763: RAISE Okl_Api.G_EXCEPTION_ERROR;
1764: END IF;
1765: -- set message
1766:

Line 1763: RAISE Okl_Api.G_EXCEPTION_ERROR;

1759:
1760: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1761: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1762: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1763: RAISE Okl_Api.G_EXCEPTION_ERROR;
1764: END IF;
1765: -- set message
1766:
1767: ELSIF l_action = G_PRIORITY_1 THEN

Line 1769: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

1765: -- set message
1766:
1767: ELSIF l_action = G_PRIORITY_1 THEN
1768: x_process_code := G_PROCESS_NOT_ALLOWED;
1769: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1770: p_msg_name => 'OKL_LLA_BUYBACK_NOT_ALLOWED');
1771:
1772: END IF;
1773:

Line 1800: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1796: (p_count => x_msg_count,
1797: p_data => x_msg_data);
1798:
1799: EXCEPTION
1800: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1801: ROLLBACK TO process_kle_investor_rules;
1802: x_return_status := Okl_Api.G_RET_STS_ERROR;
1803: Fnd_Msg_Pub.Count_And_Get
1804: (p_count => x_msg_count,

Line 1802: x_return_status := Okl_Api.G_RET_STS_ERROR;

1798:
1799: EXCEPTION
1800: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1801: ROLLBACK TO process_kle_investor_rules;
1802: x_return_status := Okl_Api.G_RET_STS_ERROR;
1803: Fnd_Msg_Pub.Count_And_Get
1804: (p_count => x_msg_count,
1805: p_data => x_msg_data);
1806:

Line 1807: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1803: Fnd_Msg_Pub.Count_And_Get
1804: (p_count => x_msg_count,
1805: p_data => x_msg_data);
1806:
1807: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1808: ROLLBACK TO process_kle_investor_rules;
1809: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1810: Fnd_Msg_Pub.Count_And_Get
1811: (p_count => x_msg_count,

Line 1809: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1805: p_data => x_msg_data);
1806:
1807: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1808: ROLLBACK TO process_kle_investor_rules;
1809: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1810: Fnd_Msg_Pub.Count_And_Get
1811: (p_count => x_msg_count,
1812: p_data => x_msg_data);
1813:

Line 1816: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;

1812: p_data => x_msg_data);
1813:
1814: WHEN OTHERS THEN
1815: ROLLBACK TO process_kle_investor_rules;
1816: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1817: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1818: p_msg_name => G_UNEXPECTED_ERROR,
1819: p_token1 => G_SQLCODE_TOKEN,
1820: p_token1_value => SQLCODE,

Line 1817: Okl_Api.Set_Message(p_app_name => G_APP_NAME,

1813:
1814: WHEN OTHERS THEN
1815: ROLLBACK TO process_kle_investor_rules;
1816: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR ;
1817: Okl_Api.Set_Message(p_app_name => G_APP_NAME,
1818: p_msg_name => G_UNEXPECTED_ERROR,
1819: p_token1 => G_SQLCODE_TOKEN,
1820: p_token1_value => SQLCODE,
1821: p_token2 => G_SQLERRM_TOKEN,

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

1849: AND styb.stream_type_subclass = p_stream_type_subclass;
1850:
1851: l_api_name CONSTANT VARCHAR2(30) := 'buyback_streams';
1852: l_api_version CONSTANT NUMBER := 1.0;
1853: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1854:
1855: BEGIN
1856:
1857: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

Line 1857: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1853: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1854:
1855: BEGIN
1856:
1857: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1858: p_pkg_name => G_PKG_NAME,
1859: p_init_msg_list => p_init_msg_list,
1860: l_api_version => l_api_version,
1861: p_api_version => p_api_version,

Line 1889: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

1885: END IF;
1886:
1887: END LOOP; -- l_okl_poc_csr
1888:
1889: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
1890: ,x_msg_data => x_msg_data);
1891:
1892: x_return_status := l_return_status;
1893:

Line 1898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1894:
1895: EXCEPTION
1896: WHEN G_EXCEPTION_ERROR THEN
1897:
1898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1899: p_pkg_name => G_PKG_NAME,
1900: p_exc_name => G_EXC_NAME_ERROR,
1901: x_msg_count => x_msg_count,
1902: x_msg_data => x_msg_data,

Line 1907: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1903: p_api_type => G_API_TYPE);
1904:
1905: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1906:
1907: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1908: p_pkg_name => G_PKG_NAME,
1909: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1910: x_msg_count => x_msg_count,
1911: x_msg_data => x_msg_data,

Line 1915: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1911: x_msg_data => x_msg_data,
1912: p_api_type => G_API_TYPE);
1913: WHEN OTHERS THEN
1914:
1915: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1916: p_pkg_name => G_PKG_NAME,
1917: p_exc_name => G_EXC_NAME_OTHERS,
1918: x_msg_count => x_msg_count,
1919: x_msg_data => x_msg_data,

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

1964: lp_add_parameters okl_execute_formula_pub.ctxt_val_tbl_type;
1965:
1966: l_api_name CONSTANT VARCHAR2(30) := 'calculate_buyback_content';
1967: l_api_version CONSTANT NUMBER := 1.0;
1968: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1969:
1970: BEGIN
1971: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1972: p_pkg_name => G_PKG_NAME,

Line 1971: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1967: l_api_version CONSTANT NUMBER := 1.0;
1968: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1969:
1970: BEGIN
1971: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1972: p_pkg_name => G_PKG_NAME,
1973: p_init_msg_list => p_init_msg_list,
1974: l_api_version => l_api_version,
1975: p_api_version => p_api_version,

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

2001: ,p_additional_parameters => lp_add_parameters
2002: ,x_value => x_buyback_amount);
2003:
2004:
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;

Line 2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2002: ,x_value => x_buyback_amount);
2003:
2004:
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010:

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

2003:
2004:
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010:
2011: END LOOP; --l_okl_poc_formula_rec

Line 2008: RAISE OKL_API.G_EXCEPTION_ERROR;

2004:
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010:
2011: END LOOP; --l_okl_poc_formula_rec
2012:

Line 2013: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

2009: END IF;
2010:
2011: END LOOP; --l_okl_poc_formula_rec
2012:
2013: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
2014: ,x_msg_data => x_msg_data);
2015:
2016: x_return_status := l_return_status;
2017:

Line 2021: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2017:
2018: EXCEPTION
2019: WHEN G_EXCEPTION_ERROR THEN
2020:
2021: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2022: p_pkg_name => G_PKG_NAME,
2023: p_exc_name => G_EXC_NAME_ERROR,
2024: x_msg_count => x_msg_count,
2025: x_msg_data => x_msg_data,

Line 2029: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2025: x_msg_data => x_msg_data,
2026: p_api_type => G_API_TYPE);
2027: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2028:
2029: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2030: p_pkg_name => G_PKG_NAME,
2031: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2032: x_msg_count => x_msg_count,
2033: x_msg_data => x_msg_data,

Line 2037: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2033: x_msg_data => x_msg_data,
2034: p_api_type => G_API_TYPE);
2035: WHEN OTHERS THEN
2036:
2037: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2038: p_pkg_name => G_PKG_NAME,
2039: p_exc_name => G_EXC_NAME_OTHERS,
2040: x_msg_count => x_msg_count,
2041: x_msg_data => x_msg_data,

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

2121: AND kleb.sty_id = p_sty_id;
2122:
2123: l_api_name CONSTANT VARCHAR2(30) := 'calculate_buyback_amount';
2124: l_api_version CONSTANT NUMBER := 1.0;
2125: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2126:
2127: lp_add_parameters Okl_Execute_Formula_Pub.ctxt_val_tbl_type;
2128: lx_buyback_amount NUMBER := 0;
2129: l_amount NUMBER := 0;

Line 2135: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

2131: l_formula VARCHAR2(450);
2132:
2133: BEGIN
2134:
2135: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
2136: p_pkg_name => G_PKG_NAME,
2137: p_init_msg_list => p_init_msg_list,
2138: l_api_version => l_api_version,
2139: p_api_version => p_api_version,

Line 2176: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2172: ,p_line_id => l_okl_poc_rec.kle_id
2173: ,p_additional_parameters => lp_add_parameters
2174: ,x_value => l_amount);
2175:
2176: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;

Line 2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2173: ,p_additional_parameters => lp_add_parameters
2174: ,x_value => l_amount);
2175:
2176: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;
2181:

Line 2178: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2174: ,x_value => l_amount);
2175:
2176: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: -- calculate the revenue share for each sty

Line 2179: RAISE Okl_Api.G_EXCEPTION_ERROR;

2175:
2176: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: -- calculate the revenue share for each sty
2183: FOR l_okl_rev_shares_rec IN l_okl_rev_shares_csr(l_okl_poc_rec.khr_id,l_okl_poc_rec.sty_id)

Line 2198: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

2194: END LOOP; -- l_okl_pol_csr
2195:
2196: x_buyback_amount := lx_buyback_amount;
2197:
2198: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
2199: ,x_msg_data => x_msg_data);
2200:
2201: x_return_status := l_return_status;
2202:

Line 2207: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2203:
2204: EXCEPTION
2205: WHEN G_EXCEPTION_ERROR THEN
2206:
2207: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2208: p_pkg_name => G_PKG_NAME,
2209: p_exc_name => G_EXC_NAME_ERROR,
2210: x_msg_count => x_msg_count,
2211: x_msg_data => x_msg_data,

Line 2216: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2212: p_api_type => G_API_TYPE);
2213:
2214: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2215:
2216: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2217: p_pkg_name => G_PKG_NAME,
2218: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2219: x_msg_count => x_msg_count,
2220: x_msg_data => x_msg_data,

Line 2224: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2220: x_msg_data => x_msg_data,
2221: p_api_type => G_API_TYPE);
2222: WHEN OTHERS THEN
2223:
2224: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2225: p_pkg_name => G_PKG_NAME,
2226: p_exc_name => G_EXC_NAME_OTHERS,
2227: x_msg_count => x_msg_count,
2228: x_msg_data => x_msg_data,

Line 2246: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

2242: -- End of comments
2243: ----------------------------------------------------------------------------------
2244: PROCEDURE adjust_pool_contents(
2245: p_api_version IN NUMBER
2246: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
2247: ,x_return_status OUT NOCOPY VARCHAR2
2248: ,x_msg_count OUT NOCOPY NUMBER
2249: ,x_msg_data OUT NOCOPY VARCHAR2
2250: ,p_poxv_rec IN poxv_rec_type

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

2297:
2298: l_api_name CONSTANT VARCHAR2(30) := 'adjust_pool_contents';
2299: l_api_version CONSTANT NUMBER := 1.0;
2300: i NUMBER;
2301: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2302:
2303: lp_poxv_rec poxv_rec_type;
2304: lx_poxv_rec poxv_rec_type;
2305: lp_pocv_rec pocv_rec_type;

Line 2317: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

2313: l_rv_date_updated BOOLEAN := FALSE;
2314:
2315: BEGIN
2316:
2317: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
2318: p_pkg_name => G_PKG_NAME,
2319: p_init_msg_list => p_init_msg_list,
2320: l_api_version => l_api_version,
2321: p_api_version => p_api_version,

Line 2339: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2335: ,x_msg_data => x_msg_data
2336: ,p_poxv_rec => lp_poxv_rec
2337: ,x_poxv_rec => lx_poxv_rec);
2338:
2339: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2342: RAISE Okl_Api.G_EXCEPTION_ERROR;
2343: END IF;

Line 2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2336: ,p_poxv_rec => lp_poxv_rec
2337: ,x_poxv_rec => lx_poxv_rec);
2338:
2339: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2342: RAISE Okl_Api.G_EXCEPTION_ERROR;
2343: END IF;
2344:

Line 2341: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2337: ,x_poxv_rec => lx_poxv_rec);
2338:
2339: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2342: RAISE Okl_Api.G_EXCEPTION_ERROR;
2343: END IF;
2344:
2345: -- Inactivate the corresponding pool contents with this transaction_number OUT

Line 2342: RAISE Okl_Api.G_EXCEPTION_ERROR;

2338:
2339: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2341: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2342: RAISE Okl_Api.G_EXCEPTION_ERROR;
2343: END IF;
2344:
2345: -- Inactivate the corresponding pool contents with this transaction_number OUT
2346: FOR l_okl_poc_rec IN l_okl_poc_csr(p_poxv_rec.pol_id)

Line 2388: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2384: ,p_pocv_rec => lp_pocv_rec
2385: ,x_pocv_rec => lx_pocv_rec);
2386:
2387:
2388: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2391: RAISE Okl_Api.G_EXCEPTION_ERROR;
2392: END IF;

Line 2389: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2385: ,x_pocv_rec => lx_pocv_rec);
2386:
2387:
2388: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2391: RAISE Okl_Api.G_EXCEPTION_ERROR;
2392: END IF;
2393:

Line 2390: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2386:
2387:
2388: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2391: RAISE Okl_Api.G_EXCEPTION_ERROR;
2392: END IF;
2393:
2394: IF ( lp_poxv_rec.transaction_reason = G_TRX_REASON_CONTRACT_REBOOK

Line 2391: RAISE Okl_Api.G_EXCEPTION_ERROR;

2387:
2388: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2391: RAISE Okl_Api.G_EXCEPTION_ERROR;
2392: END IF;
2393:
2394: IF ( lp_poxv_rec.transaction_reason = G_TRX_REASON_CONTRACT_REBOOK
2395: OR lp_poxv_rec.transaction_reason = G_TRX_REASON_ASSET_SPLIT)

Line 2468: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2464: ,x_msg_data => x_msg_data
2465: ,p_pocv_rec => lp_pocv_rec_cre
2466: ,x_pocv_rec => lx_pocv_rec);
2467:
2468: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2471: RAISE Okl_Api.G_EXCEPTION_ERROR;
2472: END IF;

Line 2469: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2465: ,p_pocv_rec => lp_pocv_rec_cre
2466: ,x_pocv_rec => lx_pocv_rec);
2467:
2468: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2471: RAISE Okl_Api.G_EXCEPTION_ERROR;
2472: END IF;
2473:

Line 2470: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2466: ,x_pocv_rec => lx_pocv_rec);
2467:
2468: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2471: RAISE Okl_Api.G_EXCEPTION_ERROR;
2472: END IF;
2473:
2474: -- Update Status => "Active"

Line 2471: RAISE Okl_Api.G_EXCEPTION_ERROR;

2467:
2468: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2471: RAISE Okl_Api.G_EXCEPTION_ERROR;
2472: END IF;
2473:
2474: -- Update Status => "Active"
2475: lp_pocv_rec_upd.id := lx_pocv_rec.id;

Line 2488: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2484: ,x_msg_data => x_msg_data
2485: ,p_pocv_rec => lp_pocv_rec_upd
2486: ,x_pocv_rec => lx_pocv_rec);
2487:
2488: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2490: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2491: RAISE Okl_Api.G_EXCEPTION_ERROR;
2492: END IF;

Line 2489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2485: ,p_pocv_rec => lp_pocv_rec_upd
2486: ,x_pocv_rec => lx_pocv_rec);
2487:
2488: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2490: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2491: RAISE Okl_Api.G_EXCEPTION_ERROR;
2492: END IF;
2493:

Line 2490: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2486: ,x_pocv_rec => lx_pocv_rec);
2487:
2488: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2490: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2491: RAISE Okl_Api.G_EXCEPTION_ERROR;
2492: END IF;
2493:
2494: END IF; -- l_create

Line 2491: RAISE Okl_Api.G_EXCEPTION_ERROR;

2487:
2488: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2490: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2491: RAISE Okl_Api.G_EXCEPTION_ERROR;
2492: END IF;
2493:
2494: END IF; -- l_create
2495:

Line 2498: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

2494: END IF; -- l_create
2495:
2496: END LOOP; -- l_okl_poc_rec
2497:
2498: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
2499: ,x_msg_data => x_msg_data);
2500:
2501: x_return_status := l_return_status;
2502:

Line 2505: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2501: x_return_status := l_return_status;
2502:
2503: EXCEPTION
2504: WHEN G_EXCEPTION_ERROR THEN
2505: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2506: p_pkg_name => G_PKG_NAME,
2507: p_exc_name => G_EXC_NAME_ERROR,
2508: x_msg_count => x_msg_count,
2509: x_msg_data => x_msg_data,

Line 2513: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2509: x_msg_data => x_msg_data,
2510: p_api_type => G_API_TYPE);
2511:
2512: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2513: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2514: p_pkg_name => G_PKG_NAME,
2515: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2516: x_msg_count => x_msg_count,
2517: x_msg_data => x_msg_data,

Line 2520: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2516: x_msg_count => x_msg_count,
2517: x_msg_data => x_msg_data,
2518: p_api_type => G_API_TYPE);
2519: WHEN OTHERS THEN
2520: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2521: p_pkg_name => G_PKG_NAME,
2522: p_exc_name => G_EXC_NAME_OTHERS,
2523: x_msg_count => x_msg_count,
2524: x_msg_data => x_msg_data,

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

2583: -- end ankushar Legal Entity changes
2584:
2585: l_api_name CONSTANT VARCHAR2(30) := 'modify_pool_contents';
2586: l_api_version CONSTANT NUMBER := 1.0;
2587: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2588:
2589:
2590: lp_pocv_rec pocv_rec_type;
2591: lx_pocv_rec pocv_rec_type;

Line 2605: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

2601: -- end ankushar Legal Entity changes
2602:
2603: BEGIN
2604:
2605: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
2606: p_pkg_name => G_PKG_NAME,
2607: p_init_msg_list => p_init_msg_list,
2608: l_api_version => l_api_version,
2609: p_api_version => p_api_version,

Line 2662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2658: ,p_stream_type_subclass => p_stream_type_subclass
2659: -- mvasudev, 02/06/2004
2660: ,p_streams_to_date => l_okl_khr_rec.end_date+1);
2661:
2662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2665: RAISE Okl_Api.G_EXCEPTION_ERROR;
2666: END IF;

Line 2663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2659: -- mvasudev, 02/06/2004
2660: ,p_streams_to_date => l_okl_khr_rec.end_date+1);
2661:
2662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2665: RAISE Okl_Api.G_EXCEPTION_ERROR;
2666: END IF;
2667:

Line 2664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2660: ,p_streams_to_date => l_okl_khr_rec.end_date+1);
2661:
2662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2665: RAISE Okl_Api.G_EXCEPTION_ERROR;
2666: END IF;
2667:
2668: END LOOP; -- l_okl_khr_csr

Line 2665: RAISE Okl_Api.G_EXCEPTION_ERROR;

2661:
2662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2665: RAISE Okl_Api.G_EXCEPTION_ERROR;
2666: END IF;
2667:
2668: END LOOP; -- l_okl_khr_csr
2669:

Line 2706: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2702: ,p_kle_id => p_kle_id
2703: ,p_stream_type_subclass => p_stream_type_subclass
2704: ,p_streams_to_date => p_effective_date);
2705:
2706: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2708: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2709: RAISE Okl_Api.G_EXCEPTION_ERROR;
2710: END IF;

Line 2707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2703: ,p_stream_type_subclass => p_stream_type_subclass
2704: ,p_streams_to_date => p_effective_date);
2705:
2706: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2708: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2709: RAISE Okl_Api.G_EXCEPTION_ERROR;
2710: END IF;
2711:

Line 2708: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2704: ,p_streams_to_date => p_effective_date);
2705:
2706: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2708: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2709: RAISE Okl_Api.G_EXCEPTION_ERROR;
2710: END IF;
2711:
2712: END LOOP ; --l_okl_pol_csr

Line 2709: RAISE Okl_Api.G_EXCEPTION_ERROR;

2705:
2706: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2707: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2708: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2709: RAISE Okl_Api.G_EXCEPTION_ERROR;
2710: END IF;
2711:
2712: END LOOP ; --l_okl_pol_csr
2713: ELSIF (p_transaction_reason = G_TRX_REASON_ASSET_TERMINATION) THEN

Line 2748: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2744: ,p_kle_id => p_kle_id
2745: ,p_stream_type_subclass => p_stream_type_subclass
2746: ,p_streams_to_date => p_effective_date);
2747:
2748: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2750: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_ERROR;
2752: END IF;

Line 2749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2745: ,p_stream_type_subclass => p_stream_type_subclass
2746: ,p_streams_to_date => p_effective_date);
2747:
2748: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2750: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_ERROR;
2752: END IF;
2753:

Line 2750: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2746: ,p_streams_to_date => p_effective_date);
2747:
2748: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2750: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_ERROR;
2752: END IF;
2753:
2754: END LOOP ; --l_okl_pol_csr

Line 2751: RAISE Okl_Api.G_EXCEPTION_ERROR;

2747:
2748: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2749: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2750: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_ERROR;
2752: END IF;
2753:
2754: END LOOP ; --l_okl_pol_csr
2755: ELSE

Line 2756: RAISE Okl_Api.G_EXCEPTION_ERROR;

2752: END IF;
2753:
2754: END LOOP ; --l_okl_pol_csr
2755: ELSE
2756: RAISE Okl_Api.G_EXCEPTION_ERROR;
2757: END IF;
2758: ELSIF(p_transaction_reason = G_TRX_REASON_ASSET_DISPOSAL OR
2759: p_transaction_reason = G_TRX_REASON_PURCHASE OR
2760: p_transaction_reason = G_TRX_REASON_REPURCHASE OR

Line 2769: RAISE Okl_Api.G_EXCEPTION_ERROR;

2765: -- These are residual value streams
2766: --
2767: IF (p_transaction_reason = G_TRX_REASON_ASSET_DISPOSAL
2768: AND p_kle_id IS NULL) THEN
2769: RAISE Okl_Api.G_EXCEPTION_ERROR;
2770: END IF;
2771:
2772: IF(p_effective_date IS NULL) THEN
2773: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2773: RAISE Okl_Api.G_EXCEPTION_ERROR;

2769: RAISE Okl_Api.G_EXCEPTION_ERROR;
2770: END IF;
2771:
2772: IF(p_effective_date IS NULL) THEN
2773: RAISE Okl_Api.G_EXCEPTION_ERROR;
2774: ELSE
2775: FOR l_okl_pol_rec IN l_okl_pol_csr
2776: LOOP
2777:

Line 2810: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2806: ,p_stream_type_subclass => p_stream_type_subclass
2807: -- mvasudev, 02/06/2004
2808: ,p_streams_to_date => l_okl_khr_rec.end_date+1);
2809:
2810: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2811: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2812: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2813: RAISE Okl_Api.G_EXCEPTION_ERROR;
2814: END IF;

Line 2811: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2807: -- mvasudev, 02/06/2004
2808: ,p_streams_to_date => l_okl_khr_rec.end_date+1);
2809:
2810: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2811: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2812: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2813: RAISE Okl_Api.G_EXCEPTION_ERROR;
2814: END IF;
2815: END LOOP;

Line 2812: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2808: ,p_streams_to_date => l_okl_khr_rec.end_date+1);
2809:
2810: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2811: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2812: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2813: RAISE Okl_Api.G_EXCEPTION_ERROR;
2814: END IF;
2815: END LOOP;
2816:

Line 2813: RAISE Okl_Api.G_EXCEPTION_ERROR;

2809:
2810: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2811: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2812: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2813: RAISE Okl_Api.G_EXCEPTION_ERROR;
2814: END IF;
2815: END LOOP;
2816:
2817: END LOOP ; --l_okl_pol_csr

Line 2824: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

2820:
2821: END IF; -- p_transaction_reason
2822:
2823:
2824: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
2825: ,x_msg_data => x_msg_data);
2826:
2827: x_return_status := l_return_status;
2828:

Line 2832: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2828:
2829:
2830: EXCEPTION
2831: WHEN G_EXCEPTION_ERROR THEN
2832: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2833: p_pkg_name => G_PKG_NAME,
2834: p_exc_name => G_EXC_NAME_ERROR,
2835: x_msg_count => x_msg_count,
2836: x_msg_data => x_msg_data,

Line 2840: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2836: x_msg_data => x_msg_data,
2837: p_api_type => G_API_TYPE);
2838:
2839: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2840: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2841: p_pkg_name => G_PKG_NAME,
2842: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2843: x_msg_count => x_msg_count,
2844: x_msg_data => x_msg_data,

Line 2847: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2843: x_msg_count => x_msg_count,
2844: x_msg_data => x_msg_data,
2845: p_api_type => G_API_TYPE);
2846: WHEN OTHERS THEN
2847: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2848: p_pkg_name => G_PKG_NAME,
2849: p_exc_name => G_EXC_NAME_OTHERS,
2850: x_msg_count => x_msg_count,
2851: x_msg_data => x_msg_data,

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

2925: -- end ankushar Legal Entity Changes
2926:
2927: l_api_name CONSTANT VARCHAR2(30) := 'modify_pool_contents';
2928: l_api_version CONSTANT NUMBER := 1.0;
2929: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2930:
2931: -- begin ankushar 29-11-2006 Legal Entity Changes
2932: -- Attribute to store legal_entity_id
2933: lp_legal_entity_id NUMBER;

Line 2948: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

2944:
2945:
2946: BEGIN
2947:
2948: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
2949: p_pkg_name => G_PKG_NAME,
2950: p_init_msg_list => p_init_msg_list,
2951: l_api_version => l_api_version,
2952: p_api_version => p_api_version,

Line 2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2990: ,x_msg_data => x_msg_data
2991: ,p_poxv_rec => lp_poxv_rec
2992: ,x_poxv_rec => lx_poxv_rec);
2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;

Line 2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2991: ,p_poxv_rec => lp_poxv_rec
2992: ,x_poxv_rec => lx_poxv_rec);
2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:

Line 2996: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2992: ,x_poxv_rec => lx_poxv_rec);
2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:
3000: FOR l_okl_poc_rec IN l_okl_poc_csr(l_okl_pol_rec.pol_id)

Line 2997: RAISE Okl_Api.G_EXCEPTION_ERROR;

2993:
2994: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okl_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999:
3000: FOR l_okl_poc_rec IN l_okl_poc_csr(l_okl_pol_rec.pol_id)
3001: LOOP

Line 3017: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3013: ,x_msg_data => x_msg_data
3014: ,p_pocv_rec => lp_pocv_rec
3015: ,x_pocv_rec => lx_pocv_rec);
3016:
3017: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3018: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3019: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3020: RAISE Okl_Api.G_EXCEPTION_ERROR;
3021: END IF;

Line 3018: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3014: ,p_pocv_rec => lp_pocv_rec
3015: ,x_pocv_rec => lx_pocv_rec);
3016:
3017: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3018: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3019: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3020: RAISE Okl_Api.G_EXCEPTION_ERROR;
3021: END IF;
3022:

Line 3019: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3015: ,x_pocv_rec => lx_pocv_rec);
3016:
3017: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3018: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3019: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3020: RAISE Okl_Api.G_EXCEPTION_ERROR;
3021: END IF;
3022:
3023: FOR i IN 1..p_split_kle_ids.COUNT

Line 3020: RAISE Okl_Api.G_EXCEPTION_ERROR;

3016:
3017: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3018: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3019: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3020: RAISE Okl_Api.G_EXCEPTION_ERROR;
3021: END IF;
3022:
3023: FOR i IN 1..p_split_kle_ids.COUNT
3024: LOOP

Line 3056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3052: ,x_msg_data => x_msg_data
3053: ,p_pocv_rec => lp_pocv_rec_cre
3054: ,x_pocv_rec => lx_pocv_rec);
3055:
3056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3059: RAISE Okl_Api.G_EXCEPTION_ERROR;
3060: END IF;

Line 3057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3053: ,p_pocv_rec => lp_pocv_rec_cre
3054: ,x_pocv_rec => lx_pocv_rec);
3055:
3056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3059: RAISE Okl_Api.G_EXCEPTION_ERROR;
3060: END IF;
3061:

Line 3058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3054: ,x_pocv_rec => lx_pocv_rec);
3055:
3056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3059: RAISE Okl_Api.G_EXCEPTION_ERROR;
3060: END IF;
3061:
3062: -- Update Status => "Active"

Line 3059: RAISE Okl_Api.G_EXCEPTION_ERROR;

3055:
3056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3059: RAISE Okl_Api.G_EXCEPTION_ERROR;
3060: END IF;
3061:
3062: -- Update Status => "Active"
3063: lp_pocv_rec_upd.id := lx_pocv_rec.id;

Line 3076: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3072: ,x_msg_data => x_msg_data
3073: ,p_pocv_rec => lp_pocv_rec_upd
3074: ,x_pocv_rec => lx_pocv_rec);
3075:
3076: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3077: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3078: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3079: RAISE Okl_Api.G_EXCEPTION_ERROR;
3080: END IF;

Line 3077: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3073: ,p_pocv_rec => lp_pocv_rec_upd
3074: ,x_pocv_rec => lx_pocv_rec);
3075:
3076: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3077: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3078: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3079: RAISE Okl_Api.G_EXCEPTION_ERROR;
3080: END IF;
3081:

Line 3078: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3074: ,x_pocv_rec => lx_pocv_rec);
3075:
3076: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3077: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3078: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3079: RAISE Okl_Api.G_EXCEPTION_ERROR;
3080: END IF;
3081:
3082: END LOOP; -- p_split_kle_ids

Line 3079: RAISE Okl_Api.G_EXCEPTION_ERROR;

3075:
3076: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3077: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3078: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3079: RAISE Okl_Api.G_EXCEPTION_ERROR;
3080: END IF;
3081:
3082: END LOOP; -- p_split_kle_ids
3083:

Line 3094: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

3090: ELSE
3091: RAISE G_EXCEPTION_ERROR;
3092: END IF;
3093:
3094: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
3095: ,x_msg_data => x_msg_data);
3096:
3097: x_return_status := l_return_status;
3098:

Line 3102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3098:
3099:
3100: EXCEPTION
3101: WHEN G_EXCEPTION_ERROR THEN
3102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3103: p_pkg_name => G_PKG_NAME,
3104: p_exc_name => G_EXC_NAME_ERROR,
3105: x_msg_count => x_msg_count,
3106: x_msg_data => x_msg_data,

Line 3110: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3106: x_msg_data => x_msg_data,
3107: p_api_type => G_API_TYPE);
3108:
3109: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3110: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3111: p_pkg_name => G_PKG_NAME,
3112: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3113: x_msg_count => x_msg_count,
3114: x_msg_data => x_msg_data,

Line 3117: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3113: x_msg_count => x_msg_count,
3114: x_msg_data => x_msg_data,
3115: p_api_type => G_API_TYPE);
3116: WHEN OTHERS THEN
3117: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3118: p_pkg_name => G_PKG_NAME,
3119: p_exc_name => G_EXC_NAME_OTHERS,
3120: x_msg_count => x_msg_count,
3121: x_msg_data => x_msg_data,

Line 3138: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

3134: -- End of comments
3135: ----------------------------------------------------------------------------------
3136: PROCEDURE create_inv_disb_streams(
3137: p_api_version IN NUMBER
3138: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
3139: ,x_return_status OUT NOCOPY VARCHAR2
3140: ,x_msg_count OUT NOCOPY NUMBER
3141: ,x_msg_data OUT NOCOPY VARCHAR2
3142: ,p_khr_id IN NUMBER

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

3160: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3161:
3162: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3163: l_api_version CONSTANT NUMBER := 1.0;
3164: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3165:
3166: l_sty_purpose VARCHAR2(150);
3167: l_sty_id NUMBER;
3168:

Line 3171: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

3167: l_sty_id NUMBER;
3168:
3169: BEGIN
3170:
3171: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
3172: p_pkg_name => G_PKG_NAME,
3173: p_init_msg_list => p_init_msg_list,
3174: l_api_version => l_api_version,
3175: p_api_version => p_api_version,

Line 3237: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3233: ,p_selv_tbl => lp_selv_tbl
3234: ,x_stmv_rec => lx_stmv_rec
3235: ,x_selv_tbl => lx_selv_tbl);
3236:
3237: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3238: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3239: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3240: RAISE Okl_Api.G_EXCEPTION_ERROR;
3241: END IF;

Line 3238: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3234: ,x_stmv_rec => lx_stmv_rec
3235: ,x_selv_tbl => lx_selv_tbl);
3236:
3237: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3238: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3239: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3240: RAISE Okl_Api.G_EXCEPTION_ERROR;
3241: END IF;
3242:

Line 3239: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3235: ,x_selv_tbl => lx_selv_tbl);
3236:
3237: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3238: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3239: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3240: RAISE Okl_Api.G_EXCEPTION_ERROR;
3241: END IF;
3242:
3243: END IF; -- l_sty_id

Line 3240: RAISE Okl_Api.G_EXCEPTION_ERROR;

3236:
3237: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3238: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3239: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3240: RAISE Okl_Api.G_EXCEPTION_ERROR;
3241: END IF;
3242:
3243: END IF; -- l_sty_id
3244:

Line 3246: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

3242:
3243: END IF; -- l_sty_id
3244:
3245:
3246: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
3247: ,x_msg_data => x_msg_data);
3248:
3249: x_return_status := l_return_status;
3250:

Line 3253: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3249: x_return_status := l_return_status;
3250:
3251: EXCEPTION
3252: WHEN G_EXCEPTION_ERROR THEN
3253: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3254: p_pkg_name => G_PKG_NAME,
3255: p_exc_name => G_EXC_NAME_ERROR,
3256: x_msg_count => x_msg_count,
3257: x_msg_data => x_msg_data,

Line 3261: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3257: x_msg_data => x_msg_data,
3258: p_api_type => G_API_TYPE);
3259:
3260: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3261: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3262: p_pkg_name => G_PKG_NAME,
3263: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3264: x_msg_count => x_msg_count,
3265: x_msg_data => x_msg_data,

Line 3268: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3264: x_msg_count => x_msg_count,
3265: x_msg_data => x_msg_data,
3266: p_api_type => G_API_TYPE);
3267: WHEN OTHERS THEN
3268: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3269: p_pkg_name => G_PKG_NAME,
3270: p_exc_name => G_EXC_NAME_OTHERS,
3271: x_msg_count => x_msg_count,
3272: x_msg_data => x_msg_data,

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

3329: lx_khrv_rec Okl_Contract_Pub.khrv_rec_type;
3330:
3331: l_api_name CONSTANT VARCHAR2(30) := 'buyback_streams';
3332: l_api_version CONSTANT NUMBER := 1.0;
3333: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3334:
3335: lx_buyback_amount NUMBER;
3336: lp_effective_date DATE;
3337: lp_agreement_id NUMBER;

Line 3350: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

3346: l_loan_sty_purposes l_loan_sty_purpose_tbl;
3347:
3348: BEGIN
3349:
3350: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
3351: p_pkg_name => G_PKG_NAME,
3352: p_init_msg_list => p_init_msg_list,
3353: l_api_version => l_api_version,
3354: p_api_version => p_api_version,

Line 3413: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3409: ,p_khr_id => p_khr_id
3410: ,p_stream_type_subclass => p_stream_type_subclass
3411: ,p_streams_to_date => lp_effective_date);
3412:
3413: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3414: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3415: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3416: RAISE Okl_Api.G_EXCEPTION_ERROR;
3417: END IF;

Line 3414: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3410: ,p_stream_type_subclass => p_stream_type_subclass
3411: ,p_streams_to_date => lp_effective_date);
3412:
3413: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3414: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3415: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3416: RAISE Okl_Api.G_EXCEPTION_ERROR;
3417: END IF;
3418:

Line 3415: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3411: ,p_streams_to_date => lp_effective_date);
3412:
3413: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3414: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3415: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3416: RAISE Okl_Api.G_EXCEPTION_ERROR;
3417: END IF;
3418:
3419: IF p_stream_type_subclass = G_STY_SUBCLASS_LOAN_PAYMENT THEN

Line 3416: RAISE Okl_Api.G_EXCEPTION_ERROR;

3412:
3413: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3414: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3415: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3416: RAISE Okl_Api.G_EXCEPTION_ERROR;
3417: END IF;
3418:
3419: IF p_stream_type_subclass = G_STY_SUBCLASS_LOAN_PAYMENT THEN
3420: l_loan_sty_purposes(1).l_loan_sty_purpose := G_STY_INV_PRINCIPAL_BUYBACK;

Line 3464: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3460: ,p_khr_id => p_khr_id
3461: ,p_cancel_date => lp_effective_date);
3462:
3463:
3464: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3465: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3466: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3467: RAISE Okl_Api.G_EXCEPTION_ERROR;
3468: END IF;

Line 3465: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3461: ,p_cancel_date => lp_effective_date);
3462:
3463:
3464: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3465: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3466: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3467: RAISE Okl_Api.G_EXCEPTION_ERROR;
3468: END IF;
3469:

Line 3466: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3462:
3463:
3464: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3465: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3466: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3467: RAISE Okl_Api.G_EXCEPTION_ERROR;
3468: END IF;
3469:
3470: END IF; -- p_stream_type_subclass

Line 3467: RAISE Okl_Api.G_EXCEPTION_ERROR;

3463:
3464: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3465: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3466: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3467: RAISE Okl_Api.G_EXCEPTION_ERROR;
3468: END IF;
3469:
3470: END IF; -- p_stream_type_subclass
3471:

Line 3496: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3492: p_khrv_rec => lp_khrv_rec,
3493: x_chrv_rec => lx_chrv_rec,
3494: x_khrv_rec => lx_khrv_rec);
3495:
3496: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3497: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3498: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3499: RAISE Okl_Api.G_EXCEPTION_ERROR;
3500: END IF;

Line 3497: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3493: x_chrv_rec => lx_chrv_rec,
3494: x_khrv_rec => lx_khrv_rec);
3495:
3496: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3497: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3498: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3499: RAISE Okl_Api.G_EXCEPTION_ERROR;
3500: END IF;
3501:

Line 3498: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3494: x_khrv_rec => lx_khrv_rec);
3495:
3496: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3497: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3498: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3499: RAISE Okl_Api.G_EXCEPTION_ERROR;
3500: END IF;
3501:
3502: END IF;

Line 3499: RAISE Okl_Api.G_EXCEPTION_ERROR;

3495:
3496: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3497: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3498: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3499: RAISE Okl_Api.G_EXCEPTION_ERROR;
3500: END IF;
3501:
3502: END IF;
3503:

Line 3508: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

3504:
3505: END LOOP; -- l_okl_pol_csr
3506:
3507:
3508: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
3509: ,x_msg_data => x_msg_data);
3510:
3511: x_return_status := l_return_status;
3512:

Line 3517: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3513:
3514: EXCEPTION
3515: WHEN G_EXCEPTION_ERROR THEN
3516:
3517: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3518: p_pkg_name => G_PKG_NAME,
3519: p_exc_name => G_EXC_NAME_ERROR,
3520: x_msg_count => x_msg_count,
3521: x_msg_data => x_msg_data,

Line 3526: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3522: p_api_type => G_API_TYPE);
3523:
3524: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3525:
3526: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3527: p_pkg_name => G_PKG_NAME,
3528: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3529: x_msg_count => x_msg_count,
3530: x_msg_data => x_msg_data,

Line 3534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3530: x_msg_data => x_msg_data,
3531: p_api_type => G_API_TYPE);
3532: WHEN OTHERS THEN
3533:
3534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3535: p_pkg_name => G_PKG_NAME,
3536: p_exc_name => G_EXC_NAME_OTHERS,
3537: x_msg_count => x_msg_count,
3538: x_msg_data => x_msg_data,