APPS.OKL_CURE_REQUEST_PVT dependencies on OKL_API

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

13: l_msg_count NUMBER ;
14: l_msg_data VARCHAR2(2000);
15: l_message VARCHAR2(2000);
16: l_api_version CONSTANT NUMBER := 1;
17: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18: l_api_name CONSTANT VARCHAR2(30) := 'Vendor Cure Request';
19:
20: l_rows_processed NUMBER := 0;
21: l_rows_failed NUMBER := 0;

Line 39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;

35: l_request_id NUMBER;
36: l_request_date okl_cure_reports.report_date%TYPE := TRUNC(SYSDATE);
37: l_request_number okl_cure_reports.report_number%TYPE;
38:
39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;
40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;
41: l_vendor_passed VARCHAR2(1) := OKL_API.G_TRUE;
42: l_contract_passed VARCHAR2(1) := OKL_API.G_TRUE;
43:

Line 40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;

36: l_request_date okl_cure_reports.report_date%TYPE := TRUNC(SYSDATE);
37: l_request_number okl_cure_reports.report_number%TYPE;
38:
39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;
40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;
41: l_vendor_passed VARCHAR2(1) := OKL_API.G_TRUE;
42: l_contract_passed VARCHAR2(1) := OKL_API.G_TRUE;
43:
44: l_current_date DATE;

Line 41: l_vendor_passed VARCHAR2(1) := OKL_API.G_TRUE;

37: l_request_number okl_cure_reports.report_number%TYPE;
38:
39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;
40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;
41: l_vendor_passed VARCHAR2(1) := OKL_API.G_TRUE;
42: l_contract_passed VARCHAR2(1) := OKL_API.G_TRUE;
43:
44: l_current_date DATE;
45: l_msg_index_out NUMBER :=0;

Line 42: l_contract_passed VARCHAR2(1) := OKL_API.G_TRUE;

38:
39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;
40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;
41: l_vendor_passed VARCHAR2(1) := OKL_API.G_TRUE;
42: l_contract_passed VARCHAR2(1) := OKL_API.G_TRUE;
43:
44: l_current_date DATE;
45: l_msg_index_out NUMBER :=0;
46:

Line 103: IF (l_email = OKL_API.G_MISS_CHAR OR l_email IS NULL) THEN

99: -- open cursor for requests to be processed
100: FOR i IN report_csr(l_current_date, l_request_number, l_vendor_id)
101: LOOP
102: l_email := i.email_address;
103: IF (l_email = OKL_API.G_MISS_CHAR OR l_email IS NULL) THEN
104: RAISE G_MISSING_EMAIL_ID;
105: END IF;
106: Fnd_File.PUT_LINE(Fnd_File.LOG,'Email is '||l_email);
107:

Line 108: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

104: RAISE G_MISSING_EMAIL_ID;
105: END IF;
106: Fnd_File.PUT_LINE(Fnd_File.LOG,'Email is '||l_email);
107:
108: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
109: l_bind_var(1) := 'p_report_id';
110: l_bind_val(1) := i.cure_report_id;
111: l_bind_var_type(1) := 'NUMBER';
112:

Line 142: p_init_msg_list => okl_api.G_TRUE,

138: --call fulfillment
139: OKL_FULFILLMENT_PUB.create_fulfillment
140: (
141: p_api_version => l_api_version,
142: p_init_msg_list => okl_api.G_TRUE,
143: p_agent_id => l_agent_id,
144: p_content_id => l_content_id,
145: p_from => l_from,
146: p_subject => l_subject,

Line 158: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN

154: x_msg_data => l_msg_data
155: );
156: -- If the return status is error write to log and proceed
157: -- with the rest of the requests
158: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
159: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
160: 'Cure Request could not be sent for request = '
161: || i.report_number);
162: IF l_msg_count IS NULL THEN

Line 182: IF (l_return_status = okl_api.G_RET_STS_SUCCESS) THEN

178:
179:
180: -- Return = SUCCESS - update report status to
181: -- SENT_TO_VENDOR
182: IF (l_return_status = okl_api.G_RET_STS_SUCCESS) THEN
183:
184: l_crtv_rec.approval_status :='SENT_TO_VENDOR';
185: l_crtv_rec.cure_report_id :=i.cure_report_id;
186: l_crtv_rec.object_version_number := i.object_version_number;

Line 190: ,p_init_msg_list => okl_api.G_TRUE

186: l_crtv_rec.object_version_number := i.object_version_number;
187:
188: OKL_cure_reports_pub.update_cure_reports(
189: p_api_version => l_api_version
190: ,p_init_msg_list => okl_api.G_TRUE
191: ,x_return_status => l_return_status
192: ,x_msg_count => l_msg_count
193: ,x_msg_data => l_msg_data
194: ,p_crtv_rec => l_crtv_rec

Line 198: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN

194: ,p_crtv_rec => l_crtv_rec
195: ,x_crtv_rec => lx_crtv_rec);
196: -- If the return status is error write to log and proceed
197: -- with the rest of the requests
198: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
199: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
200: 'Cure Request Status could not be updated for request = '
201: || i.report_number);
202: IF l_msg_count IS NULL THEN

Line 223: l_return_status :=OKL_API.G_RET_STS_SUCCESS;

219:
220: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Cure Request = ' || i.report_number);
221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent for Vendor = ' || to_char(l_vendor_id));
222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent on Date = ' || SYSDATE);
223: l_return_status :=OKL_API.G_RET_STS_SUCCESS;
224:
225: END LOOP;
226:
227: retcode := 0;