APPS.OKC_OKS_PUB dependencies on OKC_API

Line 162: x_return_status := OKC_API.G_RET_STS_SUCCESS;

158: and a.object_cle_id = l_cle_id;
159:
160: l_target_id number;
161: Begin
162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
163:
164: -- Bug 3280617
165: OPEN c_chr(p_chr_id);
166: FETCH c_chr INTO l_k, l_mod;

Line 169: IF(l_mod is NULL) and (l_mod <> OKC_API.G_MISS_CHAR) then

165: OPEN c_chr(p_chr_id);
166: FETCH c_chr INTO l_k, l_mod;
167: CLOSE c_chr;
168:
169: IF(l_mod is NULL) and (l_mod <> OKC_API.G_MISS_CHAR) then
170: l_k := l_k ||'-'||l_mod;
171: END IF;
172:
173: -- Check headers status ------

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

174: Open get_source_status(p_chr_id);
175: Fetch get_source_status into l_hdr_status;
176: If get_source_status%NOTFOUND Then
177: -- Bug 3280617
178: OKC_API.set_message(p_app_name => g_app_name,
179: p_msg_name => 'OKC_INVALID_STS',
180: p_token1 => 'component',
181: p_token1_value => l_k);
182: return false;

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

202: -- Bug 3408853
203: -- Bug 3482145 Setting the error message outside the For loop if l_can_renew is false
204: -- to prevent the error message getting displayed multiple times.
205: if not l_can_renew then
206: OKC_API.set_message(p_app_name => g_app_name,
207: p_msg_name => 'OKC_K_RENEW_CONSOLIDATED');
208: end if;
209: Return l_can_renew;
210:

Line 213: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

209: Return l_can_renew;
210:
211: EXCEPTION
212: WHEN Others THEN
213: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
214: OKC_API.set_message
215: (
216: G_APP_NAME,
217: G_UNEXPECTED_ERROR,

Line 214: OKC_API.set_message

210:
211: EXCEPTION
212: WHEN Others THEN
213: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
214: OKC_API.set_message
215: (
216: G_APP_NAME,
217: G_UNEXPECTED_ERROR,
218: G_SQLCODE_TOKEN,

Line 238: l_return_flag varchar2(1) := OKC_API.G_TRUE;

234:
235: l_chr_id number;
236: l_line_id number;
237: l_sub_line_id number;
238: l_return_flag varchar2(1) := OKC_API.G_TRUE;
239:
240: cursor check_contr_type(l_chr_id number) is
241: select id
242: from okc_k_headers_b

Line 268: return OKC_API.G_TRUE;

264: Open check_contr_type(p_chr_id);
265: Fetch check_contr_type into l_chr_id;
266: If check_contr_type%NOTFOUND Then
267: Close check_contr_type;
268: return OKC_API.G_TRUE;
269: End If;
270: Close check_contr_type;
271:
272:

Line 281: l_return_flag := OKC_API.G_TRUE;

277: -- have any sub lines.
278: Open get_subscr_toplines(l_chr_id);
279: Fetch get_subscr_toplines into l_line_id;
280: If get_subscr_toplines%FOUND Then
281: l_return_flag := OKC_API.G_TRUE;
282: Else
283: OKC_API.set_message(p_app_name => g_app_name,
284: p_msg_name => 'OKC_LINES_SUBLINES_TERMINATED');
285: l_return_flag := OKC_API.G_FALSE;

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

279: Fetch get_subscr_toplines into l_line_id;
280: If get_subscr_toplines%FOUND Then
281: l_return_flag := OKC_API.G_TRUE;
282: Else
283: OKC_API.set_message(p_app_name => g_app_name,
284: p_msg_name => 'OKC_LINES_SUBLINES_TERMINATED');
285: l_return_flag := OKC_API.G_FALSE;
286: End If;
287: Close get_subscr_toplines;

Line 285: l_return_flag := OKC_API.G_FALSE;

281: l_return_flag := OKC_API.G_TRUE;
282: Else
283: OKC_API.set_message(p_app_name => g_app_name,
284: p_msg_name => 'OKC_LINES_SUBLINES_TERMINATED');
285: l_return_flag := OKC_API.G_FALSE;
286: End If;
287: Close get_subscr_toplines;
288: End If;
289: Close get_sub_lines;

Line 296: l_return_flag := OKC_API.G_FALSE;

292: return l_return_flag;
293:
294: EXCEPTION
295: WHEN Others THEN
296: l_return_flag := OKC_API.G_FALSE;
297: OKC_API.set_message
298: (
299: G_APP_NAME,
300: G_UNEXPECTED_ERROR,

Line 297: OKC_API.set_message

293:
294: EXCEPTION
295: WHEN Others THEN
296: l_return_flag := OKC_API.G_FALSE;
297: OKC_API.set_message
298: (
299: G_APP_NAME,
300: G_UNEXPECTED_ERROR,
301: G_SQLCODE_TOKEN,