APPS.OKL_BILLING_CORR_REQ_WF dependencies on OKL_API

Line 17: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

13: l_key varchar2(240);
14: l_event_name varchar2(240) := 'oracle.apps.okl.cs.billingcorrrequest';
15:
16: l_seq NUMBER;
17: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
18: CURSOR okl_key_csr IS
19: SELECT okl_wf_item_s.nextval
20: FROM dual;
21: BEGIN

Line 39: x_return_status := OKL_API.G_RET_STS_ERROR;

35: x_return_status := l_return_status;
36: l_parameter_list.DELETE;
37: EXCEPTION
38: WHEN OTHERS THEN
39: x_return_status := OKL_API.G_RET_STS_ERROR;
40: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
41: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
42: FND_MSG_PUB.ADD;
43: ROLLBACK TO raise_billing_correction_event;

Line 40: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

36: l_parameter_list.DELETE;
37: EXCEPTION
38: WHEN OTHERS THEN
39: x_return_status := OKL_API.G_RET_STS_ERROR;
40: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
41: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
42: FND_MSG_PUB.ADD;
43: ROLLBACK TO raise_billing_correction_event;
44: END raise_billing_correction_event;

Line 55: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

51: actid in number,
52: funcmode in varchar2,
53: resultout out nocopy varchar2)
54: AS
55: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
56: l_api_version NUMBER := 1.0;
57: l_msg_count NUMBER;
58: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
59: l_msg_data VARCHAR2(2000);

Line 58: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

54: AS
55: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
56: l_api_version NUMBER := 1.0;
57: l_msg_count NUMBER;
58: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
59: l_msg_data VARCHAR2(2000);
60:
61: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
62: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 97: RAISE OKL_API.G_EXCEPTION_ERROR;

93:
94: OPEN c_fetch_r_number(l_trx_id);
95: FETCH c_fetch_r_number INTO l_request_num;
96: IF c_fetch_r_number%NOTFOUND THEN
97: RAISE OKL_API.G_EXCEPTION_ERROR;
98: END IF;
99: CLOSE c_fetch_r_number;
100:
101: OPEN c_fetch_k_number(l_chrv_id);

Line 104: RAISE OKL_API.G_EXCEPTION_ERROR;

100:
101: OPEN c_fetch_k_number(l_chrv_id);
102: FETCH c_fetch_k_number INTO l_contract_num;
103: IF c_fetch_k_number%NOTFOUND THEN
104: RAISE OKL_API.G_EXCEPTION_ERROR;
105: END IF;
106: CLOSE c_fetch_k_number;
107:
108: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 130: WHEN OKL_API.G_EXCEPTION_ERROR THEN

126: resultout := 'COMPLETE:';
127: return;
128: END IF;
129: EXCEPTION
130: WHEN OKL_API.G_EXCEPTION_ERROR THEN
131: IF c_fetch_r_number%ISOPEN THEN
132: CLOSE c_fetch_r_number;
133: END IF;
134: wf_core.context('OKL_BILLING_CORR_REQ_WF',

Line 141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

137: itemkey,
138: to_char(actid),
139: funcmode);
140: RAISE;
141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
142: IF c_fetch_r_number%ISOPEN THEN
143: CLOSE c_fetch_r_number;
144: END IF;
145: wf_core.context('OKL_BILLING_CORR_REQ_WF',

Line 174: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

170: actid in number,
171: funcmode in varchar2,
172: resultout out nocopy varchar2) AS
173:
174: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
175: l_api_version NUMBER := 1.0;
176: l_msg_count NUMBER;
177: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
178: l_msg_data VARCHAR2(2000);

Line 177: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

173:
174: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
175: l_api_version NUMBER := 1.0;
176: l_msg_count NUMBER;
177: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
178: l_msg_data VARCHAR2(2000);
179:
180: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
181: l_trx_id NUMBER;

Line 225: WHEN OKL_API.G_EXCEPTION_ERROR THEN

221: resultout := 'COMPLETE:NO';
222: return;
223: END IF;
224: EXCEPTION
225: WHEN OKL_API.G_EXCEPTION_ERROR THEN
226: wf_core.context('OKL_BILLING_CORR_REQ_WF',
227: 'Billing_Correction_Req',
228: itemtype,
229: itemkey,

Line 233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

229: itemkey,
230: to_char(actid),
231: funcmode);
232: RAISE;
233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
234: wf_core.context('OKL_BILLING_CORR_REQ_WF',
235: 'Billing_Correction_Req',
236: itemtype,
237: itemkey,