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

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

1072: ----------------------------------------------------
1073: PROCEDURE validate_party(
1074: x_return_status OUT NOCOPY VARCHAR2,
1075: p_party_id IN NUMBER) IS
1076: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1077: l_party_id VARCHAR2(1);
1078: l_row_not_found BOOLEAN := FALSE;
1079: CURSOR c1(p_party_id NUMBER) IS
1080: SELECT '1'

Line 1086: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1082: WHERE party_id = p_party_id ;
1083: BEGIN
1084: IF ( p_party_id IS NOT NULL) THEN
1085: -- initialize return status
1086: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1087: OPEN c1(p_party_id );
1088: FETCH c1 INTO l_party_id;
1089: l_row_not_found := c1%NOTFOUND;
1090: CLOSE c1;

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

1088: FETCH c1 INTO l_party_id;
1089: l_row_not_found := c1%NOTFOUND;
1090: CLOSE c1;
1091: IF l_row_not_found THEN
1092: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');
1093: x_return_status := OKC_API.G_RET_STS_ERROR;
1094: END IF;
1095: END IF;
1096: EXCEPTION

Line 1093: x_return_status := OKC_API.G_RET_STS_ERROR;

1089: l_row_not_found := c1%NOTFOUND;
1090: CLOSE c1;
1091: IF l_row_not_found THEN
1092: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'PARTY_ID');
1093: x_return_status := OKC_API.G_RET_STS_ERROR;
1094: END IF;
1095: END IF;
1096: EXCEPTION
1097: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

1100: NULL;
1101:
1102: WHEN OTHERS THEN
1103: -- store SQL error message on message stack for caller
1104: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1105:
1106: p_msg_name => g_unexpected_error,
1107: p_token1 => g_sqlcode_token,
1108: p_token1_value => SQLCODE,

Line 1113: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1109: p_token2 => g_sqlerrm_token,
1110: p_token2_value => SQLERRM);
1111:
1112: -- notify caller of an UNEXPECTED error
1113: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1114: END validate_party;
1115: ----------------------------------------------------
1116: -- Validate_Attributes for: cust_account_id --
1117: ----------------------------------------------------

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

1117: ----------------------------------------------------
1118: PROCEDURE validate_cust_account(
1119: x_return_status OUT NOCOPY VARCHAR2,
1120: p_cust_account_id IN NUMBER) IS
1121: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1122: l_cust_account_id VARCHAR2(1);
1123: l_row_not_found BOOLEAN := FALSE;
1124: CURSOR c1(p_cust_account_id NUMBER) IS
1125: SELECT '1'

Line 1132: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1128: BEGIN
1129:
1130: -- initialize return status
1131: IF ( p_cust_account_id IS NOT NULL) THEN
1132: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1133: OPEN c1(p_cust_account_id );
1134: FETCH c1 INTO l_cust_account_id;
1135: l_row_not_found := c1%NOTFOUND;
1136: CLOSE c1;

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

1134: FETCH c1 INTO l_cust_account_id;
1135: l_row_not_found := c1%NOTFOUND;
1136: CLOSE c1;
1137: IF l_row_not_found THEN
1138: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');
1139: x_return_status := OKC_API.G_RET_STS_ERROR;
1140: END IF;
1141: END IF;
1142: EXCEPTION

Line 1139: x_return_status := OKC_API.G_RET_STS_ERROR;

1135: l_row_not_found := c1%NOTFOUND;
1136: CLOSE c1;
1137: IF l_row_not_found THEN
1138: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'CUST_ACCOUNT_ID');
1139: x_return_status := OKC_API.G_RET_STS_ERROR;
1140: END IF;
1141: END IF;
1142: EXCEPTION
1143: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

1146: NULL;
1147:
1148: WHEN OTHERS THEN
1149: -- store SQL error message on message stack for caller
1150: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1151:
1152: p_msg_name => g_unexpected_error,
1153: p_token1 => g_sqlcode_token,
1154: p_token1_value => SQLCODE,

Line 1159: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1155: p_token2 => g_sqlerrm_token,
1156: p_token2_value => SQLERRM);
1157:
1158: -- notify caller of an UNEXPECTED error
1159: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1160: END validate_cust_account;
1161: ---------------------------------------------------------------------------
1162: -- FUNCTION Validate_Attributes
1163: ---------------------------------------------------------------------------