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 192: cop.qa_pdf_id, OKC_API.G_MISS_NUM, 'S'

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

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

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

Line 258: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

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

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

Line 349: -- OKC_API.SET_MESSAGE(

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

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

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

Line 592: OKC_API.SET_MESSAGE(

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

Line 600: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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