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_INSERT_ROW_UPG dependencies on OKC_API

Line 33: x_return_status := OKC_API.G_RET_STS_SUCCESS;

29: i NUMBER := P_CTZV_TBL.FIRST;
30: j NUMBER := 0;
31:
32: BEGIN
33: x_return_status := OKC_API.G_RET_STS_SUCCESS;
34: IF (l_debug = 'Y') THEN
35: okc_debug.Set_Indentation('OKS_CTZ_PVT');
36: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
37: END IF;

Line 111: OKC_API.SET_MESSAGE(

107: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
108: okc_debug.Reset_Indentation;
109: END IF;
110:
111: OKC_API.SET_MESSAGE(
112: p_app_name => G_APP_NAME,
113: p_msg_name => G_UNEXPECTED_ERROR,
114: p_token1 => G_SQLCODE_TOKEN,
115: p_token1_value => SQLCODE,

Line 119: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

115: p_token1_value => SQLCODE,
116: p_token2 => G_SQLERRM_TOKEN,
117: p_token2_value => SQLERRM);
118:
119: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
120:
121: END INSERT_ROW_UPG_CTZV_TBL;
122:
123:

Line 159: x_return_status := OKC_API.G_RET_STS_SUCCESS;

155: i NUMBER := P_CVTV_TBL.FIRST;
156: j NUMBER := 0;
157:
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: IF (l_debug = 'Y') THEN
161: okc_debug.Set_Indentation('OKS_CVT_PVT');
162: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
163: END IF;

Line 260: OKC_API.SET_MESSAGE(

256: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
257: okc_debug.Reset_Indentation;
258: END IF;
259:
260: OKC_API.SET_MESSAGE(
261: p_app_name => G_APP_NAME,
262: p_msg_name => G_UNEXPECTED_ERROR,
263: p_token1 => G_SQLCODE_TOKEN,
264: p_token1_value => SQLCODE,

Line 267: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

263: p_token1 => G_SQLCODE_TOKEN,
264: p_token1_value => SQLCODE,
265: p_token2 => G_SQLERRM_TOKEN,
266: p_token2_value => SQLERRM);
267: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
268:
269: END INSERT_ROW_UPG_CVTV_TBL;
270:
271: PROCEDURE INSERT_ROW_UPG_ACMV_TBL

Line 304: x_return_status := OKC_API.G_RET_STS_SUCCESS;

300: In_LAST_UPDATE_LOGIN OKC_DATATYPES.NumberTabTyp;
301: i NUMBER := P_ACMV_TBL.FIRST;
302: j NUMBER := 0;
303: BEGIN
304: x_return_status := OKC_API.G_RET_STS_SUCCESS;
305:
306: IF (l_debug = 'Y') THEN
307: okc_debug.Set_Indentation('OKS_ACM_PVT');
308: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line 401: OKC_API.SET_MESSAGE(

397: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
398: okc_debug.Reset_Indentation;
399: END IF;
400:
401: OKC_API.SET_MESSAGE(
402: p_app_name => G_APP_NAME,
403: p_msg_name => G_UNEXPECTED_ERROR,
404: p_token1 => G_SQLCODE_TOKEN,
405: p_token1_value => SQLCODE,

Line 408: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

404: p_token1 => G_SQLCODE_TOKEN,
405: p_token1_value => SQLCODE,
406: p_token2 => G_SQLERRM_TOKEN,
407: p_token2_value => SQLERRM);
408: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
409:
410: END INSERT_ROW_UPG_ACMV_TBL;
411:
412:

Line 438: x_return_status := OKC_API.G_RET_STS_SUCCESS;

434: In_OBJECT_VERSION_NUMBER OKC_DATATYPES.NumberTabTyp;
435: i NUMBER := P_ACTV_TBL.FIRST;
436: j NUMBER := 0;
437: BEGIN
438: x_return_status := OKC_API.G_RET_STS_SUCCESS;
439:
440: IF (l_debug = 'Y') THEN
441: okc_debug.Set_Indentation('OKS_ACT_PVT');
442: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line 511: OKC_API.SET_MESSAGE(

507: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
508: okc_debug.Reset_Indentation;
509: END IF;
510:
511: OKC_API.SET_MESSAGE(
512: p_app_name => G_APP_NAME,
513: p_msg_name => G_UNEXPECTED_ERROR,
514: p_token1 => G_SQLCODE_TOKEN,
515: p_token1_value => SQLCODE,

Line 519: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

515: p_token1_value => SQLCODE,
516: p_token2 => G_SQLERRM_TOKEN,
517: p_token2_value => SQLERRM);
518:
519: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
520:
521: END INSERT_ROW_UPG_ACTV_TBL;
522:
523:

Line 627: x_return_status := OKC_API.G_RET_STS_SUCCESS;

623: In_LAST_UPDATE_LOGIN OKC_DATATYPES.NumberTabTyp;
624: i NUMBER := P_KLNV_TBL.FIRST;
625: j NUMBER := 0;
626: BEGIN
627: x_return_status := OKC_API.G_RET_STS_SUCCESS;
628:
629: IF (l_debug = 'Y') THEN
630: okc_debug.Set_Indentation('OKS_KLN_PVT');
631: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);

Line 954: OKC_API.SET_MESSAGE(

950: IF (l_debug = 'Y') THEN
951: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
952: okc_debug.Reset_Indentation;
953: END IF;
954: OKC_API.SET_MESSAGE(
955: p_app_name => G_APP_NAME,
956: p_msg_name => G_UNEXPECTED_ERROR,
957: p_token1 => G_SQLCODE_TOKEN,
958: p_token1_value => SQLCODE,

Line 961: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

957: p_token1 => G_SQLCODE_TOKEN,
958: p_token1_value => SQLCODE,
959: p_token2 => G_SQLERRM_TOKEN,
960: p_token2_value => SQLERRM);
961: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
962: END INSERT_ROW_UPG_KLNV_TBL;
963:
964: PROCEDURE INSERT_ROW_UPG_bill_sch
965: (x_return_status OUT NOCOPY VARCHAR2,

Line 1008: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1004: In_OBJECT_VERSION_NUMBER OKC_DATATYPES.NumberTabTyp;
1005: i NUMBER := p_oks_billrate_schedules_v_tbl.FIRST;
1006: j NUMBER := 0;
1007: BEGIN
1008: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1009: IF (l_debug = 'Y') THEN
1010: okc_debug.Set_Indentation('OKS_BRS_PVT');
1011: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1012: END IF;

Line 1137: OKC_API.SET_MESSAGE(

1133: IF (l_debug = 'Y') THEN
1134: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1135: okc_debug.Reset_Indentation;
1136: END IF;
1137: OKC_API.SET_MESSAGE(
1138: p_app_name => G_APP_NAME,
1139: p_msg_name => G_UNEXPECTED_ERROR,
1140: p_token1 => G_SQLCODE_TOKEN,
1141: p_token1_value => SQLCODE,

Line 1144: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1140: p_token1 => G_SQLCODE_TOKEN,
1141: p_token1_value => SQLCODE,
1142: p_token2 => G_SQLERRM_TOKEN,
1143: p_token2_value => SQLERRM);
1144: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1145: END INSERT_ROW_UPG_bill_sch;
1146:
1147: PROCEDURE INSERT_ROW_UPG_KHRV_TBL
1148: (x_return_status OUT NOCOPY VARCHAR2,

Line 1226: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1222: In_COMMITMENT_ID OKC_DATATYPES.NumberTabTyp;
1223: i NUMBER := P_KHRV_TBL.FIRST;
1224: j NUMBER := 0;
1225: BEGIN
1226: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1227: IF (l_debug = 'Y') THEN
1228: okc_debug.Set_Indentation('OKS_KHR_PVT');
1229: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1230: END IF;

Line 1453: OKC_API.SET_MESSAGE(

1449: IF (l_debug = 'Y') THEN
1450: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1451: okc_debug.Reset_Indentation;
1452: END IF;
1453: OKC_API.SET_MESSAGE(
1454: p_app_name => G_APP_NAME,
1455: p_msg_name => G_UNEXPECTED_ERROR,
1456: p_token1 => G_SQLCODE_TOKEN,
1457: p_token1_value => SQLCODE,

Line 1460: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1456: p_token1 => G_SQLCODE_TOKEN,
1457: p_token1_value => SQLCODE,
1458: p_token2 => G_SQLERRM_TOKEN,
1459: p_token2_value => SQLERRM);
1460: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1461: END INSERT_ROW_UPG_KHRV_TBL;
1462:
1463:
1464: PROCEDURE INSERT_ROW_UPG_sllv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_sllv_tbl OKS_SLL_PVT.sllv_tbl_type) IS

Line 1497: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1493: i NUMBER := p_sllv_tbl.FIRST;
1494: j NUMBER := 0;
1495:
1496: BEGIN
1497: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1498: IF (l_debug = 'Y') THEN
1499: okc_debug.Set_Indentation('OKS_SLL_PVT');
1500: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1501: END IF;

Line 1597: OKC_API.SET_MESSAGE(

1593: IF (l_debug = 'Y') THEN
1594: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1595: okc_debug.Reset_Indentation;
1596: END IF;
1597: OKC_API.SET_MESSAGE(
1598: p_app_name => G_APP_NAME,
1599: p_msg_name => G_UNEXPECTED_ERROR,
1600: p_token1 => G_SQLCODE_TOKEN,
1601: p_token1_value => SQLCODE,

Line 1604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1600: p_token1 => G_SQLCODE_TOKEN,
1601: p_token1_value => SQLCODE,
1602: p_token2 => G_SQLERRM_TOKEN,
1603: p_token2_value => SQLERRM);
1604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1605: END INSERT_ROW_UPG_sllv_tbl;
1606:
1607:
1608: PROCEDURE INSERT_ROW_UPG_letv_tbl (x_return_status OUT NOCOPY VARCHAR2, p_letv_tbl OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type) IS

Line 1638: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1634: i NUMBER := p_letv_tbl.FIRST;
1635: j NUMBER := 0;
1636:
1637: BEGIN
1638: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1639: IF (l_debug = 'Y') THEN
1640: okc_debug.Set_Indentation('OKS_BILL_LEVEL_ELEMENTS_PVT');
1641: okc_debug.log('23400: Entered INSERT_ROW_UPG', 2);
1642: END IF;

Line 1728: OKC_API.SET_MESSAGE(

1724: okc_debug.log('23600: Exiting INSERT_ROW_UPG:OTHERS Exception', 2);
1725: okc_debug.Reset_Indentation;
1726: END IF;
1727:
1728: OKC_API.SET_MESSAGE(
1729: p_app_name => G_APP_NAME,
1730: p_msg_name => G_UNEXPECTED_ERROR,
1731: p_token1 => G_SQLCODE_TOKEN,
1732: p_token1_value => SQLCODE,

Line 1735: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1731: p_token1 => G_SQLCODE_TOKEN,
1732: p_token1_value => SQLCODE,
1733: p_token2 => G_SQLERRM_TOKEN,
1734: p_token2_value => SQLERRM);
1735: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1736: END INSERT_ROW_UPG_letv_tbl;
1737:
1738:
1739:

Line 1782: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1778: j NUMBER := 0;
1779:
1780:
1781: BEGIN
1782: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1783:
1784: IF (l_debug = 'Y') THEN
1785: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');
1786: okc_debug.log('23400: Entered INSERT_ROW_SUBHDR_UPG', 2);

Line 1906: OKC_API.SET_MESSAGE(

1902: okc_debug.log('23600: Exiting INSERT_ROW_SUBHDR_UPG:OTHERS Exception', 2);
1903: okc_debug.Reset_Indentation;
1904: END IF;
1905:
1906: OKC_API.SET_MESSAGE(
1907: p_app_name => G_APP_NAME,
1908: p_msg_name => G_UNEXPECTED_ERROR,
1909: p_token1 => G_SQLCODE_TOKEN,
1910: p_token1_value => SQLCODE,

Line 1914: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1910: p_token1_value => SQLCODE,
1911: p_token2 => G_SQLERRM_TOKEN,
1912: p_token2_value => SQLERRM);
1913:
1914: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1915:
1916: END INSERT_BY_TBL_SUBHDR;
1917:
1918:

Line 1951: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1947:
1948:
1949:
1950: BEGIN
1951: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1952:
1953: IF (l_debug = 'Y') THEN
1954: okc_debug.Set_Indentation('OKS_SUBSCR_HDR_PVT');
1955: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBPTNS', 2);

Line 2031: OKC_API.SET_MESSAGE(

2027: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBPTNS:OTHERS Exception', 2);
2028: okc_debug.Reset_Indentation;
2029: END IF;
2030:
2031: OKC_API.SET_MESSAGE(
2032: p_app_name => G_APP_NAME,
2033: p_msg_name => G_UNEXPECTED_ERROR,
2034: p_token1 => G_SQLCODE_TOKEN,
2035: p_token1_value => SQLCODE,

Line 2039: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2035: p_token1_value => SQLCODE,
2036: p_token2 => G_SQLERRM_TOKEN,
2037: p_token2_value => SQLERRM);
2038:
2039: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2040:
2041: END INSERT_BY_TBL_SUBPTNS;
2042: -----------------------------------------------------------------------------
2043: --------- INSERT_BY_TBL_SUBPTNS

Line 2087: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2083:
2084:
2085:
2086: BEGIN
2087: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2088:
2089: IF (l_debug = 'Y') THEN
2090: okc_debug.Set_Indentation('OKS_SUBSCR_ELEMS_PVT');
2091: okc_debug.log('23400: Entered INSERT_BY_TBL_SUBELMNTS', 2);

Line 2178: OKC_API.SET_MESSAGE(

2174: okc_debug.log('23600: Exiting INSERT_BY_TBL_SUBELMNTS:OTHERS Exception', 2);
2175: okc_debug.Reset_Indentation;
2176: END IF;
2177:
2178: OKC_API.SET_MESSAGE(
2179: p_app_name => G_APP_NAME,
2180: p_msg_name => G_UNEXPECTED_ERROR,
2181: p_token1 => G_SQLCODE_TOKEN,
2182: p_token1_value => SQLCODE,

Line 2186: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2182: p_token1_value => SQLCODE,
2183: p_token2 => G_SQLERRM_TOKEN,
2184: p_token2_value => SQLERRM);
2185:
2186: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2187:
2188:
2189: END INSERT_BY_TBL_SUBELMNTS;
2190: