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.34.12020000.4 2012/10/08 06:21:48 vsgandhi ship $ */
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.34.12020000.4 2012/10/08 06:21:48 vsgandhi ship $ */
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.34.12020000.4 2012/10/08 06:21:48 vsgandhi ship $ */
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.34.12020000.4 2012/10/08 06:21:48 vsgandhi ship $ */
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 355: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

351: CLOSE last_due;
352: EXCEPTION
353: WHEN OTHERS THEN
354: CLOSE last_due;
355: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
356: ,p_msg_name => G_UNEXPECTED_ERROR
357: ,p_token1 => G_SQLCODE_TOKEN
358: ,p_token1_value => SQLCODE
359: ,p_token2 => G_SQLERRM_TOKEN

Line 385: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

381: CLOSE asset_cost;
382: EXCEPTION
383: WHEN OTHERS THEN
384: CLOSE asset_cost;
385: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
386: ,p_msg_name => G_UNEXPECTED_ERROR
387: ,p_token1 => G_SQLCODE_TOKEN
388: ,p_token1_value => SQLCODE
389: ,p_token2 => G_SQLERRM_TOKEN

Line 455: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

451: EXCEPTION
452: WHEN OTHERS THEN
453: CLOSE parent_line_id;
454: CLOSE c_subsidy;
455: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
456: ,p_msg_name => G_UNEXPECTED_ERROR
457: ,p_token1 => G_SQLCODE_TOKEN
458: ,p_token1_value => SQLCODE
459: ,p_token2 => G_SQLERRM_TOKEN

Line 475: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

471: BEGIN
472: null;
473: EXCEPTION
474: WHEN OTHERS THEN
475: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
476: ,p_msg_name => G_UNEXPECTED_ERROR
477: ,p_token1 => G_SQLCODE_TOKEN
478: ,p_token1_value => SQLCODE
479: ,p_token2 => G_SQLERRM_TOKEN

Line 499: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

495: p_contract_id => p_contract_id,
496: x_value => o_billed_amt);
497: EXCEPTION
498: WHEN OTHERS THEN
499: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
500: ,p_msg_name => G_UNEXPECTED_ERROR
501: ,p_token1 => G_SQLCODE_TOKEN
502: ,p_token1_value => SQLCODE
503: ,p_token2 => G_SQLERRM_TOKEN

Line 523: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

519: p_contract_id => p_contract_id,
520: x_value => o_unbilled_amt);
521: EXCEPTION
522: WHEN OTHERS THEN
523: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
524: ,p_msg_name => G_UNEXPECTED_ERROR
525: ,p_token1 => G_SQLCODE_TOKEN
526: ,p_token1_value => SQLCODE
527: ,p_token2 => G_SQLERRM_TOKEN

Line 550: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

546: CLOSE contract_dates ;
547: EXCEPTION
548: WHEN OTHERS THEN
549: CLOSE contract_dates ;
550: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
551: ,p_msg_name => G_UNEXPECTED_ERROR
552: ,p_token1 => G_SQLCODE_TOKEN
553: ,p_token1_value => SQLCODE
554: ,p_token2 => G_SQLERRM_TOKEN

Line 641: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

637: WHEN OTHERS THEN
638: CLOSE advance_rent ;
639: CLOSE security_deposit;
640: CLOSE Interest_type;
641: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
642: ,p_msg_name => G_UNEXPECTED_ERROR
643: ,p_token1 => G_SQLCODE_TOKEN
644: ,p_token1_value => SQLCODE
645: ,p_token2 => G_SQLERRM_TOKEN

Line 664: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

660: CLOSE notes;
661: EXCEPTION
662: WHEN OTHERS THEN
663: CLOSE notes;
664: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
665: ,p_msg_name => G_UNEXPECTED_ERROR
666: ,p_token1 => G_SQLCODE_TOKEN
667: ,p_token1_value => SQLCODE
668: ,p_token2 => G_SQLERRM_TOKEN

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

681: FROM okl_k_hdrs_full_uv
682: WHERE CHR_ID = p_contract_id;
683: l_vendor_program VARCHAR2(240);
684: l_api_version NUMBER;
685: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
686: l_msg_count NUMBER;
687: l_msg_data VARCHAR2(2000);
688: BEGIN
689: OPEN vendor_program_cur(p_contract_id);

Line 696: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

692: x_vendor_program := l_vendor_program;
693: RETURN l_return_status;
694: EXCEPTION
695: WHEN OTHERS THEN
696: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
697: ,p_msg_name => G_UNEXPECTED_ERROR
698: ,p_token1 => G_SQLCODE_TOKEN
699: ,p_token1_value => SQLCODE
700: ,p_token2 => G_SQLERRM_TOKEN

Line 702: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

698: ,p_token1 => G_SQLCODE_TOKEN
699: ,p_token1_value => SQLCODE
700: ,p_token2 => G_SQLERRM_TOKEN
701: ,p_token2_value => SQLERRM);
702: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
703: RETURN(l_return_status);
704: END get_vendor_program;
705: ---------------------------------------------------------------------------
706: -- FUNCTION get_private_label

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

710: x_private_label OUT NOCOPY VARCHAR2)
711: RETURN VARCHAR2
712: IS
713: l_api_version NUMBER :=1;
714: l_init_msg_list VARCHAR2(1) DEFAULT Okl_Api.G_FALSE;
715: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
716: l_msg_count NUMBER;
717: l_msg_data VARCHAR2(2000);
718: l_party_tab Okl_Jtot_Extract.party_tab_type;

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

711: RETURN VARCHAR2
712: IS
713: l_api_version NUMBER :=1;
714: l_init_msg_list VARCHAR2(1) DEFAULT Okl_Api.G_FALSE;
715: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
716: l_msg_count NUMBER;
717: l_msg_data VARCHAR2(2000);
718: l_party_tab Okl_Jtot_Extract.party_tab_type;
719: BEGIN

Line 738: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

734: x_private_label := l_party_tab(1).name;
735: RETURN l_return_status;
736: EXCEPTION
737: WHEN OTHERS THEN
738: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
739: ,p_msg_name => G_UNEXPECTED_ERROR
740: ,p_token1 => G_SQLCODE_TOKEN
741: ,p_token1_value => SQLCODE
742: ,p_token2 => G_SQLERRM_TOKEN

Line 744: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

740: ,p_token1 => G_SQLCODE_TOKEN
741: ,p_token1_value => SQLCODE
742: ,p_token2 => G_SQLERRM_TOKEN
743: ,p_token2_value => SQLERRM);
744: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
745: RETURN(l_return_status);
746: END get_private_label;
747: ---------------------------------------------------------------------------
748: -- FUNCTION get_currency

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

757: FROM okc_k_headers_b
758: WHERE id = p_contract_id;
759: l_currency VARCHAR2(240);
760: l_api_version NUMBER;
761: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
762: l_msg_count NUMBER;
763: l_msg_data VARCHAR2(2000);
764: BEGIN
765: OPEN currency_cur(p_contract_id);

Line 772: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

768: x_currency := l_currency;
769: RETURN l_return_status;
770: EXCEPTION
771: WHEN OTHERS THEN
772: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
773: ,p_msg_name => G_UNEXPECTED_ERROR
774: ,p_token1 => G_SQLCODE_TOKEN
775: ,p_token1_value => SQLCODE
776: ,p_token2 => G_SQLERRM_TOKEN

Line 778: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

774: ,p_token1 => G_SQLCODE_TOKEN
775: ,p_token1_value => SQLCODE
776: ,p_token2 => G_SQLERRM_TOKEN
777: ,p_token2_value => SQLERRM);
778: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
779: RETURN(l_return_status);
780: END get_currency;
781: ---------------------------------------------------------------------------
782: -- FUNCTION get_syndicate_flag

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

810: )
811: AND CHR.scs_code IN ('LEASE','LOAN');
812: l_syndicate_flag VARCHAR2(1) := 'N';
813: l_api_version NUMBER;
814: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
815: l_msg_count NUMBER;
816: l_msg_data VARCHAR2(2000);
817: BEGIN
818: OPEN syndicate_flag_cur(p_contract_id);

Line 825: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

821: x_syndicate_flag := l_syndicate_flag;
822: RETURN l_return_status;
823: EXCEPTION
824: WHEN OTHERS THEN
825: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
826: ,p_msg_name => G_UNEXPECTED_ERROR
827: ,p_token1 => G_SQLCODE_TOKEN
828: ,p_token1_value => SQLCODE
829: ,p_token2 => G_SQLERRM_TOKEN

Line 831: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

827: ,p_token1 => G_SQLCODE_TOKEN
828: ,p_token1_value => SQLCODE
829: ,p_token2 => G_SQLERRM_TOKEN
830: ,p_token2_value => SQLERRM);
831: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
832: RETURN(l_return_status);
833: END get_syndicate_flag;
834: ---------------------------------------------------------------------------
835: -- FUNCTION GET_ORG_ID

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

844: SELECT authoring_org_id
845: FROM okc_k_headers_b
846: WHERE id = p_contract_id;
847: l_api_version NUMBER;
848: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
849: l_msg_count NUMBER;
850: l_msg_data VARCHAR2(2000);
851: BEGIN
852: OPEN get_org_id_cur(p_contract_id);

Line 859: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

855: RETURN l_return_status;
856: EXCEPTION
857: WHEN OTHERS THEN
858: CLOSE get_org_id_cur;
859: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
860: ,p_msg_name => G_UNEXPECTED_ERROR
861: ,p_token1 => G_SQLCODE_TOKEN
862: ,p_token1_value => SQLCODE
863: ,p_token2 => G_SQLERRM_TOKEN

Line 865: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

861: ,p_token1 => G_SQLCODE_TOKEN
862: ,p_token1_value => SQLCODE
863: ,p_token2 => G_SQLERRM_TOKEN
864: ,p_token2_value => SQLERRM);
865: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
866: RETURN(l_return_status);
867: END GET_ORG_ID;
868: ---------------------------------------------------------------------------
869: -- FUNCTION GET_RESOURCE_ID

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

876: SELECT resource_id
877: FROM jtf_rs_resource_extns
878: WHERE user_id = l_user_id;
879: l_api_version NUMBER;
880: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
881: l_msg_count NUMBER;
882: l_msg_data VARCHAR2(2000);
883: l_user_id NUMBER(10);
884: BEGIN

Line 893: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

889: RETURN l_return_status;
890: EXCEPTION
891: WHEN OTHERS THEN
892: CLOSE get_res_id_cur;
893: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
894: ,p_msg_name => G_UNEXPECTED_ERROR
895: ,p_token1 => G_SQLCODE_TOKEN
896: ,p_token1_value => SQLCODE
897: ,p_token2 => G_SQLERRM_TOKEN

Line 899: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

895: ,p_token1 => G_SQLCODE_TOKEN
896: ,p_token1_value => SQLCODE
897: ,p_token2 => G_SQLERRM_TOKEN
898: ,p_token2_value => SQLERRM);
899: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
900: RETURN(l_return_status);
901: END GET_resource_ID;
902: FUNCTION get_warning_message(
903: p_contract_id IN NUMBER,

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

932: )
933: AND CHR.scs_code IN ('LEASE','LOAN');
934: l_flag VARCHAR2(1) := 'N';
935: l_api_version NUMBER;
936: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
937: l_msg_count NUMBER;
938: l_msg_data VARCHAR2(2000);
939: BEGIN
940: OPEN syndicate_flag_cur(p_contract_id);

Line 947: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

943: x_syndicate_flag := l_flag;
944: RETURN l_return_status;
945: EXCEPTION
946: WHEN OTHERS THEN
947: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
948: ,p_msg_name => G_UNEXPECTED_ERROR
949: ,p_token1 => G_SQLCODE_TOKEN
950: ,p_token1_value => SQLCODE
951: ,p_token2 => G_SQLERRM_TOKEN

Line 953: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

949: ,p_token1 => G_SQLCODE_TOKEN
950: ,p_token1_value => SQLCODE
951: ,p_token2 => G_SQLERRM_TOKEN
952: ,p_token2_value => SQLERRM);
953: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
954: RETURN(l_return_status);
955: END get_warning_message;
956: PROCEDURE Set_Connection_Context IS
957: BEGIN

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

954: RETURN(l_return_status);
955: END get_warning_message;
956: PROCEDURE Set_Connection_Context IS
957: BEGIN
958: IF (g_user_id = Okl_Api.G_MISS_NUM) OR
959: (g_user_id <> Fnd_Global.user_id) THEN
960: g_user_id := Fnd_Global.user_id;
961: g_reset_access_flag := TRUE;
962: g_reset_lang_flag := TRUE;

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

960: g_user_id := Fnd_Global.user_id;
961: g_reset_access_flag := TRUE;
962: g_reset_lang_flag := TRUE;
963: END IF;
964: IF (g_resp_id = Okl_Api.G_MISS_NUM) OR
965: (g_resp_id <> Fnd_Global.resp_id) THEN
966: g_resp_id := Fnd_Global.resp_id;
967: g_reset_resp_flag := TRUE;
968: END IF;

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

1128: -- If could not find 'Update' access from the user's responsibility,
1129: -- continue to check if granted any access at the user resource level.
1130: -- If the user resource id is not determined earlier, then retrieve it
1131: -- and cache it as it will not change during the current session
1132: IF (g_user_resource_id = Okl_Api.G_MISS_NUM) OR
1133: (g_reset_access_flag) THEN
1134: OPEN res_csr;
1135: FETCH res_csr INTO g_user_resource_id;
1136: l_row_notfound := res_csr%NOTFOUND;

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

1373: WHERE code=p_okl_Status;
1374:
1375:
1376: l_api_version NUMBER;
1377: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1378: l_msg_count NUMBER;
1379: l_msg_data VARCHAR2(2000);
1380: l_user_status VARCHAR2(100);
1381: l_okc_status VARCHAR2(100);

Line 1465: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 1471: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1467: ,p_token1 => G_SQLCODE_TOKEN
1468: ,p_token1_value => SQLCODE
1469: ,p_token2 => G_SQLERRM_TOKEN
1470: ,p_token2_value => SQLERRM);
1471: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1472: RETURN(l_return_status);
1473: END get_contract_status;
1474:
1475:

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

1490: stat.code = 'BOOKED' AND
1491: ca.cust_account_id = p_cust_acct_id;
1492:
1493: l_api_version NUMBER;
1494: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1495: l_msg_count NUMBER;
1496: l_msg_data VARCHAR2(2000);
1497: BEGIN
1498: OPEN get_contract_no(p_cust_acct_id);

Line 1505: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1501: RETURN l_return_status;
1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: CLOSE get_contract_no;
1505: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1506: ,p_msg_name => G_UNEXPECTED_ERROR
1507: ,p_token1 => G_SQLCODE_TOKEN
1508: ,p_token1_value => SQLCODE
1509: ,p_token2 => G_SQLERRM_TOKEN

Line 1511: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1507: ,p_token1 => G_SQLCODE_TOKEN
1508: ,p_token1_value => SQLCODE
1509: ,p_token2 => G_SQLERRM_TOKEN
1510: ,p_token2_value => SQLERRM);
1511: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1512: RETURN(l_return_status);
1513: END contract_cust_accounts;
1514: PROCEDURE update_deal(
1515: p_api_version IN NUMBER,

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

1520: p_durv_tbl IN deal_tbl_type,
1521: x_durv_tbl OUT NOCOPY deal_tbl_type
1522: ) AS
1523: i number;
1524: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1525: l_msg_count NUMBER;
1526: l_msg_data VARCHAR2(2000);
1527: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1528: BEGIN

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

1523: i number;
1524: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1525: l_msg_count NUMBER;
1526: l_msg_data VARCHAR2(2000);
1527: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1528: BEGIN
1529:
1530: OKC_API.init_msg_list(p_init_msg_list);
1531: IF (p_durv_tbl.COUNT > 0) THEN

Line 1577: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1573: close investor_assigned;
1574: x_value := l_securitized;
1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1578: ,p_msg_name => G_UNEXPECTED_ERROR
1579: ,p_token1 => G_SQLCODE_TOKEN
1580: ,p_token1_value => SQLCODE
1581: ,p_token2 => G_SQLERRM_TOKEN