DBA Data[Home] [Help]

APPS.OKC_RENEW_PUB dependencies on OKC_RENEW_PUB

Line 1: package body OKC_RENEW_PUB as

1: package body OKC_RENEW_PUB as
2: /* $Header: OKCPRENB.pls 120.4 2005/12/05 15:16:54 skekkar noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: /* Procedure Auto_Renew( errbuf out nocopy varchar2,retcode out varchar2 ) is

Line 58: OKC_RENEW_PUB.RENEW(p_api_version => 1,

54: for i in p_renew_in_parameters_tbl.first..p_renew_in_parameters_tbl.last loop
55:
56: if p_renew_in_parameters_tbl.exists(i) then
57:
58: OKC_RENEW_PUB.RENEW(p_api_version => 1,
59: p_init_msg_list => OKC_API.G_FALSE,
60: x_return_status => l_return_status,
61: x_msg_count => x_msg_count,
62: x_msg_data => x_msg_data,

Line 133: OKC_RENEW_PUB.PRE_RENEW(p_api_version => 1,

129: for i in p_renew_in_parameters_tbl.first..p_renew_in_parameters_tbl.last loop
130:
131: if p_renew_in_parameters_tbl.exists(i) then
132:
133: OKC_RENEW_PUB.PRE_RENEW(p_api_version => 1,
134: p_init_msg_list => OKC_API.G_FALSE,
135: x_return_status => l_return_status,
136: x_msg_count => x_msg_count,
137: x_msg_data => x_msg_data,

Line 275: --throw the error as it is, do not attempt to use OKC_RENEW_PUB.RENEW

271: g_prerenew_in_parameters_rec :=l_renew_in_parameters_rec;
272: EXCEPTION
273:
274: --anjkumar from R12, if OKS_RENEW_PUB.RENEW is not defined/compiled
275: --throw the error as it is, do not attempt to use OKC_RENEW_PUB.RENEW
276: /*
277: WHEN l_renew_not_found then
278: --dbms_output.put_line('san dbms l_renew_not_found');
279: IF instr(UPPER(sqlerrm),'PLS-00302') <> 0 OR instr(UPPER(sqlerrm),'PLS-00201') <> 0 then

Line 282: OKC_RENEW_PUB.RENEW(p_api_version => 1,

278: --dbms_output.put_line('san dbms l_renew_not_found');
279: IF instr(UPPER(sqlerrm),'PLS-00302') <> 0 OR instr(UPPER(sqlerrm),'PLS-00201') <> 0 then
280: --dbms_output.put_line('san dbms going to ren in exception');
281:
282: OKC_RENEW_PUB.RENEW(p_api_version => 1,
283: p_init_msg_list => OKC_API.G_FALSE,
284: x_return_status => x_return_status,
285: x_msg_count => x_msg_count,
286: x_msg_data => x_msg_data,

Line 311: OKC_RENEW_PUB.RENEW(p_api_version => 1,

307: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
308: END;
309: ELSE
310: --dbms_output.put_line('san dbms in pre ren else');
311: OKC_RENEW_PUB.RENEW(p_api_version => 1,
312: p_init_msg_list => OKC_API.G_FALSE,
313: x_return_status => x_return_status,
314: x_msg_count => x_msg_count,
315: x_msg_data => x_msg_data,

Line 450: OKC_RENEW_PUB.CREATE_RENEWED_CONTRACT( p_api_version => 1,

446: l_renew_in_parameters_rec.p_contract_id := p_renew_in_parameters_rec.p_contract_id;
447:
448:
449: --dbms_output.put_line('san dbms in 3');
450: OKC_RENEW_PUB.CREATE_RENEWED_CONTRACT( p_api_version => 1,
451: p_init_msg_list => OKC_API.G_FALSE,
452: x_return_status => l_return_status,
453: x_msg_count => x_msg_count,
454: x_msg_data => x_msg_data,

Line 473: OKC_RENEW_PUB.POST_RENEWED_CONTRACT( p_api_version => 1,

469: RAISE OKC_API.G_EXCEPTION_ERROR;
470: END IF;
471:
472: --dbms_output.put_line('san dbms in 4');
473: OKC_RENEW_PUB.POST_RENEWED_CONTRACT( p_api_version => 1,
474: p_init_msg_list => OKC_API.G_FALSE,
475: x_return_status => l_return_status,
476: x_msg_count => x_msg_count,
477: x_msg_data => x_msg_data,

Line 634: OKC_RENEW_PUB.validate( p_api_version => p_api_version,

630: for i in p_renew_in_parameters_tbl.first..p_renew_in_parameters_tbl.last loop
631:
632: if p_renew_in_parameters_tbl.exists(i) then
633:
634: OKC_RENEW_PUB.validate( p_api_version => p_api_version,
635: p_init_msg_list => OKC_API.G_FALSE,
636: x_return_status => l_return_status,
637: x_msg_count => x_msg_count,
638: x_msg_data => x_msg_data,

Line 753: end OKC_RENEW_PUB;

749: return l_condition;
750:
751: END is_already_not_renewed;
752:
753: end OKC_RENEW_PUB;