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.OKS_COVERAGE_MIGRATION dependencies on OKC_API

Line 116: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;

112: L_OLD_CLE_ID NUMBER := -99999;
113: L_CLE_ID NUMBER := -99999;
114: l_duration NUMBER;
115: l_period VArchar2(10);
116: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;
117: l_transfer_option VArchar2(250);
118:
119:
120: l_start_rowid ROWID := p_start_rowid;

Line 152: OKC_API.SET_MESSAGE

148: X_Period :=Lx_Period;
149:
150: EXCEPTION
151: WHEN OTHERS THEN
152: OKC_API.SET_MESSAGE
153: (P_App_Name => G_APP_NAME_OKS
154: ,P_Msg_Name => G_UNEXPECTED_ERROR
155: ,P_Token1 => G_SQLCODE_TOKEN
156: ,P_Token1_Value => SQLCODE

Line 302: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

298: WHEN G_EXCEPTION_HALT THEN
299:
300: ROLLBACK;
301:
302: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
303: G_APP_NAME,
304: G_PKG_NAME,
305: 'OKC_API.G_RET_STS_UNEXP_ERROR',
306: x_msg_count,

Line 305: 'OKC_API.G_RET_STS_UNEXP_ERROR',

301:
302: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
303: G_APP_NAME,
304: G_PKG_NAME,
305: 'OKC_API.G_RET_STS_UNEXP_ERROR',
306: x_msg_count,
307: x_msg_data,
308: '_PVT'
309: );

Line 326: x_return_status := OKC_API.G_RET_STS_ERROR;

322: x_return_status := 'E';
323: WHEN Others THEN
324:
325:
326: x_return_status := OKC_API.G_RET_STS_ERROR;
327:
328: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
329: G_APP_NAME,
330: G_PKG_NAME,

Line 328: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

324:
325:
326: x_return_status := OKC_API.G_RET_STS_ERROR;
327:
328: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
329: G_APP_NAME,
330: G_PKG_NAME,
331: 'OKC_API.G_RET_STS_UNEXP_ERROR',
332: x_msg_count,

Line 331: 'OKC_API.G_RET_STS_UNEXP_ERROR',

327:
328: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
329: G_APP_NAME,
330: G_PKG_NAME,
331: 'OKC_API.G_RET_STS_UNEXP_ERROR',
332: x_msg_count,
333: x_msg_data,
334: '_PVT'
335: );

Line 362: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

358:
359: EXCEPTION
360: WHEN Others THEN
361:
362: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
363: G_APP_NAME,
364: G_PKG_NAME,
365: 'OKC_API.G_RET_STS_UNEXP_ERROR',
366: x_msg_count,

Line 365: 'OKC_API.G_RET_STS_UNEXP_ERROR',

361:
362: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
363: G_APP_NAME,
364: G_PKG_NAME,
365: 'OKC_API.G_RET_STS_UNEXP_ERROR',
366: x_msg_count,
367: x_msg_data,
368: '_PVT'
369: );

Line 495: l_return_Status VArchar2(3):= OKC_API.G_RET_STS_SUCCESS;

491: L_OLD_CLE_ID NUMBER := -99999;
492: L_CLE_ID NUMBER := -99999;
493: l_duration NUMBER;
494: l_period VArchar2(10);
495: l_return_Status VArchar2(3):= OKC_API.G_RET_STS_SUCCESS;
496: l_OU_CURRENCY VArchar2(10);
497:
498:
499: l_start_rowid ROWID := p_start_rowid;

Line 537: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

533: X_Period :=Lx_Period;
534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
538: G_APP_NAME,
539: G_PKG_NAME,
540: 'OKC_API.G_RET_STS_UNEXP_ERROR',
541: x_msg_count,

Line 540: 'OKC_API.G_RET_STS_UNEXP_ERROR',

536: WHEN OTHERS THEN
537: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
538: G_APP_NAME,
539: G_PKG_NAME,
540: 'OKC_API.G_RET_STS_UNEXP_ERROR',
541: x_msg_count,
542: x_msg_data,
543: '_PVT'
544: );

Line 620: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

616:
617: EXCEPTION
618: WHEN OTHERS THEN
619:
620: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
621: G_APP_NAME,
622: G_PKG_NAME,
623: 'OKC_API.G_RET_STS_UNEXP_ERROR',
624: x_msg_count,

Line 623: 'OKC_API.G_RET_STS_UNEXP_ERROR',

619:
620: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
621: G_APP_NAME,
622: G_PKG_NAME,
623: 'OKC_API.G_RET_STS_UNEXP_ERROR',
624: x_msg_count,
625: x_msg_data,
626: '_PVT'
627: );

Line 853: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

849: l_ctzv_tbl_in.delete;
850: l_clev_tbl_in.delete;
851: l_cvtv_tbl_in.delete;
852:
853: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
854: G_APP_NAME,
855: G_PKG_NAME,
856: 'OKC_API.G_RET_STS_UNEXP_ERROR',
857: x_msg_count,

Line 856: 'OKC_API.G_RET_STS_UNEXP_ERROR',

852:
853: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
854: G_APP_NAME,
855: G_PKG_NAME,
856: 'OKC_API.G_RET_STS_UNEXP_ERROR',
857: x_msg_count,
858: x_msg_data,
859: '_PVT'
860: );

Line 883: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

879: l_clev_tbl_in.delete;
880: l_cvtv_tbl_in.delete;
881:
882:
883: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
884: G_APP_NAME,
885: G_PKG_NAME,
886: 'OKC_API.G_RET_STS_UNEXP_ERROR',
887: x_msg_count,

Line 886: 'OKC_API.G_RET_STS_UNEXP_ERROR',

882:
883: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
884: G_APP_NAME,
885: G_PKG_NAME,
886: 'OKC_API.G_RET_STS_UNEXP_ERROR',
887: x_msg_count,
888: x_msg_data,
889: '_PVT'
890: );

Line 913: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

909: l_clev_tbl_in.delete;
910: l_cvtv_tbl_in.delete;
911:
912:
913: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
914: G_APP_NAME,
915: G_PKG_NAME,
916: 'OKC_API.G_RET_STS_UNEXP_ERROR',
917: x_msg_count,

Line 916: 'OKC_API.G_RET_STS_UNEXP_ERROR',

912:
913: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
914: G_APP_NAME,
915: G_PKG_NAME,
916: 'OKC_API.G_RET_STS_UNEXP_ERROR',
917: x_msg_count,
918: x_msg_data,
919: '_PVT'
920: );

Line 944: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

940:
941: EXCEPTION
942: WHEN Others THEN
943:
944: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
945: G_APP_NAME,
946: G_PKG_NAME,
947: 'OKC_API.G_RET_STS_UNEXP_ERROR',
948: x_msg_count,

Line 947: 'OKC_API.G_RET_STS_UNEXP_ERROR',

943:
944: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
945: G_APP_NAME,
946: G_PKG_NAME,
947: 'OKC_API.G_RET_STS_UNEXP_ERROR',
948: x_msg_count,
949: x_msg_data,
950: '_PVT'
951: );

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

1020: TIMES_Last_Update_Date_TBL Date_Tbl_Type;
1021: TIMES_Last_Update_Login_TBL Num_Tbl_Type;
1022:
1023: tablename1 VARCHAR2(1000);
1024: l_return_status VARCHAR2(1) :=OKC_API.G_RET_STS_SUCCESS;
1025: l_msg_count NUMBER;
1026:
1027: l_start_rowid ROWID := p_start_rowid;
1028: l_end_rowid ROWID := p_end_rowid;

Line 1143: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1139:
1140: EXCEPTION
1141: WHEN G_EXCEPTION_HALT THEN
1142: ROLLBACK;
1143: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1144: G_APP_NAME,
1145: G_PKG_NAME,
1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1147: x_msg_count,

Line 1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1142: ROLLBACK;
1143: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1144: G_APP_NAME,
1145: G_PKG_NAME,
1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1147: x_msg_count,
1148: x_msg_data,
1149: '_PVT'
1150: );

Line 1167: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1163: x_message_data := l_message;
1164: x_return_status := 'E';
1165: WHEN Others THEN
1166: ROLLBACK;
1167: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1168: G_APP_NAME,
1169: G_PKG_NAME,
1170: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1171: x_msg_count,

Line 1170: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1166: ROLLBACK;
1167: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1168: G_APP_NAME,
1169: G_PKG_NAME,
1170: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1171: x_msg_count,
1172: x_msg_data,
1173: '_PVT'
1174: );

Line 1197: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1193: CLOSE Csr_Get_Coverage_times;
1194: EXCEPTION
1195: WHEN Others THEN
1196: Raise;
1197: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1198: G_APP_NAME,
1199: G_PKG_NAME,
1200: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1201: x_msg_count,

Line 1200: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1196: Raise;
1197: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1198: G_APP_NAME,
1199: G_PKG_NAME,
1200: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1201: x_msg_count,
1202: x_msg_data,
1203: '_PVT'
1204: );

Line 1332: l_return_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1328:
1329: L_OLD_CLE_ID NUMBER := -99999;
1330: L_CLE_ID NUMBER := -99999;
1331: l_cle_ctr NUMBER := 0;
1332: l_return_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1333: x_msg_count NUMBER := 0;
1334: x_msg_data VArchar2(1000);
1335:
1336: l_start_rowid ROWID := p_start_rowid;

Line 1484: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1480: ROLLBACK;
1481: l_actv_tbl_in.DELETE;
1482: l_clev_tbl_in.DELETE;
1483:
1484: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1485: G_APP_NAME,
1486: G_PKG_NAME,
1487: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1488: x_msg_count,

Line 1487: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1483:
1484: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1485: G_APP_NAME,
1486: G_PKG_NAME,
1487: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1488: x_msg_count,
1489: x_msg_data,
1490: '_PVT'
1491: );

Line 1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1505: ROLLBACK;
1506: l_actv_tbl_in.DELETE;
1507: l_clev_tbl_in.DELETE;
1508:
1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1510: G_APP_NAME,
1511: G_PKG_NAME,
1512: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1513: x_msg_count,

Line 1512: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1508:
1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1510: G_APP_NAME,
1511: G_PKG_NAME,
1512: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1513: x_msg_count,
1514: x_msg_data,
1515: '_PVT'
1516: );

Line 1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1714: EXCEPTION
1715: WHEN G_EXCEPTION_HALT THEN
1716: ROLLBACK;
1717:
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1719: G_APP_NAME,
1720: G_PKG_NAME,
1721: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1722: x_msg_count,

Line 1721: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1717:
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1719: G_APP_NAME,
1720: G_PKG_NAME,
1721: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1722: x_msg_count,
1723: x_msg_data,
1724: '_PVT'
1725: );

Line 1742: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1738: x_return_status := 'E';
1739:
1740:
1741: WHEN Others THEN
1742: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1743: G_APP_NAME,
1744: G_PKG_NAME,
1745: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1746: x_msg_count,

Line 1745: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1741: WHEN Others THEN
1742: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1743: G_APP_NAME,
1744: G_PKG_NAME,
1745: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1746: x_msg_count,
1747: x_msg_data,
1748: '_PVT'
1749: );

Line 1780: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1776: --CLOSE Csr_Get_Timevalues;
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: ROLLBACK;
1780: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1781: G_APP_NAME,
1782: G_PKG_NAME,
1783: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1784: x_msg_count,

Line 1783: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1779: ROLLBACK;
1780: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1781: G_APP_NAME,
1782: G_PKG_NAME,
1783: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1784: x_msg_count,
1785: x_msg_data,
1786: '_PVT'
1787: );

Line 1912: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;

1908: L_OLD_CLE_ID NUMBER := -99999;
1909: L_CLE_ID NUMBER := -99999;
1910: l_duration NUMBER;
1911: l_period VArchar2(10);
1912: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1913: G_EXCEPTION_HALT EXCEPTION;
1914:
1915: l_start_rowid ROWID := p_start_rowid;
1916: l_end_rowid ROWID := p_end_rowid;

Line 2023: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2019: EXCEPTION
2020: WHEN G_EXCEPTION_HALT THEN
2021: ROLLBACK;
2022:
2023: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2024: G_APP_NAME,
2025: G_PKG_NAME,
2026: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2027: x_msg_count,

Line 2026: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2022:
2023: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2024: G_APP_NAME,
2025: G_PKG_NAME,
2026: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2027: x_msg_count,
2028: x_msg_data,
2029: '_PVT'
2030: );

Line 2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2043: x_message_data := l_message;
2044: x_return_status := 'E';
2045: WHEN Others THEN
2046: ROLLBACK;
2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2048: G_APP_NAME,
2049: G_PKG_NAME,
2050: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2051: x_msg_count,

Line 2050: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2046: ROLLBACK;
2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2048: G_APP_NAME,
2049: G_PKG_NAME,
2050: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2051: x_msg_count,
2052: x_msg_data,
2053: '_PVT'
2054: );

Line 2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2075: CLOSE Csr_Get_Bill_Types;
2076:
2077: EXCEPTION
2078: WHEN Others THEN
2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2080: G_APP_NAME,
2081: G_PKG_NAME,
2082: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2083: x_msg_count,

Line 2082: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2078: WHEN Others THEN
2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2080: G_APP_NAME,
2081: G_PKG_NAME,
2082: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2083: x_msg_count,
2084: x_msg_data,
2085: '_PVT'
2086: );

Line 2479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2475: EXCEPTION
2476: WHEN OTHERS THEN
2477: ROLLBACK;
2478:
2479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2480: G_APP_NAME,
2481: G_PKG_NAME,
2482: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2483: x_msg_count,

Line 2482: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2478:
2479: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2480: G_APP_NAME,
2481: G_PKG_NAME,
2482: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2483: x_msg_count,
2484: x_msg_data,
2485: '_PVT'
2486: );

Line 2499: x_return_status := OKC_API.G_RET_STS_ERROR;

2495:
2496: END LOOP;
2497: END IF;
2498:
2499: x_return_status := OKC_API.G_RET_STS_ERROR;
2500: END;
2501:
2502:
2503: PROCEDURE COVERAGE_HISTORY_MIGRATION ( p_start_rowid IN ROWID,

Line 2640: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;

2636: L_OLD_CLE_ID NUMBER := -99999;
2637: L_CLE_ID NUMBER := -99999;
2638: l_duration NUMBER;
2639: l_period VArchar2(10);
2640: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;
2641: l_transfer_option VArchar2(250);
2642: l_msg_index_out NUMBER;
2643:
2644: l_start_rowid ROWID := p_start_rowid;

Line 2685: OKC_API.SET_MESSAGE

2681: X_Period :=Lx_Period;
2682:
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: OKC_API.SET_MESSAGE
2686: (P_App_Name => G_APP_NAME_OKS
2687: ,P_Msg_Name => G_UNEXPECTED_ERROR
2688: ,P_Token1 => G_SQLCODE_TOKEN
2689: ,P_Token1_Value => SQLCODE

Line 3194: OKC_API.SET_MESSAGE

3190: WHEN G_EXCEPTION_HALT THEN
3191: -- dbms_output.put_line('Value of 1 ERROR '||SQLERRM);
3192: ROLLBACK;
3193:
3194: OKC_API.SET_MESSAGE
3195: ( p_app_name => G_APP_NAME,
3196: p_msg_name => G_UNEXPECTED_ERROR,
3197: p_token1 => G_SQLCODE_TOKEN,
3198: p_token1_value => SQLCODE,

Line 3206: x_return_status := OKC_API.G_RET_STS_ERROR;

3202: x_return_status := 'E';
3203: WHEN Others THEN
3204: -- dbms_output.put_line('Value of 2 ERROR '||SQLERRM);
3205:
3206: x_return_status := OKC_API.G_RET_STS_ERROR;
3207:
3208: OKC_API.SET_MESSAGE
3209: ( p_app_name => G_APP_NAME,
3210: p_msg_name => G_UNEXPECTED_ERROR,

Line 3208: OKC_API.SET_MESSAGE

3204: -- dbms_output.put_line('Value of 2 ERROR '||SQLERRM);
3205:
3206: x_return_status := OKC_API.G_RET_STS_ERROR;
3207:
3208: OKC_API.SET_MESSAGE
3209: ( p_app_name => G_APP_NAME,
3210: p_msg_name => G_UNEXPECTED_ERROR,
3211: p_token1 => G_SQLCODE_TOKEN,
3212: p_token1_value => SQLCODE,

Line 3231: x_return_status := OKC_API.G_RET_STS_ERROR;

3227:
3228: EXCEPTION
3229: WHEN Others THEN
3230:
3231: x_return_status := OKC_API.G_RET_STS_ERROR;
3232:
3233: OKC_API.SET_MESSAGE
3234: ( p_app_name => G_APP_NAME,
3235: p_msg_name => G_UNEXPECTED_ERROR,

Line 3233: OKC_API.SET_MESSAGE

3229: WHEN Others THEN
3230:
3231: x_return_status := OKC_API.G_RET_STS_ERROR;
3232:
3233: OKC_API.SET_MESSAGE
3234: ( p_app_name => G_APP_NAME,
3235: p_msg_name => G_UNEXPECTED_ERROR,
3236: p_token1 => G_SQLCODE_TOKEN,
3237: p_token1_value => SQLCODE,

Line 3378: l_return_Status VArchar2(3):= OKC_API.G_RET_STS_SUCCESS;

3374: L_OLD_CLE_ID NUMBER := -99999;
3375: L_CLE_ID NUMBER := -99999;
3376: l_duration NUMBER;
3377: l_period VArchar2(10);
3378: l_return_Status VArchar2(3):= OKC_API.G_RET_STS_SUCCESS;
3379: l_OU_CURRENCY VArchar2(10);
3380: L_MSG_INDEX_OUT number;
3381: l_message VArchar2(1000);
3382: l_start_rowid ROWID := p_start_rowid;

Line 3429: OKC_API.SET_MESSAGE

3425: X_Period :=Lx_Period;
3426:
3427: EXCEPTION
3428: WHEN OTHERS THEN
3429: OKC_API.SET_MESSAGE
3430: (P_App_Name => G_APP_NAME_OKS
3431: ,P_Msg_Name => G_UNEXPECTED_ERROR
3432: ,P_Token1 => G_SQLCODE_TOKEN
3433: ,P_Token1_Value => SQLCODE

Line 3508: OKC_API.SET_MESSAGE

3504: X_return_Status := 'S';
3505: EXCEPTION
3506: WHEN OTHERS THEN
3507: X_return_Status := 'E';
3508: OKC_API.SET_MESSAGE
3509: (P_App_Name => G_APP_NAME_OKS
3510: ,P_Msg_Name => G_UNEXPECTED_ERROR
3511: ,P_Token1 => G_SQLCODE_TOKEN
3512: ,P_Token1_Value => SQLCODE

Line 3775: x_return_status := OKC_API.G_RET_STS_ERROR;

3771: i_clev_tbl_in.delete;
3772: i_cvtv_tbl_in.delete;
3773:
3774:
3775: x_return_status := OKC_API.G_RET_STS_ERROR;
3776: OKC_API.SET_MESSAGE
3777: ( p_app_name => G_APP_NAME,
3778: p_msg_name => G_UNEXPECTED_ERROR,
3779: p_token1 => G_SQLCODE_TOKEN,

Line 3776: OKC_API.SET_MESSAGE

3772: i_cvtv_tbl_in.delete;
3773:
3774:
3775: x_return_status := OKC_API.G_RET_STS_ERROR;
3776: OKC_API.SET_MESSAGE
3777: ( p_app_name => G_APP_NAME,
3778: p_msg_name => G_UNEXPECTED_ERROR,
3779: p_token1 => G_SQLCODE_TOKEN,
3780: p_token1_value => SQLCODE,

Line 3792: x_return_status := OKC_API.G_RET_STS_ERROR;

3788: i_ctzv_tbl_in.delete;
3789: i_clev_tbl_in.delete;
3790: i_cvtv_tbl_in.delete;
3791:
3792: x_return_status := OKC_API.G_RET_STS_ERROR;
3793: OKC_API.SET_MESSAGE
3794: ( p_app_name => G_APP_NAME,
3795: p_msg_name => G_UNEXPECTED_ERROR,
3796: p_token1 => G_SQLCODE_TOKEN,

Line 3793: OKC_API.SET_MESSAGE

3789: i_clev_tbl_in.delete;
3790: i_cvtv_tbl_in.delete;
3791:
3792: x_return_status := OKC_API.G_RET_STS_ERROR;
3793: OKC_API.SET_MESSAGE
3794: ( p_app_name => G_APP_NAME,
3795: p_msg_name => G_UNEXPECTED_ERROR,
3796: p_token1 => G_SQLCODE_TOKEN,
3797: p_token1_value => SQLCODE,

Line 3809: x_return_status := OKC_API.G_RET_STS_ERROR;

3805: i_ctzv_tbl_in.delete;
3806: i_clev_tbl_in.delete;
3807: i_cvtv_tbl_in.delete;
3808:
3809: x_return_status := OKC_API.G_RET_STS_ERROR;
3810: OKC_API.SET_MESSAGE
3811: ( p_app_name => G_APP_NAME,
3812: p_msg_name => G_UNEXPECTED_ERROR,
3813: p_token1 => G_SQLCODE_TOKEN,

Line 3810: OKC_API.SET_MESSAGE

3806: i_clev_tbl_in.delete;
3807: i_cvtv_tbl_in.delete;
3808:
3809: x_return_status := OKC_API.G_RET_STS_ERROR;
3810: OKC_API.SET_MESSAGE
3811: ( p_app_name => G_APP_NAME,
3812: p_msg_name => G_UNEXPECTED_ERROR,
3813: p_token1 => G_SQLCODE_TOKEN,
3814: p_token1_value => SQLCODE,

Line 3829: x_return_status := OKC_API.G_RET_STS_ERROR;

3825: CLOSE Get_Buss_Process_Cur;
3826:
3827: EXCEPTION
3828: WHEN Others THEN
3829: x_return_status := OKC_API.G_RET_STS_ERROR;
3830: OKC_API.SET_MESSAGE
3831: ( p_app_name => G_APP_NAME,
3832: p_msg_name => G_UNEXPECTED_ERROR,
3833: p_token1 => G_SQLCODE_TOKEN,

Line 3830: OKC_API.SET_MESSAGE

3826:
3827: EXCEPTION
3828: WHEN Others THEN
3829: x_return_status := OKC_API.G_RET_STS_ERROR;
3830: OKC_API.SET_MESSAGE
3831: ( p_app_name => G_APP_NAME,
3832: p_msg_name => G_UNEXPECTED_ERROR,
3833: p_token1 => G_SQLCODE_TOKEN,
3834: p_token1_value => SQLCODE,

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

3906: Times_obj_version_number_TBL Num_Tbl_Type;
3907: Times_major_version_TBL Num_Tbl_Type;
3908:
3909: tablename1 VARCHAR2(1000);
3910: l_return_status VARCHAR2(1) :=OKC_API.G_RET_STS_SUCCESS;
3911: l_msg_count NUMBER;
3912:
3913: l_start_rowid ROWID := p_start_rowid;
3914: l_end_rowid ROWID := p_end_rowid;

Line 4168: x_return_status := OKC_API.G_RET_STS_ERROR;

4164:
4165: EXCEPTION
4166: WHEN G_EXCEPTION_HALT THEN
4167: ROLLBACK;
4168: x_return_status := OKC_API.G_RET_STS_ERROR;
4169: OKC_API.SET_MESSAGE
4170: ( p_app_name => G_APP_NAME,
4171: p_msg_name => G_UNEXPECTED_ERROR,
4172: p_token1 => G_SQLCODE_TOKEN,

Line 4169: OKC_API.SET_MESSAGE

4165: EXCEPTION
4166: WHEN G_EXCEPTION_HALT THEN
4167: ROLLBACK;
4168: x_return_status := OKC_API.G_RET_STS_ERROR;
4169: OKC_API.SET_MESSAGE
4170: ( p_app_name => G_APP_NAME,
4171: p_msg_name => G_UNEXPECTED_ERROR,
4172: p_token1 => G_SQLCODE_TOKEN,
4173: p_token1_value => SQLCODE,

Line 4178: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4174: p_token2 => G_SQLERRM_TOKEN,
4175: p_token2_value => SQLERRM
4176: );
4177:
4178: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4179: G_APP_NAME,
4180: G_PKG_NAME,
4181: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4182: x_msg_count,

Line 4181: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4177:
4178: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4179: G_APP_NAME,
4180: G_PKG_NAME,
4181: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4182: x_msg_count,
4183: x_msg_data,
4184: '_PVT'
4185: );

Line 4202: x_return_status := OKC_API.G_RET_STS_ERROR;

4198: x_message_data := l_message;
4199: x_return_status := 'E';
4200: WHEN Others THEN
4201: ROLLBACK;
4202: x_return_status := OKC_API.G_RET_STS_ERROR;
4203: OKC_API.SET_MESSAGE
4204: ( p_app_name => G_APP_NAME,
4205: p_msg_name => G_UNEXPECTED_ERROR,
4206: p_token1 => G_SQLCODE_TOKEN,

Line 4203: OKC_API.SET_MESSAGE

4199: x_return_status := 'E';
4200: WHEN Others THEN
4201: ROLLBACK;
4202: x_return_status := OKC_API.G_RET_STS_ERROR;
4203: OKC_API.SET_MESSAGE
4204: ( p_app_name => G_APP_NAME,
4205: p_msg_name => G_UNEXPECTED_ERROR,
4206: p_token1 => G_SQLCODE_TOKEN,
4207: p_token1_value => SQLCODE,

Line 4212: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4208: p_token2 => G_SQLERRM_TOKEN,
4209: p_token2_value => SQLERRM
4210: );
4211:
4212: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4213: G_APP_NAME,
4214: G_PKG_NAME,
4215: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4216: x_msg_count,

Line 4215: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4211:
4212: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4213: G_APP_NAME,
4214: G_PKG_NAME,
4215: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4216: x_msg_count,
4217: x_msg_data,
4218: '_PVT'
4219: );

Line 4242: x_return_status := OKC_API.G_RET_STS_ERROR;

4238: CLOSE Csr_Get_Coverage_times;
4239: EXCEPTION
4240: WHEN Others THEN
4241: Raise;
4242: x_return_status := OKC_API.G_RET_STS_ERROR;
4243: OKC_API.SET_MESSAGE
4244: ( p_app_name => G_APP_NAME,
4245: p_msg_name => G_UNEXPECTED_ERROR,
4246: p_token1 => G_SQLCODE_TOKEN,

Line 4243: OKC_API.SET_MESSAGE

4239: EXCEPTION
4240: WHEN Others THEN
4241: Raise;
4242: x_return_status := OKC_API.G_RET_STS_ERROR;
4243: OKC_API.SET_MESSAGE
4244: ( p_app_name => G_APP_NAME,
4245: p_msg_name => G_UNEXPECTED_ERROR,
4246: p_token1 => G_SQLCODE_TOKEN,
4247: p_token1_value => SQLCODE,

Line 4252: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4248: p_token2 => G_SQLERRM_TOKEN,
4249: p_token2_value => SQLERRM
4250: );
4251:
4252: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4253: G_APP_NAME,
4254: G_PKG_NAME,
4255: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4256: x_msg_count,

Line 4255: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4251:
4252: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4253: G_APP_NAME,
4254: G_PKG_NAME,
4255: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4256: x_msg_count,
4257: x_msg_data,
4258: '_PVT'
4259: );

Line 4419: l_return_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4415:
4416: L_OLD_CLE_ID NUMBER := -99999;
4417: L_CLE_ID NUMBER := -99999;
4418: l_cle_ctr NUMBER := 0;
4419: l_return_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4420: x_msg_count NUMBER := 0;
4421: x_msg_data VArchar2(1000);
4422:
4423: l_start_rowid ROWID := p_start_rowid;

Line 4585: x_return_status := OKC_API.G_RET_STS_ERROR;

4581: ROLLBACK;
4582: i_actv_tbl_in.DELETE;
4583: i_clev_tbl_in.DELETE;
4584:
4585: x_return_status := OKC_API.G_RET_STS_ERROR;
4586: OKC_API.SET_MESSAGE
4587: ( p_app_name => G_APP_NAME,
4588: p_msg_name => G_UNEXPECTED_ERROR,
4589: p_token1 => G_SQLCODE_TOKEN,

Line 4586: OKC_API.SET_MESSAGE

4582: i_actv_tbl_in.DELETE;
4583: i_clev_tbl_in.DELETE;
4584:
4585: x_return_status := OKC_API.G_RET_STS_ERROR;
4586: OKC_API.SET_MESSAGE
4587: ( p_app_name => G_APP_NAME,
4588: p_msg_name => G_UNEXPECTED_ERROR,
4589: p_token1 => G_SQLCODE_TOKEN,
4590: p_token1_value => SQLCODE,

Line 4595: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4591: p_token2 => G_SQLERRM_TOKEN,
4592: p_token2_value => SQLERRM
4593: );
4594:
4595: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4596: G_APP_NAME,
4597: G_PKG_NAME,
4598: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4599: x_msg_count,

Line 4598: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4594:
4595: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4596: G_APP_NAME,
4597: G_PKG_NAME,
4598: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4599: x_msg_count,
4600: x_msg_data,
4601: '_PVT'
4602: );

Line 4620: x_return_status := OKC_API.G_RET_STS_ERROR;

4616: ROLLBACK;
4617: i_actv_tbl_in.DELETE;
4618: i_clev_tbl_in.DELETE;
4619:
4620: x_return_status := OKC_API.G_RET_STS_ERROR;
4621: OKC_API.SET_MESSAGE
4622: ( p_app_name => G_APP_NAME,
4623: p_msg_name => G_UNEXPECTED_ERROR,
4624: p_token1 => G_SQLCODE_TOKEN,

Line 4621: OKC_API.SET_MESSAGE

4617: i_actv_tbl_in.DELETE;
4618: i_clev_tbl_in.DELETE;
4619:
4620: x_return_status := OKC_API.G_RET_STS_ERROR;
4621: OKC_API.SET_MESSAGE
4622: ( p_app_name => G_APP_NAME,
4623: p_msg_name => G_UNEXPECTED_ERROR,
4624: p_token1 => G_SQLCODE_TOKEN,
4625: p_token1_value => SQLCODE,

Line 4630: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4626: p_token2 => G_SQLERRM_TOKEN,
4627: p_token2_value => SQLERRM
4628: );
4629:
4630: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4631: G_APP_NAME,
4632: G_PKG_NAME,
4633: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4634: x_msg_count,

Line 4633: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4629:
4630: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4631: G_APP_NAME,
4632: G_PKG_NAME,
4633: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4634: x_msg_count,
4635: x_msg_data,
4636: '_PVT'
4637: );

Line 4935: OKC_API.SET_MESSAGE

4931: EXCEPTION
4932: WHEN G_EXCEPTION_HALT THEN
4933:
4934: ROLLBACK;
4935: OKC_API.SET_MESSAGE
4936: ( p_app_name => G_APP_NAME,
4937: p_msg_name => G_UNEXPECTED_ERROR,
4938: p_token1 => G_SQLCODE_TOKEN,
4939: p_token1_value => SQLCODE,

Line 4944: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4940: p_token2 => G_SQLERRM_TOKEN,
4941: p_token2_value => SQLERRM
4942: );
4943:
4944: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4945: G_APP_NAME,
4946: G_PKG_NAME,
4947: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4948: x_msg_count,

Line 4947: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4943:
4944: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4945: G_APP_NAME,
4946: G_PKG_NAME,
4947: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4948: x_msg_count,
4949: x_msg_data,
4950: '_PVT'
4951: );

Line 4968: x_return_status := OKC_API.G_RET_STS_ERROR;

4964: x_return_status := 'E';
4965:
4966:
4967: WHEN Others THEN
4968: x_return_status := OKC_API.G_RET_STS_ERROR;
4969: OKC_API.SET_MESSAGE
4970: ( p_app_name => G_APP_NAME,
4971: p_msg_name => G_UNEXPECTED_ERROR,
4972: p_token1 => G_SQLCODE_TOKEN,

Line 4969: OKC_API.SET_MESSAGE

4965:
4966:
4967: WHEN Others THEN
4968: x_return_status := OKC_API.G_RET_STS_ERROR;
4969: OKC_API.SET_MESSAGE
4970: ( p_app_name => G_APP_NAME,
4971: p_msg_name => G_UNEXPECTED_ERROR,
4972: p_token1 => G_SQLCODE_TOKEN,
4973: p_token1_value => SQLCODE,

Line 4977: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

4973: p_token1_value => SQLCODE,
4974: p_token2 => G_SQLERRM_TOKEN,
4975: p_token2_value => SQLERRM
4976: );
4977: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4978: G_APP_NAME,
4979: G_PKG_NAME,
4980: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4981: x_msg_count,

Line 4980: 'OKC_API.G_RET_STS_UNEXP_ERROR',

4976: );
4977: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
4978: G_APP_NAME,
4979: G_PKG_NAME,
4980: 'OKC_API.G_RET_STS_UNEXP_ERROR',
4981: x_msg_count,
4982: x_msg_data,
4983: '_PVT'
4984: );

Line 5149: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;

5145: L_OLD_CLE_ID NUMBER := -99999;
5146: L_CLE_ID NUMBER := -99999;
5147: l_duration NUMBER;
5148: l_period VArchar2(10);
5149: l_return_status VArchar2(1) := OKC_API.G_RET_STS_SUCCESS;
5150: G_EXCEPTION_HALT EXCEPTION;
5151:
5152: l_start_rowid ROWID := p_start_rowid;
5153: l_end_rowid ROWID := p_end_rowid;

Line 5291: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5287: EXCEPTION
5288: WHEN G_EXCEPTION_HALT THEN
5289: ROLLBACK;
5290:
5291: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5292: G_APP_NAME,
5293: G_PKG_NAME,
5294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5295: x_msg_count,

Line 5294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

5290:
5291: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5292: G_APP_NAME,
5293: G_PKG_NAME,
5294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5295: x_msg_count,
5296: x_msg_data,
5297: '_PVT'
5298: );

Line 5315: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5311: x_message_data := l_message;
5312: x_return_status := 'E';
5313: WHEN Others THEN
5314: ROLLBACK;
5315: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5316: G_APP_NAME,
5317: G_PKG_NAME,
5318: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5319: x_msg_count,

Line 5318: 'OKC_API.G_RET_STS_UNEXP_ERROR',

5314: ROLLBACK;
5315: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5316: G_APP_NAME,
5317: G_PKG_NAME,
5318: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5319: x_msg_count,
5320: x_msg_data,
5321: '_PVT'
5322: );

Line 5347: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

5343: CLOSE Csr_Get_Bill_Types;
5344:
5345: EXCEPTION
5346: WHEN Others THEN
5347: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5348: G_APP_NAME,
5349: G_PKG_NAME,
5350: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5351: x_msg_count,

Line 5350: 'OKC_API.G_RET_STS_UNEXP_ERROR',

5346: WHEN Others THEN
5347: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
5348: G_APP_NAME,
5349: G_PKG_NAME,
5350: 'OKC_API.G_RET_STS_UNEXP_ERROR',
5351: x_msg_count,
5352: x_msg_data,
5353: '_PVT'
5354: );