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

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

955: ----------------------------------------------------
956: PROCEDURE validate_party(
957: x_return_status OUT NOCOPY VARCHAR2,
958: p_party_id IN NUMBER) IS
959: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
960: l_party_id VARCHAR2(1);
961: l_row_not_found BOOLEAN := FALSE;
962: CURSOR c1(p_party_id NUMBER) IS
963: SELECT '1'

Line 969: x_return_status := OKC_API.G_RET_STS_SUCCESS;

965: WHERE party_id = p_party_id ;
966: BEGIN
967: IF ( p_party_id IS NOT NULL) THEN
968: -- initialize return status
969: x_return_status := OKC_API.G_RET_STS_SUCCESS;
970: OPEN c1(p_party_id );
971: FETCH c1 INTO l_party_id;
972: l_row_not_found := c1%NOTFOUND;
973: CLOSE c1;

Line 975: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');

971: FETCH c1 INTO l_party_id;
972: l_row_not_found := c1%NOTFOUND;
973: CLOSE c1;
974: IF l_row_not_found THEN
975: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');
976: x_return_status := OKC_API.G_RET_STS_ERROR;
977: END IF;
978: END IF;
979: EXCEPTION

Line 976: x_return_status := OKC_API.G_RET_STS_ERROR;

972: l_row_not_found := c1%NOTFOUND;
973: CLOSE c1;
974: IF l_row_not_found THEN
975: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');
976: x_return_status := OKC_API.G_RET_STS_ERROR;
977: END IF;
978: END IF;
979: EXCEPTION
980: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 987: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

983: NULL;
984:
985: WHEN OTHERS THEN
986: -- store SQL error message on message stack for caller
987: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
988:
989: p_msg_name => g_unexpected_error,
990: p_token1 => g_sqlcode_token,
991: p_token1_value => SQLCODE,

Line 996: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

992: p_token2 => g_sqlerrm_token,
993: p_token2_value => SQLERRM);
994:
995: -- notify caller of an UNEXPECTED error
996: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
997: END validate_party;
998: ----------------------------------------------------
999: -- Validate_Attributes for: cust_account_id --
1000: ----------------------------------------------------

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

1000: ----------------------------------------------------
1001: PROCEDURE validate_cust_account(
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: p_cust_account_id IN NUMBER) IS
1004: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1005: l_cust_account_id VARCHAR2(1);
1006: l_row_not_found BOOLEAN := FALSE;
1007: CURSOR c1(p_cust_account_id NUMBER) IS
1008: SELECT '1'

Line 1015: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1011: BEGIN
1012:
1013: -- initialize return status
1014: IF ( p_cust_account_id IS NOT NULL) THEN
1015: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1016: OPEN c1(p_cust_account_id );
1017: FETCH c1 INTO l_cust_account_id;
1018: l_row_not_found := c1%NOTFOUND;
1019: CLOSE c1;

Line 1021: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');

1017: FETCH c1 INTO l_cust_account_id;
1018: l_row_not_found := c1%NOTFOUND;
1019: CLOSE c1;
1020: IF l_row_not_found THEN
1021: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');
1022: x_return_status := OKC_API.G_RET_STS_ERROR;
1023: END IF;
1024: END IF;
1025: EXCEPTION

Line 1022: x_return_status := OKC_API.G_RET_STS_ERROR;

1018: l_row_not_found := c1%NOTFOUND;
1019: CLOSE c1;
1020: IF l_row_not_found THEN
1021: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');
1022: x_return_status := OKC_API.G_RET_STS_ERROR;
1023: END IF;
1024: END IF;
1025: EXCEPTION
1026: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1033: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1029: NULL;
1030:
1031: WHEN OTHERS THEN
1032: -- store SQL error message on message stack for caller
1033: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1034:
1035: p_msg_name => g_unexpected_error,
1036: p_token1 => g_sqlcode_token,
1037: p_token1_value => SQLCODE,

Line 1042: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1038: p_token2 => g_sqlerrm_token,
1039: p_token2_value => SQLERRM);
1040:
1041: -- notify caller of an UNEXPECTED error
1042: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1043: END validate_cust_account;
1044: ----------------------------------------------------
1045: -- Validate_Attributes for: cust_site_use_id --
1046: ----------------------------------------------------

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

1046: ----------------------------------------------------
1047: PROCEDURE validate_cust_site_use(
1048: x_return_status OUT NOCOPY VARCHAR2,
1049: p_cust_site_use_id IN NUMBER) IS
1050: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1051: l_cust_site_use_id VARCHAR2(1);
1052: l_row_not_found BOOLEAN := FALSE;
1053: CURSOR c1(p_cust_account_id NUMBER) IS
1054: SELECT '1'

Line 1061: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1057: BEGIN
1058:
1059: -- initialize return status
1060: IF ( p_cust_site_use_id IS NOT NULL) THEN
1061: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1062: OPEN c1( p_cust_site_use_id );
1063: FETCH c1 INTO l_cust_site_use_id ;
1064: l_row_not_found := c1%NOTFOUND;
1065: CLOSE c1;

Line 1067: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_SITE_USE_ID');

1063: FETCH c1 INTO l_cust_site_use_id ;
1064: l_row_not_found := c1%NOTFOUND;
1065: CLOSE c1;
1066: IF l_row_not_found THEN
1067: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_SITE_USE_ID');
1068: x_return_status := OKC_API.G_RET_STS_ERROR;
1069: END IF;
1070: END IF ;
1071: EXCEPTION

Line 1068: x_return_status := OKC_API.G_RET_STS_ERROR;

1064: l_row_not_found := c1%NOTFOUND;
1065: CLOSE c1;
1066: IF l_row_not_found THEN
1067: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_SITE_USE_ID');
1068: x_return_status := OKC_API.G_RET_STS_ERROR;
1069: END IF;
1070: END IF ;
1071: EXCEPTION
1072: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1079: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1075: NULL;
1076:
1077: WHEN OTHERS THEN
1078: -- store SQL error message on message stack for caller
1079: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1080:
1081: p_msg_name => g_unexpected_error,
1082: p_token1 => g_sqlcode_token,
1083: p_token1_value => SQLCODE,

Line 1088: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1084: p_token2 => g_sqlerrm_token,
1085: p_token2_value => SQLERRM);
1086:
1087: -- notify caller of an UNEXPECTED error
1088: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1089: END validate_cust_site_use;
1090: ---------------------------------------------------------------------------
1091: -- FUNCTION Validate_Attributes
1092: ---------------------------------------------------------------------------