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

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

1213: RAISE G_EXCEPTION_HALT_VALIDATION;
1214: END IF;
1215: EXCEPTION
1216: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1217: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1218: p_msg_name => g_invalid_value,
1219: p_token1 => g_col_name_token,
1220: p_token1_value => 'currency_code');
1221: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1221: x_return_status := OKC_API.G_RET_STS_ERROR;

1217: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1218: p_msg_name => g_invalid_value,
1219: p_token1 => g_col_name_token,
1220: p_token1_value => 'currency_code');
1221: x_return_status := OKC_API.G_RET_STS_ERROR;
1222: WHEN OTHERS THEN
1223: -- store SQL error message on message stack for caller
1224: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1225: p_msg_name => g_unexpected_error,

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

1220: p_token1_value => 'currency_code');
1221: x_return_status := OKC_API.G_RET_STS_ERROR;
1222: WHEN OTHERS THEN
1223: -- store SQL error message on message stack for caller
1224: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1225: p_msg_name => g_unexpected_error,
1226: p_token1 => g_sqlcode_token,
1227: p_token1_value => sqlcode,
1228: p_token2 => g_sqlerrm_token,

Line 1231: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1227: p_token1_value => sqlcode,
1228: p_token2 => g_sqlerrm_token,
1229: p_token2_value => sqlerrm);
1230: -- notify caller of an UNEXPECTED error
1231: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1232: END validate_currency_code;
1233: ------------------------------------------------------------------------
1234: -- PROCEDURE validate_currency_con_type
1235: ------------------------------------------------------------------------

Line 1252: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1248: IF l_valid <> OKL_API.G_TRUE THEN
1249: l_return_status := OKL_API.G_RET_STS_ERROR;
1250: END IF;
1251: END IF;
1252: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1253: -- halt further validation of this column
1254: RAISE G_EXCEPTION_HALT_VALIDATION;
1255: END IF;
1256: EXCEPTION

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

1254: RAISE G_EXCEPTION_HALT_VALIDATION;
1255: END IF;
1256: EXCEPTION
1257: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1258: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1259: p_msg_name => g_invalid_value,
1260: p_token1 => g_col_name_token,
1261: p_token1_value => 'currency_conversion_type');
1262: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1262: x_return_status := OKC_API.G_RET_STS_ERROR;

1258: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1259: p_msg_name => g_invalid_value,
1260: p_token1 => g_col_name_token,
1261: p_token1_value => 'currency_conversion_type');
1262: x_return_status := OKC_API.G_RET_STS_ERROR;
1263: WHEN OTHERS THEN
1264: -- store SQL error message on message stack for caller
1265: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1266: p_msg_name => g_unexpected_error,

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

1261: p_token1_value => 'currency_conversion_type');
1262: x_return_status := OKC_API.G_RET_STS_ERROR;
1263: WHEN OTHERS THEN
1264: -- store SQL error message on message stack for caller
1265: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1266: p_msg_name => g_unexpected_error,
1267: p_token1 => g_sqlcode_token,
1268: p_token1_value => sqlcode,
1269: p_token2 => g_sqlerrm_token,

Line 1272: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1268: p_token1_value => sqlcode,
1269: p_token2 => g_sqlerrm_token,
1270: p_token2_value => sqlerrm);
1271: -- notify caller of an UNEXPECTED error
1272: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1273: END validate_currency_con_type;
1274:
1275: ------------------------------------------------------------------------
1276: -- PROCEDURE validate_currency_record

Line 1288: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1284: SELECT count(*)
1285: FROM OKL_TRX_REQUESTS
1286: WHERE id = p_id;
1287: BEGIN
1288: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1289: -- data is required
1290: OPEN l_check_id_csr(p_id => p_trqv_rec.id);
1291: FETCH l_check_id_csr INTO l_count;
1292: CLOSE l_check_id_csr;

Line 1296: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR

1292: CLOSE l_check_id_csr;
1293: -- In the insert mode, if any one of conversion_type, conversion_rate
1294: -- and conversion date are not null then all are mandory
1295: IF l_count = 0 THEN
1296: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR
1297: p_trqv_rec.currency_conversion_type IS NOT NULL) OR
1298: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1299: p_trqv_rec.currency_conversion_rate IS NOT NULL) OR
1300: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR

Line 1298: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR

1294: -- and conversion date are not null then all are mandory
1295: IF l_count = 0 THEN
1296: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR
1297: p_trqv_rec.currency_conversion_type IS NOT NULL) OR
1298: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1299: p_trqv_rec.currency_conversion_rate IS NOT NULL) OR
1300: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR
1301: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1302: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1300: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR

1296: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR
1297: p_trqv_rec.currency_conversion_type IS NOT NULL) OR
1298: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1299: p_trqv_rec.currency_conversion_rate IS NOT NULL) OR
1300: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR
1301: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1302: RAISE G_EXCEPTION_HALT_VALIDATION;
1303: END IF;
1304: -- In the update mode, if all conversion_type, conversion_rate

Line 1308: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR

1304: -- In the update mode, if all conversion_type, conversion_rate
1305: -- and conversion date are not null or null we are ok.
1306: -- Else we are not ok
1307: ELSE
1308: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR
1309: p_trqv_rec.currency_conversion_type IS NOT NULL) AND
1310: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1311: p_trqv_rec.currency_conversion_rate IS NOT NULL) AND
1312: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR

Line 1310: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR

1306: -- Else we are not ok
1307: ELSE
1308: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR
1309: p_trqv_rec.currency_conversion_type IS NOT NULL) AND
1310: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1311: p_trqv_rec.currency_conversion_rate IS NOT NULL) AND
1312: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR
1313: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1314: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1312: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR

1308: IF (p_trqv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR OR
1309: p_trqv_rec.currency_conversion_type IS NOT NULL) AND
1310: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1311: p_trqv_rec.currency_conversion_rate IS NOT NULL) AND
1312: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR
1313: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1314: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1315: ELSIF (p_trqv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
1316: p_trqv_rec.currency_conversion_type IS NULL) AND

Line 1314: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1310: (p_trqv_rec.currency_conversion_rate <> OKC_API.G_MISS_NUM OR
1311: p_trqv_rec.currency_conversion_rate IS NOT NULL) AND
1312: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR
1313: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1314: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1315: ELSIF (p_trqv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
1316: p_trqv_rec.currency_conversion_type IS NULL) AND
1317: (p_trqv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
1318: p_trqv_rec.currency_conversion_rate IS NULL) AND

Line 1315: ELSIF (p_trqv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR

1311: p_trqv_rec.currency_conversion_rate IS NOT NULL) AND
1312: (p_trqv_rec.currency_conversion_date <> OKC_API.G_MISS_DATE OR
1313: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1314: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1315: ELSIF (p_trqv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
1316: p_trqv_rec.currency_conversion_type IS NULL) AND
1317: (p_trqv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
1318: p_trqv_rec.currency_conversion_rate IS NULL) AND
1319: (p_trqv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR

Line 1317: (p_trqv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR

1313: p_trqv_rec.currency_conversion_date IS NOT NULL) THEN
1314: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1315: ELSIF (p_trqv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
1316: p_trqv_rec.currency_conversion_type IS NULL) AND
1317: (p_trqv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
1318: p_trqv_rec.currency_conversion_rate IS NULL) AND
1319: (p_trqv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR
1320: p_trqv_rec.currency_conversion_date IS NULL) THEN
1321: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1319: (p_trqv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR

1315: ELSIF (p_trqv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR OR
1316: p_trqv_rec.currency_conversion_type IS NULL) AND
1317: (p_trqv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
1318: p_trqv_rec.currency_conversion_rate IS NULL) AND
1319: (p_trqv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR
1320: p_trqv_rec.currency_conversion_date IS NULL) THEN
1321: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1322: ELSE
1323: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1321: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1317: (p_trqv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM OR
1318: p_trqv_rec.currency_conversion_rate IS NULL) AND
1319: (p_trqv_rec.currency_conversion_date = OKC_API.G_MISS_DATE OR
1320: p_trqv_rec.currency_conversion_date IS NULL) THEN
1321: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1322: ELSE
1323: RAISE G_EXCEPTION_HALT_VALIDATION;
1324: END IF;
1325: END IF;

Line 1328: OKC_API.set_message(p_app_name => G_APP_NAME,

1324: END IF;
1325: END IF;
1326: EXCEPTION
1327: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1328: OKC_API.set_message(p_app_name => G_APP_NAME,
1329: p_msg_name => G_REQUIRED_VALUE,
1330: p_token1 => G_COL_NAME_TOKEN,
1331: p_token1_value => 'currency_conversion_type,currency_conversion_rate and currency_conversion_date');
1332: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1332: x_return_status := OKC_API.G_RET_STS_ERROR;

1328: OKC_API.set_message(p_app_name => G_APP_NAME,
1329: p_msg_name => G_REQUIRED_VALUE,
1330: p_token1 => G_COL_NAME_TOKEN,
1331: p_token1_value => 'currency_conversion_type,currency_conversion_rate and currency_conversion_date');
1332: x_return_status := OKC_API.G_RET_STS_ERROR;
1333: WHEN OTHERS THEN
1334: -- store SQL error message on message stack for caller
1335: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1336: p_msg_name => g_unexpected_error,

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

1331: p_token1_value => 'currency_conversion_type,currency_conversion_rate and currency_conversion_date');
1332: x_return_status := OKC_API.G_RET_STS_ERROR;
1333: WHEN OTHERS THEN
1334: -- store SQL error message on message stack for caller
1335: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1336: p_msg_name => g_unexpected_error,
1337: p_token1 => g_sqlcode_token,
1338: p_token1_value => sqlcode,
1339: p_token2 => g_sqlerrm_token,

Line 1342: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1338: p_token1_value => sqlcode,
1339: p_token2 => g_sqlerrm_token,
1340: p_token2_value => sqlerrm);
1341: -- notify caller of an UNEXPECTED error
1342: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1343: END validate_currency_record;
1344:
1345:
1346: ---------------------------------------------------------------------------