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

Line 49: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_khrv_tbl IN khrv_tbl_type,
48: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
49: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
50: p_validate_yn IN VARCHAR2) IS
51: BEGIN
52: x_return_status := G_RET_STS_SUCCESS;
53: IF p_validate_yn = 'Y' THEN

Line 160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_khrv_tbl IN khrv_tbl_type,
159: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
161: p_validate_yn IN VARCHAR2) IS
162: BEGIN
163: x_return_status := G_RET_STS_SUCCESS;
164: IF p_validate_yn = 'Y' THEN

Line 253: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_khrv_tbl IN khrv_tbl_type,
253: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
254: BEGIN
255: oks_khr_pvt.lock_row
256: (
257: p_api_version => p_api_version,

Line 312: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_khrv_tbl IN khrv_tbl_type,
312: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
313: BEGIN
314: oks_khr_pvt.delete_row
315: (
316: p_api_version => p_api_version,

Line 363: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_khrv_tbl IN khrv_tbl_type,
363: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
364: BEGIN
365: x_return_status := G_RET_STS_SUCCESS;
366: END validate_header;
367:

Line 388: OKC_API.init_msg_list(p_init_msg_list);

384: x_msg_data OUT NOCOPY VARCHAR2,
385: p_chr_id IN NUMBER,
386: p_major_version IN NUMBER) IS
387: BEGIN
388: OKC_API.init_msg_list(p_init_msg_list);
389: x_return_status := G_RET_STS_SUCCESS;
390:
391: -- Versioning OKS_K_HEADERS_B
392: -- Inserting single record

Line 833: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

829: );
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
834: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
835: p_msg_name => G_UNEXPECTED_ERROR,
836: p_token1 => G_SQLCODE_TOKEN,
837: p_token1_value => SQLCODE,

Line 834: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
834: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
835: p_msg_name => G_UNEXPECTED_ERROR,
836: p_token1 => G_SQLCODE_TOKEN,
837: p_token1_value => SQLCODE,
838: p_token2 => G_SQLERRM_TOKEN,

Line 877: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

873: p_major_version => l_major_version
874: );
875: EXCEPTION
876: WHEN invalid_version THEN
877: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
878: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
879: p_msg_name => G_UNEXPECTED_ERROR,
880: p_token1 => G_SQLCODE_TOKEN,
881: p_token1_value => SQLCODE,

Line 878: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

874: );
875: EXCEPTION
876: WHEN invalid_version THEN
877: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
878: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
879: p_msg_name => G_UNEXPECTED_ERROR,
880: p_token1 => G_SQLCODE_TOKEN,
881: p_token1_value => SQLCODE,
882: p_token2 => G_SQLERRM_TOKEN,

Line 886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

882: p_token2 => G_SQLERRM_TOKEN,
883: p_token2_value => SQLERRM
884: );
885: WHEN OTHERS THEN
886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
887: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
888: p_msg_name => G_UNEXPECTED_ERROR,
889: p_token1 => G_SQLCODE_TOKEN,
890: p_token1_value => SQLCODE,

Line 887: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

883: p_token2_value => SQLERRM
884: );
885: WHEN OTHERS THEN
886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
887: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
888: p_msg_name => G_UNEXPECTED_ERROR,
889: p_token1 => G_SQLCODE_TOKEN,
890: p_token1_value => SQLCODE,
891: p_token2 => G_SQLERRM_TOKEN,

Line 934: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

930: p_major_version => - 1
931: );
932: EXCEPTION
933: WHEN OTHERS THEN
934: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
936: p_msg_name => G_UNEXPECTED_ERROR,
937: p_token1 => G_SQLCODE_TOKEN,
938: p_token1_value => SQLCODE,

Line 935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

931: );
932: EXCEPTION
933: WHEN OTHERS THEN
934: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
936: p_msg_name => G_UNEXPECTED_ERROR,
937: p_token1 => G_SQLCODE_TOKEN,
938: p_token1_value => SQLCODE,
939: p_token2 => G_SQLERRM_TOKEN,

Line 952: OKC_API.init_msg_list(p_init_msg_list);

948: x_msg_count OUT NOCOPY NUMBER,
949: x_msg_data OUT NOCOPY VARCHAR2,
950: p_chr_id IN NUMBER) IS
951: BEGIN
952: OKC_API.init_msg_list(p_init_msg_list);
953: x_return_status := G_RET_STS_SUCCESS;
954: DELETE oks_k_lines_tlh
955: WHERE id IN
956: (SELECT id FROM oks_k_lines_bh

Line 980: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

976: );
977:
978: EXCEPTION
979: WHEN OTHERS THEN
980: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
981: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
982: p_msg_name => G_UNEXPECTED_ERROR,
983: p_token1 => G_SQLCODE_TOKEN,
984: p_token1_value => SQLCODE,

Line 981: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

977:
978: EXCEPTION
979: WHEN OTHERS THEN
980: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
981: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
982: p_msg_name => G_UNEXPECTED_ERROR,
983: p_token1 => G_SQLCODE_TOKEN,
984: p_token1_value => SQLCODE,
985: p_token2 => G_SQLERRM_TOKEN,

Line 1016: OKC_API.init_msg_list(p_init_msg_list);

1012: x_msg_count OUT NOCOPY NUMBER,
1013: x_msg_data OUT NOCOPY VARCHAR2,
1014: p_chr_id IN NUMBER) IS
1015: BEGIN
1016: OKC_API.init_msg_list(p_init_msg_list);
1017: x_return_status := G_RET_STS_SUCCESS;
1018:
1019: DELETE oks_k_lines_tl
1020: WHERE id IN

Line 1466: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1462: );
1463:
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1467: OKC_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,

Line 1467: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1463:
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1467: OKC_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 1484: OKC_API.init_msg_list(p_init_msg_list);

1480: x_msg_count OUT NOCOPY NUMBER,
1481: x_msg_data OUT NOCOPY VARCHAR2,
1482: p_chr_id IN NUMBER) IS
1483: BEGIN
1484: OKC_API.init_msg_list(p_init_msg_list);
1485: x_return_status := G_RET_STS_SUCCESS;
1486: DELETE oks_k_lines_tlh
1487: WHERE id IN
1488: (SELECT id FROM oks_k_lines_bh

Line 1509: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1505: );
1506:
1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1510: p_msg_name => G_UNEXPECTED_ERROR,
1511: p_token1 => G_SQLCODE_TOKEN,
1512: p_token1_value => SQLCODE,
1513: p_token2 => G_SQLERRM_TOKEN,

Line 1516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1512: p_token1_value => SQLCODE,
1513: p_token2 => G_SQLERRM_TOKEN,
1514: p_token2_value => SQLERRM
1515: );
1516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1517: END delete_history;
1518:
1519: ---------------------------------------------------------------
1520: -- Procedure for mass insert in OKS_K_HEADERS_B table

Line 1619: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1615: j NUMBER;
1616:
1617: BEGIN
1618: -- Initialize return status
1619: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1620:
1621: i := p_khrv_tbl.FIRST; j := 0;
1622: WHILE i IS NOT NULL
1623: LOOP

Line 1896: OKC_API.SET_MESSAGE(

1892: EXCEPTION
1893: WHEN OTHERS THEN
1894:
1895: -- store SQL error message on message stack
1896: OKC_API.SET_MESSAGE(
1897: p_app_name => G_APP_NAME,
1898: p_msg_name => G_UNEXPECTED_ERROR,
1899: p_token1 => G_SQLCODE_TOKEN,
1900: p_token1_value => SQLCODE,

Line 1904: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1900: p_token1_value => SQLCODE,
1901: p_token2 => G_SQLERRM_TOKEN,
1902: p_token2_value => SQLERRM);
1903: -- notify caller of an error as UNEXPETED error
1904: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1905: --RAISE;
1906: END INSERT_ROW_UPG;
1907:
1908: ---------------------------------------------------------------

Line 2010: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2006:
2007:
2008: BEGIN
2009: -- Initialize return status
2010: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2011:
2012: i := p_khrhv_tbl.FIRST;
2013: j := 0;
2014:

Line 2300: OKC_API.SET_MESSAGE(

2296:
2297: EXCEPTION
2298: WHEN OTHERS THEN
2299: -- store SQL error message on message stack
2300: OKC_API.SET_MESSAGE(
2301: p_app_name => G_APP_NAME,
2302: p_msg_name => G_UNEXPECTED_ERROR,
2303: p_token1 => G_SQLCODE_TOKEN,
2304: p_token1_value => SQLCODE,

Line 2308: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2304: p_token1_value => SQLCODE,
2305: p_token2 => G_SQLERRM_TOKEN,
2306: p_token2_value => SQLERRM);
2307: -- notify caller of an error as UNEXPETED error
2308: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2309:
2310: END CREATE_HDR_VERSION_UPG;
2311:
2312: