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

Line 3: g_user_id NUMBER := Okl_Api.G_MISS_NUM;

1: PACKAGE BODY Okl_Cs_Lc_Contract_Pvt AS
2: /* $Header: OKLRLCRB.pls 120.32 2008/04/10 12:11:06 dkagrawa noship $ */
3: g_user_id NUMBER := Okl_Api.G_MISS_NUM;
4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;
5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;
6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;
7: g_reset_access_flag BOOLEAN := FALSE;

Line 4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;

1: PACKAGE BODY Okl_Cs_Lc_Contract_Pvt AS
2: /* $Header: OKLRLCRB.pls 120.32 2008/04/10 12:11:06 dkagrawa noship $ */
3: g_user_id NUMBER := Okl_Api.G_MISS_NUM;
4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;
5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;
6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;
7: g_reset_access_flag BOOLEAN := FALSE;
8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;

Line 5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;

1: PACKAGE BODY Okl_Cs_Lc_Contract_Pvt AS
2: /* $Header: OKLRLCRB.pls 120.32 2008/04/10 12:11:06 dkagrawa noship $ */
3: g_user_id NUMBER := Okl_Api.G_MISS_NUM;
4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;
5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;
6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;
7: g_reset_access_flag BOOLEAN := FALSE;
8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;
9: g_groups_processed BOOLEAN := FALSE;

Line 6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;

2: /* $Header: OKLRLCRB.pls 120.32 2008/04/10 12:11:06 dkagrawa noship $ */
3: g_user_id NUMBER := Okl_Api.G_MISS_NUM;
4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;
5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;
6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;
7: g_reset_access_flag BOOLEAN := FALSE;
8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;
9: g_groups_processed BOOLEAN := FALSE;
10: g_reset_lang_flag BOOLEAN := FALSE;

Line 8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;

4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;
5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;
6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;
7: g_reset_access_flag BOOLEAN := FALSE;
8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;
9: g_groups_processed BOOLEAN := FALSE;
10: g_reset_lang_flag BOOLEAN := FALSE;
11: g_reset_resp_flag BOOLEAN := FALSE;
12: --varangan added the formula name variable for bug #5036582

Line 113: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: CLOSE deal_type;
113: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
114: ,p_msg_name => G_UNEXPECTED_ERROR
115: ,p_token1 => G_SQLCODE_TOKEN
116: ,p_token1_value => SQLCODE
117: ,p_token2 => G_SQLERRM_TOKEN

Line 269: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

265: /* Commented-varangan-Bug#5009351
266: CLOSE next_due_date;
267: CLOSE next_due_amount; */
268:
269: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
270: ,p_msg_name => G_UNEXPECTED_ERROR
271: ,p_token1 => G_SQLCODE_TOKEN
272: ,p_token1_value => SQLCODE
273: ,p_token2 => G_SQLERRM_TOKEN

Line 319: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

315: CLOSE last_due;
316: EXCEPTION
317: WHEN OTHERS THEN
318: CLOSE last_due;
319: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
320: ,p_msg_name => G_UNEXPECTED_ERROR
321: ,p_token1 => G_SQLCODE_TOKEN
322: ,p_token1_value => SQLCODE
323: ,p_token2 => G_SQLERRM_TOKEN

Line 347: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

343: CLOSE asset_cost;
344: EXCEPTION
345: WHEN OTHERS THEN
346: CLOSE asset_cost;
347: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
348: ,p_msg_name => G_UNEXPECTED_ERROR
349: ,p_token1 => G_SQLCODE_TOKEN
350: ,p_token1_value => SQLCODE
351: ,p_token2 => G_SQLERRM_TOKEN

Line 417: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

413: EXCEPTION
414: WHEN OTHERS THEN
415: CLOSE parent_line_id;
416: CLOSE c_subsidy;
417: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
418: ,p_msg_name => G_UNEXPECTED_ERROR
419: ,p_token1 => G_SQLCODE_TOKEN
420: ,p_token1_value => SQLCODE
421: ,p_token2 => G_SQLERRM_TOKEN

Line 437: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

433: BEGIN
434: null;
435: EXCEPTION
436: WHEN OTHERS THEN
437: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
438: ,p_msg_name => G_UNEXPECTED_ERROR
439: ,p_token1 => G_SQLCODE_TOKEN
440: ,p_token1_value => SQLCODE
441: ,p_token2 => G_SQLERRM_TOKEN

Line 461: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

457: p_contract_id => p_contract_id,
458: x_value => o_billed_amt);
459: EXCEPTION
460: WHEN OTHERS THEN
461: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
462: ,p_msg_name => G_UNEXPECTED_ERROR
463: ,p_token1 => G_SQLCODE_TOKEN
464: ,p_token1_value => SQLCODE
465: ,p_token2 => G_SQLERRM_TOKEN

Line 485: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

481: p_contract_id => p_contract_id,
482: x_value => o_unbilled_amt);
483: EXCEPTION
484: WHEN OTHERS THEN
485: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
486: ,p_msg_name => G_UNEXPECTED_ERROR
487: ,p_token1 => G_SQLCODE_TOKEN
488: ,p_token1_value => SQLCODE
489: ,p_token2 => G_SQLERRM_TOKEN

Line 512: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

508: CLOSE contract_dates ;
509: EXCEPTION
510: WHEN OTHERS THEN
511: CLOSE contract_dates ;
512: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
513: ,p_msg_name => G_UNEXPECTED_ERROR
514: ,p_token1 => G_SQLCODE_TOKEN
515: ,p_token1_value => SQLCODE
516: ,p_token2 => G_SQLERRM_TOKEN

Line 603: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

599: WHEN OTHERS THEN
600: CLOSE advance_rent ;
601: CLOSE security_deposit;
602: CLOSE Interest_type;
603: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
604: ,p_msg_name => G_UNEXPECTED_ERROR
605: ,p_token1 => G_SQLCODE_TOKEN
606: ,p_token1_value => SQLCODE
607: ,p_token2 => G_SQLERRM_TOKEN

Line 626: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

622: CLOSE notes;
623: EXCEPTION
624: WHEN OTHERS THEN
625: CLOSE notes;
626: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
627: ,p_msg_name => G_UNEXPECTED_ERROR
628: ,p_token1 => G_SQLCODE_TOKEN
629: ,p_token1_value => SQLCODE
630: ,p_token2 => G_SQLERRM_TOKEN

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

643: FROM okl_k_hdrs_full_uv
644: WHERE CHR_ID = p_contract_id;
645: l_vendor_program VARCHAR2(240);
646: l_api_version NUMBER;
647: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
648: l_msg_count NUMBER;
649: l_msg_data VARCHAR2(2000);
650: BEGIN
651: OPEN vendor_program_cur(p_contract_id);

Line 658: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

654: x_vendor_program := l_vendor_program;
655: RETURN l_return_status;
656: EXCEPTION
657: WHEN OTHERS THEN
658: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
659: ,p_msg_name => G_UNEXPECTED_ERROR
660: ,p_token1 => G_SQLCODE_TOKEN
661: ,p_token1_value => SQLCODE
662: ,p_token2 => G_SQLERRM_TOKEN

Line 664: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

660: ,p_token1 => G_SQLCODE_TOKEN
661: ,p_token1_value => SQLCODE
662: ,p_token2 => G_SQLERRM_TOKEN
663: ,p_token2_value => SQLERRM);
664: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
665: RETURN(l_return_status);
666: END get_vendor_program;
667: ---------------------------------------------------------------------------
668: -- FUNCTION get_private_label

Line 676: l_init_msg_list VARCHAR2(1) DEFAULT Okl_Api.G_FALSE;

672: x_private_label OUT NOCOPY VARCHAR2)
673: RETURN VARCHAR2
674: IS
675: l_api_version NUMBER :=1;
676: l_init_msg_list VARCHAR2(1) DEFAULT Okl_Api.G_FALSE;
677: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
678: l_msg_count NUMBER;
679: l_msg_data VARCHAR2(2000);
680: l_party_tab Okl_Jtot_Extract.party_tab_type;

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

673: RETURN VARCHAR2
674: IS
675: l_api_version NUMBER :=1;
676: l_init_msg_list VARCHAR2(1) DEFAULT Okl_Api.G_FALSE;
677: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
678: l_msg_count NUMBER;
679: l_msg_data VARCHAR2(2000);
680: l_party_tab Okl_Jtot_Extract.party_tab_type;
681: BEGIN

Line 700: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

696: x_private_label := l_party_tab(1).name;
697: RETURN l_return_status;
698: EXCEPTION
699: WHEN OTHERS THEN
700: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
701: ,p_msg_name => G_UNEXPECTED_ERROR
702: ,p_token1 => G_SQLCODE_TOKEN
703: ,p_token1_value => SQLCODE
704: ,p_token2 => G_SQLERRM_TOKEN

Line 706: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

702: ,p_token1 => G_SQLCODE_TOKEN
703: ,p_token1_value => SQLCODE
704: ,p_token2 => G_SQLERRM_TOKEN
705: ,p_token2_value => SQLERRM);
706: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
707: RETURN(l_return_status);
708: END get_private_label;
709: ---------------------------------------------------------------------------
710: -- FUNCTION get_currency

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

719: FROM okc_k_headers_b
720: WHERE id = p_contract_id;
721: l_currency VARCHAR2(240);
722: l_api_version NUMBER;
723: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
724: l_msg_count NUMBER;
725: l_msg_data VARCHAR2(2000);
726: BEGIN
727: OPEN currency_cur(p_contract_id);

Line 734: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

730: x_currency := l_currency;
731: RETURN l_return_status;
732: EXCEPTION
733: WHEN OTHERS THEN
734: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
735: ,p_msg_name => G_UNEXPECTED_ERROR
736: ,p_token1 => G_SQLCODE_TOKEN
737: ,p_token1_value => SQLCODE
738: ,p_token2 => G_SQLERRM_TOKEN

Line 740: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

736: ,p_token1 => G_SQLCODE_TOKEN
737: ,p_token1_value => SQLCODE
738: ,p_token2 => G_SQLERRM_TOKEN
739: ,p_token2_value => SQLERRM);
740: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
741: RETURN(l_return_status);
742: END get_currency;
743: ---------------------------------------------------------------------------
744: -- FUNCTION get_syndicate_flag

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

772: )
773: AND CHR.scs_code IN ('LEASE','LOAN');
774: l_syndicate_flag VARCHAR2(1) := 'N';
775: l_api_version NUMBER;
776: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
777: l_msg_count NUMBER;
778: l_msg_data VARCHAR2(2000);
779: BEGIN
780: OPEN syndicate_flag_cur(p_contract_id);

Line 787: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

783: x_syndicate_flag := l_syndicate_flag;
784: RETURN l_return_status;
785: EXCEPTION
786: WHEN OTHERS THEN
787: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
788: ,p_msg_name => G_UNEXPECTED_ERROR
789: ,p_token1 => G_SQLCODE_TOKEN
790: ,p_token1_value => SQLCODE
791: ,p_token2 => G_SQLERRM_TOKEN

Line 793: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

789: ,p_token1 => G_SQLCODE_TOKEN
790: ,p_token1_value => SQLCODE
791: ,p_token2 => G_SQLERRM_TOKEN
792: ,p_token2_value => SQLERRM);
793: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
794: RETURN(l_return_status);
795: END get_syndicate_flag;
796: ---------------------------------------------------------------------------
797: -- FUNCTION GET_ORG_ID

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

806: SELECT authoring_org_id
807: FROM okc_k_headers_b
808: WHERE id = p_contract_id;
809: l_api_version NUMBER;
810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
811: l_msg_count NUMBER;
812: l_msg_data VARCHAR2(2000);
813: BEGIN
814: OPEN get_org_id_cur(p_contract_id);

Line 821: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

817: RETURN l_return_status;
818: EXCEPTION
819: WHEN OTHERS THEN
820: CLOSE get_org_id_cur;
821: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
822: ,p_msg_name => G_UNEXPECTED_ERROR
823: ,p_token1 => G_SQLCODE_TOKEN
824: ,p_token1_value => SQLCODE
825: ,p_token2 => G_SQLERRM_TOKEN

Line 827: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

823: ,p_token1 => G_SQLCODE_TOKEN
824: ,p_token1_value => SQLCODE
825: ,p_token2 => G_SQLERRM_TOKEN
826: ,p_token2_value => SQLERRM);
827: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
828: RETURN(l_return_status);
829: END GET_ORG_ID;
830: ---------------------------------------------------------------------------
831: -- FUNCTION GET_RESOURCE_ID

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

838: SELECT resource_id
839: FROM jtf_rs_resource_extns
840: WHERE user_id = l_user_id;
841: l_api_version NUMBER;
842: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
843: l_msg_count NUMBER;
844: l_msg_data VARCHAR2(2000);
845: l_user_id NUMBER(10);
846: BEGIN

Line 855: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

851: RETURN l_return_status;
852: EXCEPTION
853: WHEN OTHERS THEN
854: CLOSE get_res_id_cur;
855: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
856: ,p_msg_name => G_UNEXPECTED_ERROR
857: ,p_token1 => G_SQLCODE_TOKEN
858: ,p_token1_value => SQLCODE
859: ,p_token2 => G_SQLERRM_TOKEN

Line 861: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

857: ,p_token1 => G_SQLCODE_TOKEN
858: ,p_token1_value => SQLCODE
859: ,p_token2 => G_SQLERRM_TOKEN
860: ,p_token2_value => SQLERRM);
861: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
862: RETURN(l_return_status);
863: END GET_resource_ID;
864: FUNCTION get_warning_message(
865: p_contract_id IN NUMBER,

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

894: )
895: AND CHR.scs_code IN ('LEASE','LOAN');
896: l_flag VARCHAR2(1) := 'N';
897: l_api_version NUMBER;
898: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
899: l_msg_count NUMBER;
900: l_msg_data VARCHAR2(2000);
901: BEGIN
902: OPEN syndicate_flag_cur(p_contract_id);

Line 909: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

905: x_syndicate_flag := l_flag;
906: RETURN l_return_status;
907: EXCEPTION
908: WHEN OTHERS THEN
909: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
910: ,p_msg_name => G_UNEXPECTED_ERROR
911: ,p_token1 => G_SQLCODE_TOKEN
912: ,p_token1_value => SQLCODE
913: ,p_token2 => G_SQLERRM_TOKEN

Line 915: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

911: ,p_token1 => G_SQLCODE_TOKEN
912: ,p_token1_value => SQLCODE
913: ,p_token2 => G_SQLERRM_TOKEN
914: ,p_token2_value => SQLERRM);
915: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
916: RETURN(l_return_status);
917: END get_warning_message;
918: PROCEDURE Set_Connection_Context IS
919: BEGIN

Line 920: IF (g_user_id = Okl_Api.G_MISS_NUM) OR

916: RETURN(l_return_status);
917: END get_warning_message;
918: PROCEDURE Set_Connection_Context IS
919: BEGIN
920: IF (g_user_id = Okl_Api.G_MISS_NUM) OR
921: (g_user_id <> Fnd_Global.user_id) THEN
922: g_user_id := Fnd_Global.user_id;
923: g_reset_access_flag := TRUE;
924: g_reset_lang_flag := TRUE;

Line 926: IF (g_resp_id = Okl_Api.G_MISS_NUM) OR

922: g_user_id := Fnd_Global.user_id;
923: g_reset_access_flag := TRUE;
924: g_reset_lang_flag := TRUE;
925: END IF;
926: IF (g_resp_id = Okl_Api.G_MISS_NUM) OR
927: (g_resp_id <> Fnd_Global.resp_id) THEN
928: g_resp_id := Fnd_Global.resp_id;
929: g_reset_resp_flag := TRUE;
930: END IF;

Line 1094: IF (g_user_resource_id = Okl_Api.G_MISS_NUM) OR

1090: -- If could not find 'Update' access from the user's responsibility,
1091: -- continue to check if granted any access at the user resource level.
1092: -- If the user resource id is not determined earlier, then retrieve it
1093: -- and cache it as it will not change during the current session
1094: IF (g_user_resource_id = Okl_Api.G_MISS_NUM) OR
1095: (g_reset_access_flag) THEN
1096: OPEN res_csr;
1097: FETCH res_csr INTO g_user_resource_id;
1098: l_row_notfound := res_csr%NOTFOUND;

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

1335: WHERE code=p_okl_Status;
1336:
1337:
1338: l_api_version NUMBER;
1339: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1340: l_msg_count NUMBER;
1341: l_msg_data VARCHAR2(2000);
1342: l_user_status VARCHAR2(100);
1343: l_okc_status VARCHAR2(100);

Line 1427: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1423: x_allowed := l_allowed;
1424: RETURN l_return_status;
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1428: ,p_msg_name => G_UNEXPECTED_ERROR
1429: ,p_token1 => G_SQLCODE_TOKEN
1430: ,p_token1_value => SQLCODE
1431: ,p_token2 => G_SQLERRM_TOKEN

Line 1433: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1429: ,p_token1 => G_SQLCODE_TOKEN
1430: ,p_token1_value => SQLCODE
1431: ,p_token2 => G_SQLERRM_TOKEN
1432: ,p_token2_value => SQLERRM);
1433: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1434: RETURN(l_return_status);
1435: END get_contract_status;
1436:
1437:

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

1452: stat.code = 'BOOKED' AND
1453: ca.cust_account_id = p_cust_acct_id;
1454:
1455: l_api_version NUMBER;
1456: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1457: l_msg_count NUMBER;
1458: l_msg_data VARCHAR2(2000);
1459: BEGIN
1460: OPEN get_contract_no(p_cust_acct_id);

Line 1467: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1463: RETURN l_return_status;
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: CLOSE get_contract_no;
1467: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1468: ,p_msg_name => G_UNEXPECTED_ERROR
1469: ,p_token1 => G_SQLCODE_TOKEN
1470: ,p_token1_value => SQLCODE
1471: ,p_token2 => G_SQLERRM_TOKEN

Line 1473: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1469: ,p_token1 => G_SQLCODE_TOKEN
1470: ,p_token1_value => SQLCODE
1471: ,p_token2 => G_SQLERRM_TOKEN
1472: ,p_token2_value => SQLERRM);
1473: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1474: RETURN(l_return_status);
1475: END contract_cust_accounts;
1476: PROCEDURE update_deal(
1477: p_api_version IN NUMBER,

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

1482: p_durv_tbl IN deal_tbl_type,
1483: x_durv_tbl OUT NOCOPY deal_tbl_type
1484: ) AS
1485: i number;
1486: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1487: l_msg_count NUMBER;
1488: l_msg_data VARCHAR2(2000);
1489: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1490: BEGIN

Line 1489: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1485: i number;
1486: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1487: l_msg_count NUMBER;
1488: l_msg_data VARCHAR2(2000);
1489: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1490: BEGIN
1491:
1492: OKC_API.init_msg_list(p_init_msg_list);
1493: IF (p_durv_tbl.COUNT > 0) THEN

Line 1539: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1535: close investor_assigned;
1536: x_value := l_securitized;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1540: ,p_msg_name => G_UNEXPECTED_ERROR
1541: ,p_token1 => G_SQLCODE_TOKEN
1542: ,p_token1_value => SQLCODE
1543: ,p_token2 => G_SQLERRM_TOKEN