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

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3:
4: SUBTYPE ter_rec_type is okc_terminate_pub.terminate_in_parameters_rec;
5:
6: PROCEDURE validate_chr( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_terminate_in_parameters_rec IN ter_rec_type ) IS

Line 76: l_return_status varchar2(1) := okc_api.g_ret_sts_success;

72:
73: l_status varchar2(30); -- Impact on status
74: l_meaning okc_statuses_v.meaning%TYPE;
75:
76: l_return_status varchar2(1) := okc_api.g_ret_sts_success;
77: l_api_name CONSTANT VARCHAR2(30) := 'validate_chr';
78:
79: BEGIN
80:

Line 92: x_return_status := okc_api.g_ret_sts_success;

88: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
89: RAISE OKL_API.G_EXCEPTION_ERROR;
90: END IF;
91:
92: x_return_status := okc_api.g_ret_sts_success;
93:
94: -- okc_api.init_msg_list(p_init_msg_list);
95:
96: OPEN cur_k_header;

Line 94: -- okc_api.init_msg_list(p_init_msg_list);

90: END IF;
91:
92: x_return_status := okc_api.g_ret_sts_success;
93:
94: -- okc_api.init_msg_list(p_init_msg_list);
95:
96: OPEN cur_k_header;
97: FETCH cur_k_header into l_chrv_rec;
98: CLOSE cur_k_header;

Line 102: OKC_API.set_message(p_app_name => g_app_name,

98: CLOSE cur_k_header;
99:
100: IF l_chrv_rec.template_Yn = 'Y' THEN
101:
102: OKC_API.set_message(p_app_name => g_app_name,
103: p_msg_name => 'OKL_K_TEMPLATE',
104: p_token1 => 'NUMBER',
105: p_token1_value => l_chrv_rec.contract_number);
106:

Line 107: x_return_status := okc_api.g_ret_sts_error;

103: p_msg_name => 'OKL_K_TEMPLATE',
104: p_token1 => 'NUMBER',
105: p_token1_value => l_chrv_rec.contract_number);
106:
107: x_return_status := okc_api.g_ret_sts_error;
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END if;
110:
111: OPEN is_k_locked;

Line 116: OKC_API.set_message(p_app_name => g_app_name,

112: FETCH is_k_locked into l_chg_request_in_process;
113:
114: IF is_k_locked%FOUND THEN
115:
116: OKC_API.set_message(p_app_name => g_app_name,
117: p_msg_name => 'OKL_K_LOCKED'
118: );
119:
120: x_return_status := okc_api.g_ret_sts_error;

Line 120: x_return_status := okc_api.g_ret_sts_error;

116: OKC_API.set_message(p_app_name => g_app_name,
117: p_msg_name => 'OKL_K_LOCKED'
118: );
119:
120: x_return_status := okc_api.g_ret_sts_error;
121: CLOSE is_k_locked;
122: RAISE OKL_API.G_EXCEPTION_ERROR;
123:
124: END IF;

Line 137: OKC_API.set_message(p_app_name => g_app_name,

133: CLOSE cur_sts_code;
134:
135: IF l_status='1' then
136: --
137: OKC_API.set_message(p_app_name => g_app_name,
138: p_msg_name => 'OKL_INVALID_K_STATUS',
139: p_token1 => 'STATUS',
140: p_token1_value => l_chrv_rec.sts_code);
141:

Line 148: x_return_status := OKC_API.G_RET_STS_ERROR;

144: END IF;
145:
146: IF (l_status NOT IN ('ACTIVE','HOLD','SIGNED')) OR (l_status='HOLD' and l_chrv_rec.sts_code='QA_HOLD') THEN
147:
148: x_return_status := OKC_API.G_RET_STS_ERROR;
149:
150: OKC_API.set_message(p_app_name => g_app_name,
151: p_msg_name => 'OKL_INVALID_K_STATUS',
152: p_token1 => 'STATUS',

Line 150: OKC_API.set_message(p_app_name => g_app_name,

146: IF (l_status NOT IN ('ACTIVE','HOLD','SIGNED')) OR (l_status='HOLD' and l_chrv_rec.sts_code='QA_HOLD') THEN
147:
148: x_return_status := OKC_API.G_RET_STS_ERROR;
149:
150: OKC_API.set_message(p_app_name => g_app_name,
151: p_msg_name => 'OKL_INVALID_K_STATUS',
152: p_token1 => 'STATUS',
153: p_token1_value => l_meaning);
154:

Line 158: x_return_status := OKC_API.G_RET_STS_ERROR;

154:
155: RAISE OKL_API.G_EXCEPTION_ERROR;
156: ELSIF l_chrv_rec.date_terminated is not null THEN
157:
158: x_return_status := OKC_API.G_RET_STS_ERROR;
159:
160: OKC_API.set_message(p_app_name => g_app_name,
161: p_msg_name => 'OKL_FUTURE_TERMINATED_K',
162: p_token1 => 'NUMBER',

Line 160: OKC_API.set_message(p_app_name => g_app_name,

156: ELSIF l_chrv_rec.date_terminated is not null THEN
157:
158: x_return_status := OKC_API.G_RET_STS_ERROR;
159:
160: OKC_API.set_message(p_app_name => g_app_name,
161: p_msg_name => 'OKL_FUTURE_TERMINATED_K',
162: p_token1 => 'NUMBER',
163: p_token1_value => l_chrv_rec.contract_number );
164:

Line 175: x_return_status := OKC_API.G_RET_STS_ERROR;

171: IF Nvl(p_terminate_in_parameters_rec.p_orig_end_date,
172: p_terminate_in_parameters_rec.p_termination_date + 1) <
173: p_terminate_in_parameters_rec.p_termination_date then
174:
175: x_return_status := OKC_API.G_RET_STS_ERROR;
176:
177: OKC_API.set_message( p_app_name => g_app_name,
178: p_msg_name =>'OKL_TRMDATE_MORE_END'
179: );

Line 177: OKC_API.set_message( p_app_name => g_app_name,

173: p_terminate_in_parameters_rec.p_termination_date then
174:
175: x_return_status := OKC_API.G_RET_STS_ERROR;
176:
177: OKC_API.set_message( p_app_name => g_app_name,
178: p_msg_name =>'OKL_TRMDATE_MORE_END'
179: );
180:
181: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 240: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;

236: l_code VARCHAR2(100);
237: l_app_id okc_k_headers_b.application_id%TYPE;
238: l_scs_code okc_k_headers_b.scs_code%TYPE;
239: l_k VARCHAR2(255);
240: l_mod okc_k_headers_b.contract_number_modifier%TYPE DEFAULT OKC_API.G_MISS_CHAR;
241: l_return_value VARCHAR2(1) := 'Y';
242: L1_RETURN_STATUS varchar2(3);
243:
244: CURSOR c_chr IS

Line 263: OKC_API.set_message(p_app_name => g_app_name,

259: FETCH c_chr INTO l_code, l_template_yn, l_app_id, l_scs_code,l_k,l_mod;
260: CLOSE c_chr;
261:
262: IF l_template_yn = 'Y' then
263: OKC_API.set_message(p_app_name => g_app_name,
264: p_msg_name => 'OKL_K_TEMPLATE',
265: p_token1 => 'NUMBER',
266: p_token1_value => l_k);
267:

Line 279: OKC_API.set_message(p_app_name => g_app_name,

275: /*IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN
276:
277: l1_return_status :=OKL_API.G_RET_STS_ERROR;
278:
279: OKC_API.set_message(p_app_name => g_app_name,
280: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
281: );
282:
283: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 290: OKC_API.set_message(p_app_name => g_app_name,

286: */
287:
288: IF (OKL_VENDOR_PROGRAM_PUB.Is_Process_Active(p_chr_id) <> 'N') THEN
289:
290: OKC_API.set_message(p_app_name => g_app_name,
291: p_msg_name => 'OKL_VP_APPROVAL_PROCESS_ACTV'
292: );
293:
294: l_return_value := 'N';

Line 305: OKC_API.set_message(p_app_name => g_app_name,

301:
302: IF okc_util.Get_All_K_Access_Level(p_application_id => l_app_id,
303: p_chr_id => p_chr_id,
304: p_scs_code => l_scs_code) <> 'U' Then
305: OKC_API.set_message(p_app_name => g_app_name,
306: p_msg_name => 'OKL_NO_UPDATE',
307: p_token1 => 'CHR',
308: p_token1_value => l_k);
309: l_return_value :='N';

Line 387: p_init_msg_list => OKC_API.G_FALSE,

383: -- changes made on 6th Nov to do the validations okc is doing inside extend_chr
384: -- doing this to customize the messages ie to write okl messages
385:
386: Okl_Vp_Terminate_Pvt.validate_chr(p_api_version => l_api_version,
387: p_init_msg_list => OKC_API.G_FALSE,
388: x_return_status => l_return_status,
389: x_msg_count => l_msg_count,
390: x_msg_data => l_msg_data,
391: p_terminate_in_parameters_rec => l1_ter_header_rec);

Line 394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

390: x_msg_data => l_msg_data,
391: p_terminate_in_parameters_rec => l1_ter_header_rec);
392:
393:
394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
397: RAISE OKC_API.G_EXCEPTION_ERROR;
398: END IF;

Line 395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

391: p_terminate_in_parameters_rec => l1_ter_header_rec);
392:
393:
394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
397: RAISE OKC_API.G_EXCEPTION_ERROR;
398: END IF;
399: --59 lines

Line 396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

392:
393:
394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
397: RAISE OKC_API.G_EXCEPTION_ERROR;
398: END IF;
399: --59 lines
400: -- validate the passed parameters ie end date.

Line 397: RAISE OKC_API.G_EXCEPTION_ERROR;

393:
394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
397: RAISE OKC_API.G_EXCEPTION_ERROR;
398: END IF;
399: --59 lines
400: -- validate the passed parameters ie end date.
401: