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

Line 6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

2: /* $Header: OKCCCRTB.pls 120.0 2005/05/26 09:37:55 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CHANGE_REQUEST_PVT';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
10: G_CRT_ON_APPROVAL CONSTANT varchar2(200) := 'OKC_IS_ON_APPROVAL';

Line 8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CHANGE_REQUEST_PVT';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
10: G_CRT_ON_APPROVAL CONSTANT varchar2(200) := 'OKC_IS_ON_APPROVAL';
11: G_WF_NAME_TOKEN CONSTANT varchar2(200) := 'WF_ITEM';
12: G_KEY_TOKEN CONSTANT varchar2(200) := 'WF_KEY';

Line 9: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

5:
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CHANGE_REQUEST_PVT';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
10: G_CRT_ON_APPROVAL CONSTANT varchar2(200) := 'OKC_IS_ON_APPROVAL';
11: G_WF_NAME_TOKEN CONSTANT varchar2(200) := 'WF_ITEM';
12: G_KEY_TOKEN CONSTANT varchar2(200) := 'WF_KEY';
13: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';

Line 14: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

10: G_CRT_ON_APPROVAL CONSTANT varchar2(200) := 'OKC_IS_ON_APPROVAL';
11: G_WF_NAME_TOKEN CONSTANT varchar2(200) := 'WF_ITEM';
12: G_KEY_TOKEN CONSTANT varchar2(200) := 'WF_KEY';
13: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
14: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
15: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
16: G_DUPLICATE_CR CONSTANT varchar2(200) := 'OKC_DUPLICATE_CHANGE_REQUEST';
17: G_CR_TOKEN CONSTANT varchar2(200) := 'CR_NAME';
18:

Line 15: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

11: G_WF_NAME_TOKEN CONSTANT varchar2(200) := 'WF_ITEM';
12: G_KEY_TOKEN CONSTANT varchar2(200) := 'WF_KEY';
13: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
14: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
15: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
16: G_DUPLICATE_CR CONSTANT varchar2(200) := 'OKC_DUPLICATE_CHANGE_REQUEST';
17: G_CR_TOKEN CONSTANT varchar2(200) := 'CR_NAME';
18:
19: -- Start of comments

Line 68: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

64: open chk_dup_cr_csr;
65: fetch chk_dup_cr_csr into l_dummy;
66: close chk_dup_cr_csr;
67: If (l_dummy = '!') then
68: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
69: p_msg_name => G_DUPLICATE_CR,
70: p_token1 => G_CR_TOKEN,
71: p_token1_value => p_crtv_rec.name
72: );

Line 73: x_return_status := OKC_API.G_RET_STS_ERROR;

69: p_msg_name => G_DUPLICATE_CR,
70: p_token1 => G_CR_TOKEN,
71: p_token1_value => p_crtv_rec.name
72: );
73: x_return_status := OKC_API.G_RET_STS_ERROR;
74: return;
75: End If;
76: -- added for Bug 3162918
77:

Line 142: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

138: open l1_csr;
139: fetch l1_csr into l_dummy;
140: close l1_csr;
141: if (l_dummy = '!') then
142: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
143: p_msg_name => G_CHILD_RECORD_FOUND,
144: p_token1 => G_PARENT_TABLE_TOKEN,
145: p_token1_value => 'OKC_CHANGE_REQUESTS_V',
146: p_token2 => G_CHILD_TABLE_TOKEN,

Line 148: x_return_status := OKC_API.G_RET_STS_ERROR;

144: p_token1 => G_PARENT_TABLE_TOKEN,
145: p_token1_value => 'OKC_CHANGE_REQUESTS_V',
146: p_token2 => G_CHILD_TABLE_TOKEN,
147: p_token2_value => 'OKC_CHANGES_V');
148: x_return_status := OKC_API.G_RET_STS_ERROR;
149: return;
150: end if;
151: --
152: l_dummy := '?';

Line 157: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

153: open l2_csr;
154: fetch l2_csr into l_dummy;
155: close l2_csr;
156: if (l_dummy = '!') then
157: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
158: p_msg_name => G_CHILD_RECORD_FOUND,
159: p_token1 => G_PARENT_TABLE_TOKEN,
160: p_token1_value => 'OKC_CHANGE_REQUESTS_V',
161: p_token2 => G_CHILD_TABLE_TOKEN,

Line 163: x_return_status := OKC_API.G_RET_STS_ERROR;

159: p_token1 => G_PARENT_TABLE_TOKEN,
160: p_token1_value => 'OKC_CHANGE_REQUESTS_V',
161: p_token2 => G_CHILD_TABLE_TOKEN,
162: p_token2_value => 'OKC_CHANGE_PARTY_ROLE_V');
163: x_return_status := OKC_API.G_RET_STS_ERROR;
164: return;
165: end if;
166: --
167: okc_crt_pvt.delete_row(p_api_version => p_api_version,

Line 221: if (p_restricted = OKC_API.G_TRUE

217: open cur_crt_details;
218: fetch cur_crt_details into l_crtv_rec.id,l_crtv_rec.name,l_crtv_rec.chr_id,l_crtv_rec.crs_code,l_crtv_rec.datetime_applied,l_crtv_rec.object_version_number;
219: close cur_crt_details;
220: if (l_crtv_rec.crs_code='APP') then
221: if (p_restricted = OKC_API.G_TRUE
222: or l_crtv_rec.datetime_applied is not NULL) then
223: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
224: x_return_status := OKC_API.G_RET_STS_ERROR;
225: return;

Line 223: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

219: close cur_crt_details;
220: if (l_crtv_rec.crs_code='APP') then
221: if (p_restricted = OKC_API.G_TRUE
222: or l_crtv_rec.datetime_applied is not NULL) then
223: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
224: x_return_status := OKC_API.G_RET_STS_ERROR;
225: return;
226: end if;
227: end if;

Line 224: x_return_status := OKC_API.G_RET_STS_ERROR;

220: if (l_crtv_rec.crs_code='APP') then
221: if (p_restricted = OKC_API.G_TRUE
222: or l_crtv_rec.datetime_applied is not NULL) then
223: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
224: x_return_status := OKC_API.G_RET_STS_ERROR;
225: return;
226: end if;
227: end if;
228: open key_csr;

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

231: open approval_active_csr;
232: fetch approval_active_csr into l_wf_name_active;
233: close approval_active_csr;
234: if (L_WF_NAME_ACTIVE is not NULL) then
235: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
236: p_msg_name => G_CRT_ON_APPROVAL,
237: p_token1 => G_WF_NAME_TOKEN,
238: p_token1_value => L_WF_NAME_ACTIVE,
239: p_token2 => G_KEY_TOKEN,

Line 241: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

237: p_token1 => G_WF_NAME_TOKEN,
238: p_token1_value => L_WF_NAME_ACTIVE,
239: p_token2 => G_KEY_TOKEN,
240: p_token2_value => L_KEY);
241: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
242: x_return_status := OKC_API.G_RET_STS_ERROR;
243: return;
244: end if;
245: okc_crt_pvt.lock_row(p_api_version => p_api_version,

Line 242: x_return_status := OKC_API.G_RET_STS_ERROR;

238: p_token1_value => L_WF_NAME_ACTIVE,
239: p_token2 => G_KEY_TOKEN,
240: p_token2_value => L_KEY);
241: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
242: x_return_status := OKC_API.G_RET_STS_ERROR;
243: return;
244: end if;
245: okc_crt_pvt.lock_row(p_api_version => p_api_version,
246: p_init_msg_list => p_init_msg_list,

Line 405: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

401: open key_csr;
402: fetch key_csr into l_status, L_KEY;
403: close key_csr;
404: if (l_status='APP') then
405: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
406: x_return_status := OKC_API.G_RET_STS_ERROR;
407: return;
408: end if;
409: open approval_active_csr;

Line 406: x_return_status := OKC_API.G_RET_STS_ERROR;

402: fetch key_csr into l_status, L_KEY;
403: close key_csr;
404: if (l_status='APP') then
405: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
406: x_return_status := OKC_API.G_RET_STS_ERROR;
407: return;
408: end if;
409: open approval_active_csr;
410: fetch approval_active_csr into l_wf_name_active;

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

409: open approval_active_csr;
410: fetch approval_active_csr into l_wf_name_active;
411: close approval_active_csr;
412: if (L_WF_NAME_ACTIVE is not NULL) then
413: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
414: p_msg_name => G_CRT_ON_APPROVAL,
415: p_token1 => G_WF_NAME_TOKEN,
416: p_token1_value => L_WF_NAME_ACTIVE,
417: p_token2 => G_KEY_TOKEN,

Line 419: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

415: p_token1 => G_WF_NAME_TOKEN,
416: p_token1_value => L_WF_NAME_ACTIVE,
417: p_token2 => G_KEY_TOKEN,
418: p_token2_value => L_KEY);
419: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
420: x_return_status := OKC_API.G_RET_STS_ERROR;
421: return;
422: end if;
423: okc_cor_pvt.lock_row(p_api_version => p_api_version,

Line 420: x_return_status := OKC_API.G_RET_STS_ERROR;

416: p_token1_value => L_WF_NAME_ACTIVE,
417: p_token2 => G_KEY_TOKEN,
418: p_token2_value => L_KEY);
419: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
420: x_return_status := OKC_API.G_RET_STS_ERROR;
421: return;
422: end if;
423: okc_cor_pvt.lock_row(p_api_version => p_api_version,
424: p_init_msg_list => p_init_msg_list,