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

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

1126: PROCEDURE validate_party_id(
1127: x_return_status OUT NOCOPY VARCHAR2,
1128: p_party_id IN NUMBER) IS
1129:
1130: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1131: l_party_id NUMBER;
1132: l_row_not_found BOOLEAN := FALSE;
1133: CURSOR check_party_id_csr(p_party_id NUMBER) IS
1134: SELECT '1'

Line 1140: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1136: WHERE party_id = p_party_id;
1137: BEGIN
1138: IF ( p_party_id IS NOT NULL) THEN
1139: -- initialize return status
1140: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1141: OPEN check_party_id_csr(p_party_id );
1142: FETCH check_party_id_csr INTO l_party_id ;
1143: l_row_not_found := check_party_id_csr%NOTFOUND;
1144: CLOSE check_party_id_csr;

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

1142: FETCH check_party_id_csr INTO l_party_id ;
1143: l_row_not_found := check_party_id_csr%NOTFOUND;
1144: CLOSE check_party_id_csr;
1145: IF l_row_not_found THEN
1146: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');
1147: x_return_status := OKC_API.G_RET_STS_ERROR;
1148: END IF;
1149: END IF;
1150: EXCEPTION

Line 1147: x_return_status := OKC_API.G_RET_STS_ERROR;

1143: l_row_not_found := check_party_id_csr%NOTFOUND;
1144: CLOSE check_party_id_csr;
1145: IF l_row_not_found THEN
1146: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');
1147: x_return_status := OKC_API.G_RET_STS_ERROR;
1148: END IF;
1149: END IF;
1150: EXCEPTION
1151: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

1153: -- with the next column
1154: NULL;
1155: WHEN OTHERS THEN
1156: -- store SQL error message on message stack for caller
1157: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1158: p_msg_name => g_unexpected_error,
1159: p_token1 => g_sqlcode_token,
1160: p_token1_value => SQLCODE,
1161: p_token2 => g_sqlerrm_token,

Line 1165: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1161: p_token2 => g_sqlerrm_token,
1162: p_token2_value => SQLERRM);
1163:
1164: -- notify caller of an UNEXPECTED error
1165: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1166: END validate_party_id;
1167: ---------------------------------------------
1168: -- Validate_Attributes for: CUST_ACCOUNT_ID --
1169: -----------------------------------------------

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

1169: -----------------------------------------------
1170: PROCEDURE validate_cust_account_id(
1171: x_return_status OUT NOCOPY VARCHAR2,
1172: p_cust_account_id IN NUMBER) IS
1173: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1174: l_cust_account_id NUMBER;
1175: l_row_not_found BOOLEAN := FALSE;
1176: CURSOR check_cust_account_id_csr(p_cust_account_id NUMBER) IS
1177: SELECT '1'

Line 1183: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1179: WHERE cust_account_id = p_cust_account_id;
1180: BEGIN
1181: IF ( p_cust_account_id IS NOT NULL) THEN
1182: -- initialize return status
1183: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1184: OPEN check_cust_account_id_csr(p_cust_account_id);
1185: FETCH check_cust_account_id_csr INTO l_cust_account_id ;
1186: l_row_not_found := check_cust_account_id_csr%NOTFOUND;
1187: CLOSE check_cust_account_id_csr;

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

1185: FETCH check_cust_account_id_csr INTO l_cust_account_id ;
1186: l_row_not_found := check_cust_account_id_csr%NOTFOUND;
1187: CLOSE check_cust_account_id_csr;
1188: IF l_row_not_found THEN
1189: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');
1190: x_return_status := OKC_API.G_RET_STS_ERROR;
1191: END IF;
1192: END IF;
1193: EXCEPTION

Line 1190: x_return_status := OKC_API.G_RET_STS_ERROR;

1186: l_row_not_found := check_cust_account_id_csr%NOTFOUND;
1187: CLOSE check_cust_account_id_csr;
1188: IF l_row_not_found THEN
1189: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');
1190: x_return_status := OKC_API.G_RET_STS_ERROR;
1191: END IF;
1192: END IF;
1193: EXCEPTION
1194: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

1196: -- with the next column
1197: NULL;
1198: WHEN OTHERS THEN
1199: -- store SQL error message on message stack for caller
1200: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1201: p_msg_name => g_unexpected_error,
1202: p_token1 => g_sqlcode_token,
1203: p_token1_value => SQLCODE,
1204: p_token2 => g_sqlerrm_token,

Line 1208: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1204: p_token2 => g_sqlerrm_token,
1205: p_token2_value => SQLERRM);
1206:
1207: -- notify caller of an UNEXPECTED error
1208: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1209: END validate_cust_account_id;
1210: ---------------------------------------------------------------------------
1211: -- FUNCTION Validate_Attributes
1212: ---------------------------------------------------------------------------