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.OKC_QA_CHECK_PVT dependencies on OKC_API

Line 26: x_return_status := OKC_API.G_RET_STS_SUCCESS;

22: FROM OKC_QA_CHECK_LISTS_B qclv
23: WHERE qclv.ID = p_qcl_id;
24: BEGIN
25: -- initialize return status
26: x_return_status := OKC_API.G_RET_STS_SUCCESS;
27:
28: -- data is required
29: IF (p_qcl_id = OKC_API.G_MISS_NUM OR
30: p_qcl_id IS NULL) THEN

Line 29: IF (p_qcl_id = OKC_API.G_MISS_NUM OR

25: -- initialize return status
26: x_return_status := OKC_API.G_RET_STS_SUCCESS;
27:
28: -- data is required
29: IF (p_qcl_id = OKC_API.G_MISS_NUM OR
30: p_qcl_id IS NULL) THEN
31: OKC_API.set_message(
32: p_app_name => G_APP_NAME,
33: p_msg_name => G_REQUIRED_VALUE,

Line 31: OKC_API.set_message(

27:
28: -- data is required
29: IF (p_qcl_id = OKC_API.G_MISS_NUM OR
30: p_qcl_id IS NULL) THEN
31: OKC_API.set_message(
32: p_app_name => G_APP_NAME,
33: p_msg_name => G_REQUIRED_VALUE,
34: p_token1 => G_COL_NAME_TOKEN,
35: p_token1_value => 'qcl_id');

Line 38: x_return_status := OKC_API.G_RET_STS_ERROR;

34: p_token1 => G_COL_NAME_TOKEN,
35: p_token1_value => 'qcl_id');
36:
37: -- notify caller of an error
38: x_return_status := OKC_API.G_RET_STS_ERROR;
39:
40: -- halt validation
41: RAISE G_EXCEPTION_HALT_VALIDATION;
42: END IF;

Line 51: OKC_API.set_message(

47: CLOSE l_qclv_csr;
48:
49: -- if l_dummy_var still set to default, data was not found
50: IF (l_dummy_var = '?') THEN
51: OKC_API.set_message(
52: p_app_name => G_APP_NAME,
53: p_msg_name => G_INVALID_VALUE,
54: p_token1 => G_COL_NAME_TOKEN,
55: p_token1_value => 'qcl_id');

Line 57: x_return_status := OKC_API.G_RET_STS_ERROR;

53: p_msg_name => G_INVALID_VALUE,
54: p_token1 => G_COL_NAME_TOKEN,
55: p_token1_value => 'qcl_id');
56: -- notify caller of an error
57: x_return_status := OKC_API.G_RET_STS_ERROR;
58: END IF;
59: EXCEPTION
60: WHEN G_EXCEPTION_HALT_VALIDATION THEN
61: -- no processing necessary; validation can continue with next column

Line 65: OKC_API.SET_MESSAGE(

61: -- no processing necessary; validation can continue with next column
62: NULL;
63: WHEN OTHERS THEN
64: -- store SQL error message on message stack
65: OKC_API.SET_MESSAGE(
66: p_app_name => G_APP_NAME,
67: p_msg_name => G_UNEXPECTED_ERROR,
68: p_token1 => G_SQLCODE_TOKEN,
69: p_token1_value => SQLCODE,

Line 73: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

69: p_token1_value => SQLCODE,
70: p_token2 => G_SQLERRM_TOKEN,
71: p_token2_value => SQLERRM);
72: -- notify caller of an error as UNEXPETED error
73: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
74: -- verify that cursor was closed
75: IF l_qclv_csr%ISOPEN THEN
76: CLOSE l_qclv_csr;
77: END IF;

Line 195: cop.qa_pdf_id, OKC_API.G_MISS_NUM, 'S'

191: -- Bug 2170973 ,This following query added to execute qa_pdf_id of okc_class_operations if
192: -- contract category has any operation of purpose 'INTEGRATION' defined in it.
193: union all
194: select 5, pdf.name, pdf.description, pdf.package_name, pdf.procedure_name,
195: cop.qa_pdf_id, OKC_API.G_MISS_NUM, 'S'
196: from OKC_PROCESS_DEFS_V pdf,
197: OKC_K_HEADERS_B khr,
198: OKC_SUBCLASSES_B scs,
199: OKC_CLASS_OPERATIONS cop,

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

233: l_qpp_rec l_qpp_csr%ROWTYPE;
234:
235: plsql_block VARCHAR2(30000);
236:
237: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
238: l_msg_count NUMBER;
239: l_msg_data VARCHAR2(2000);
240: l_tot_msg_count NUMBER := 0;
241: -- Bug 2934909

Line 261: x_return_status := OKC_API.G_RET_STS_SUCCESS;

257: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'p_override_flag: ' || p_override_flag);
258: END IF;
259:
260: -- initialize return status
261: x_return_status := OKC_API.G_RET_STS_SUCCESS;
262:
263: validate_qcl_id(
264: x_return_status => x_return_status,
265: p_qcl_id => p_qcl_id);

Line 267: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

263: validate_qcl_id(
264: x_return_status => x_return_status,
265: p_qcl_id => p_qcl_id);
266:
267: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
268: -- return status to caller, can not continue to process
269: RETURN;
270: END IF;
271: --

Line 352: -- OKC_API.SET_MESSAGE(

348: USING IN OUT l_return_status,IN p_chr_id;
349: EXCEPTION
350: -- WHEN OTHERS THEN
351: -- -- store SQL error message on message stack
352: -- OKC_API.SET_MESSAGE(
353: -- p_app_name => G_APP_NAME,
354: -- p_msg_name => G_QA_PROCESS_ERROR);
355: -- -- notify caller of an error as UNEXPETED error
356: -- l_return_status := OKC_API.G_RET_STS_ERROR;

Line 356: -- l_return_status := OKC_API.G_RET_STS_ERROR;

352: -- OKC_API.SET_MESSAGE(
353: -- p_app_name => G_APP_NAME,
354: -- p_msg_name => G_QA_PROCESS_ERROR);
355: -- -- notify caller of an error as UNEXPETED error
356: -- l_return_status := OKC_API.G_RET_STS_ERROR;
357: -- END;
358: --
359: -- -- Get error messages to return
360: -- -- assign message values to return

Line 595: OKC_API.SET_MESSAGE(

591: if (l_cursor_id is not null) then --Bug 3378989
592: DBMS_SQL.CLOSE_CURSOR(l_cursor_id); --Bug2934909
593: end if;
594: -- store SQL error message on message stack
595: OKC_API.SET_MESSAGE(
596: p_app_name => G_APP_NAME,
597: p_msg_name => G_UNEXPECTED_ERROR,
598: p_token1 => G_SQLCODE_TOKEN,
599: p_token1_value => SQLCODE,

Line 603: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

599: p_token1_value => SQLCODE,
600: p_token2 => G_SQLERRM_TOKEN,
601: p_token2_value => SQLERRM);
602: -- notify caller of an error as UNEXPETED error
603: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
604: IF l_qlp_csr%ISOPEN THEN
605: CLOSE l_qlp_csr;
606: END IF;
607: IF l_qpp_csr%ISOPEN THEN