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_PAYMENT_PVT dependencies on OKL_API

Line 49: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

45: FROM okc_k_headers_b
46: WHERE id = p_contract_id;
47:
48: l_api_version NUMBER;
49: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
50: l_msg_count NUMBER;
51: l_msg_data VARCHAR2(2000);
52:
53: BEGIN

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

75: -- PROCEDURE CREATE_INTERNAL_TRANS
76: ---------------------------------------------------------------------------
77: PROCEDURE CREATE_INTERNAL_TRANS(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
80: p_customer_id IN NUMBER,
81: p_contract_id IN NUMBER,
82: p_contract_num IN VARCHAR2 DEFAULT NULL,
83: p_payment_method_id IN NUMBER,

Line 97: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

93: IS
94:
95: l_api_version CONSTANT NUMBER := 1;
96: l_api_name CONSTANT VARCHAR2(30) := 'OKL_PAYMENT_PVT';
97: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
98: i NUMBER := 1;
99: l_check NUMBER := 0;
100: l_org_id NUMBER;
101: l_rctv_rec rctv_rec_type;

Line 126: l_return_status := okl_api.START_ACTIVITY(l_api_name,

122: l_functional_currency okl_trx_contracts.currency_code%TYPE;
123:
124: BEGIN
125:
126: l_return_status := okl_api.START_ACTIVITY(l_api_name,
127: G_PKG_NAME,
128: p_init_msg_list,
129: l_api_version,
130: p_api_version,

Line 137: OKL_API.set_message(p_app_name => G_APP_NAME,

133:
134: /* Processing Starts */
135: -- Check if Customer ID is null
136: IF p_customer_id IS NULL THEN
137: OKL_API.set_message(p_app_name => G_APP_NAME,
138: p_msg_name => G_CUSTOMER_ID_NULL );
139: RAISE okl_api.G_EXCEPTION_ERROR;
140: END IF;
141:

Line 139: RAISE okl_api.G_EXCEPTION_ERROR;

135: -- Check if Customer ID is null
136: IF p_customer_id IS NULL THEN
137: OKL_API.set_message(p_app_name => G_APP_NAME,
138: p_msg_name => G_CUSTOMER_ID_NULL );
139: RAISE okl_api.G_EXCEPTION_ERROR;
140: END IF;
141:
142: -- Check if Contract ID is null
143: IF p_contract_id IS NULL THEN

Line 144: OKL_API.set_message(p_app_name => G_APP_NAME,

140: END IF;
141:
142: -- Check if Contract ID is null
143: IF p_contract_id IS NULL THEN
144: OKL_API.set_message(p_app_name => G_APP_NAME,
145: p_msg_name => G_CONTRACT_ID_NULL );
146: RAISE okl_api.G_EXCEPTION_ERROR;
147: END IF;
148:

Line 146: RAISE okl_api.G_EXCEPTION_ERROR;

142: -- Check if Contract ID is null
143: IF p_contract_id IS NULL THEN
144: OKL_API.set_message(p_app_name => G_APP_NAME,
145: p_msg_name => G_CONTRACT_ID_NULL );
146: RAISE okl_api.G_EXCEPTION_ERROR;
147: END IF;
148:
149: -- Get org Id for the contract
150: --l_return_status := get_org_id(p_contract_id, l_org_id);

Line 153: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

149: -- Get org Id for the contract
150: --l_return_status := get_org_id(p_contract_id, l_org_id);
151:
152: l_org_id :=mo_global.get_current_org_id();
153: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
156: RAISE okl_api.G_EXCEPTION_ERROR;
157: END IF;

Line 154: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

150: --l_return_status := get_org_id(p_contract_id, l_org_id);
151:
152: l_org_id :=mo_global.get_current_org_id();
153: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
156: RAISE okl_api.G_EXCEPTION_ERROR;
157: END IF;
158:

Line 155: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

151:
152: l_org_id :=mo_global.get_current_org_id();
153: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
156: RAISE okl_api.G_EXCEPTION_ERROR;
157: END IF;
158:
159: -- get payment method

Line 156: RAISE okl_api.G_EXCEPTION_ERROR;

152: l_org_id :=mo_global.get_current_org_id();
153: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
154: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
155: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
156: RAISE okl_api.G_EXCEPTION_ERROR;
157: END IF;
158:
159: -- get payment method
160: OPEN get_receipt_method_csr(p_payment_method_id);

Line 166: OKL_API.set_message(p_app_name => G_APP_NAME,

162: CLOSE get_receipt_method_csr;
163:
164: -- Check if payment_method is null
165: IF (l_check <> 1) THEN
166: OKL_API.set_message(p_app_name => G_APP_NAME,
167: p_msg_name => G_PAYMENT_METHOD_INVALID );
168: RAISE okl_api.G_EXCEPTION_ERROR;
169: END IF;
170:

Line 168: RAISE okl_api.G_EXCEPTION_ERROR;

164: -- Check if payment_method is null
165: IF (l_check <> 1) THEN
166: OKL_API.set_message(p_app_name => G_APP_NAME,
167: p_msg_name => G_PAYMENT_METHOD_INVALID );
168: RAISE okl_api.G_EXCEPTION_ERROR;
169: END IF;
170:
171: -- Create record in Internal Transaction Table.
172: -- CREATE HEADER REC

Line 210: OKL_API.set_message(p_app_name => G_APP_NAME,

206: l_rctv_rec.exchange_rate_date := '01-JAN-03';
207:
208: IF (l_rctv_rec.exchange_rate_type IS NULL) AND (l_rctv_rec.exchange_rate IS NULL)
209: AND (l_rctv_rec.exchange_rate_date IS NULL) THEN
210: OKL_API.set_message(p_app_name => G_APP_NAME,
211: p_msg_name => G_PAYMENT_METHOD_INVALID );
212: RAISE okl_api.G_EXCEPTION_ERROR;
213: END IF;
214: */

Line 212: RAISE okl_api.G_EXCEPTION_ERROR;

208: IF (l_rctv_rec.exchange_rate_type IS NULL) AND (l_rctv_rec.exchange_rate IS NULL)
209: AND (l_rctv_rec.exchange_rate_date IS NULL) THEN
210: OKL_API.set_message(p_app_name => G_APP_NAME,
211: p_msg_name => G_PAYMENT_METHOD_INVALID );
212: RAISE okl_api.G_EXCEPTION_ERROR;
213: END IF;
214: */
215:
216: l_rcav_tbl(i).CNR_ID := NULL;

Line 238: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

234: ,x_rctv_rec
235: ,x_rcav_tbl
236: );
237:
238: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
239: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
240: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
241: RAISE okl_api.G_EXCEPTION_ERROR;
242: END IF;

Line 239: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

235: ,x_rcav_tbl
236: );
237:
238: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
239: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
240: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
241: RAISE okl_api.G_EXCEPTION_ERROR;
242: END IF;
243:

Line 240: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

236: );
237:
238: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
239: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
240: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
241: RAISE okl_api.G_EXCEPTION_ERROR;
242: END IF;
243:
244: x_payment_id := x_rctv_rec.id;

Line 241: RAISE okl_api.G_EXCEPTION_ERROR;

237:
238: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
239: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
240: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
241: RAISE okl_api.G_EXCEPTION_ERROR;
242: END IF;
243:
244: x_payment_id := x_rctv_rec.id;
245: x_return_status := l_return_status;

Line 249: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

245: x_return_status := l_return_status;
246:
247: /* Processing Ends */
248:
249: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
250:
251: EXCEPTION
252: WHEN okl_api.G_EXCEPTION_ERROR THEN
253: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 252: WHEN okl_api.G_EXCEPTION_ERROR THEN

248:
249: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
250:
251: EXCEPTION
252: WHEN okl_api.G_EXCEPTION_ERROR THEN
253: x_return_status := okl_api.HANDLE_EXCEPTIONS
254: (
255: l_api_name,
256: G_PKG_NAME,

Line 253: x_return_status := okl_api.HANDLE_EXCEPTIONS

249: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
250:
251: EXCEPTION
252: WHEN okl_api.G_EXCEPTION_ERROR THEN
253: x_return_status := okl_api.HANDLE_EXCEPTIONS
254: (
255: l_api_name,
256: G_PKG_NAME,
257: 'okl_api.G_RET_STS_ERROR',

Line 257: 'okl_api.G_RET_STS_ERROR',

253: x_return_status := okl_api.HANDLE_EXCEPTIONS
254: (
255: l_api_name,
256: G_PKG_NAME,
257: 'okl_api.G_RET_STS_ERROR',
258: x_msg_count,
259: x_msg_data,
260: '_PAYMENT'
261: );

Line 262: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

258: x_msg_count,
259: x_msg_data,
260: '_PAYMENT'
261: );
262: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
263: x_return_status :=okl_api.HANDLE_EXCEPTIONS
264: (
265: l_api_name,
266: G_PKG_NAME,

Line 263: x_return_status :=okl_api.HANDLE_EXCEPTIONS

259: x_msg_data,
260: '_PAYMENT'
261: );
262: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
263: x_return_status :=okl_api.HANDLE_EXCEPTIONS
264: (
265: l_api_name,
266: G_PKG_NAME,
267: 'okl_api.G_RET_STS_UNEXP_ERROR',

Line 267: 'okl_api.G_RET_STS_UNEXP_ERROR',

263: x_return_status :=okl_api.HANDLE_EXCEPTIONS
264: (
265: l_api_name,
266: G_PKG_NAME,
267: 'okl_api.G_RET_STS_UNEXP_ERROR',
268: x_msg_count,
269: x_msg_data,
270: '_PAYMENT'
271: );

Line 273: x_return_status :=okl_api.HANDLE_EXCEPTIONS

269: x_msg_data,
270: '_PAYMENT'
271: );
272: WHEN OTHERS THEN
273: x_return_status :=okl_api.HANDLE_EXCEPTIONS
274: (
275: l_api_name,
276: G_PKG_NAME,
277: 'OTHERS',

Line 289: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

285: -- PROCEDURE CREATE_INTERNAL_TRANS
286: ---------------------------------------------------------------------------
287: PROCEDURE CREATE_INTERNAL_TRANS(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
290: p_customer_id IN NUMBER,
291: p_invoice_id IN NUMBER,
292: p_payment_method_id IN NUMBER,
293: p_payment_ref_number IN VARCHAR2,

Line 306: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

302: IS
303:
304: l_api_version CONSTANT NUMBER := 1;
305: l_api_name CONSTANT VARCHAR2(30) := 'OKL_PAYMENT_PVT';
306: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
307: i NUMBER := 1;
308: l_check NUMBER := 0;
309: l_org_id NUMBER;
310: l_rctv_rec rctv_rec_type;

Line 346: l_return_status := okl_api.START_ACTIVITY(l_api_name,

342: l_functional_currency okl_trx_contracts.currency_code%TYPE;
343:
344: BEGIN
345:
346: l_return_status := okl_api.START_ACTIVITY(l_api_name,
347: G_PKG_NAME,
348: p_init_msg_list,
349: l_api_version,
350: p_api_version,

Line 357: OKL_API.set_message(p_app_name => G_APP_NAME,

353:
354: /* Processing Starts */
355: -- Check if Customer ID is null
356: IF p_customer_id IS NULL THEN
357: OKL_API.set_message(p_app_name => G_APP_NAME,
358: p_msg_name => G_CUSTOMER_ID_NULL );
359: RAISE okl_api.G_EXCEPTION_ERROR;
360: END IF;
361:

Line 359: RAISE okl_api.G_EXCEPTION_ERROR;

355: -- Check if Customer ID is null
356: IF p_customer_id IS NULL THEN
357: OKL_API.set_message(p_app_name => G_APP_NAME,
358: p_msg_name => G_CUSTOMER_ID_NULL );
359: RAISE okl_api.G_EXCEPTION_ERROR;
360: END IF;
361:
362: -- Check if Contract ID is null
363: IF p_invoice_id IS NULL THEN

Line 364: OKL_API.set_message(p_app_name => G_APP_NAME,

360: END IF;
361:
362: -- Check if Contract ID is null
363: IF p_invoice_id IS NULL THEN
364: OKL_API.set_message(p_app_name => G_APP_NAME,
365: p_msg_name => G_INVOICE_ID_NULL );
366: RAISE okl_api.G_EXCEPTION_ERROR;
367: END IF;
368:

Line 366: RAISE okl_api.G_EXCEPTION_ERROR;

362: -- Check if Contract ID is null
363: IF p_invoice_id IS NULL THEN
364: OKL_API.set_message(p_app_name => G_APP_NAME,
365: p_msg_name => G_INVOICE_ID_NULL );
366: RAISE okl_api.G_EXCEPTION_ERROR;
367: END IF;
368:
369: -- Get org Id for OKL
370: l_org_id :=mo_global.get_current_org_id();

Line 379: OKL_API.set_message(p_app_name => G_APP_NAME,

375: CLOSE get_receipt_method_csr;
376:
377: -- Check if payment_method is null
378: IF (l_check <> 1) THEN
379: OKL_API.set_message(p_app_name => G_APP_NAME,
380: p_msg_name => G_PAYMENT_METHOD_INVALID );
381: RAISE okl_api.G_EXCEPTION_ERROR;
382: END IF;
383:

Line 381: RAISE okl_api.G_EXCEPTION_ERROR;

377: -- Check if payment_method is null
378: IF (l_check <> 1) THEN
379: OKL_API.set_message(p_app_name => G_APP_NAME,
380: p_msg_name => G_PAYMENT_METHOD_INVALID );
381: RAISE okl_api.G_EXCEPTION_ERROR;
382: END IF;
383:
384:
385: -- populate the currency conversion fields

Line 414: OKL_API.set_message(p_app_name => G_APP_NAME,

410: l_rctv_rec.exchange_rate_date := '01-JAN-03';
411:
412: IF (l_rctv_rec.exchange_rate_type IS NULL) AND (l_rctv_rec.exchange_rate IS NULL)
413: AND (l_rctv_rec.exchange_rate_date IS NULL) THEN
414: OKL_API.set_message(p_app_name => G_APP_NAME,
415: p_msg_name => G_PAYMENT_METHOD_INVALID );
416: RAISE okl_api.G_EXCEPTION_ERROR;
417: END IF;
418: */

Line 416: RAISE okl_api.G_EXCEPTION_ERROR;

412: IF (l_rctv_rec.exchange_rate_type IS NULL) AND (l_rctv_rec.exchange_rate IS NULL)
413: AND (l_rctv_rec.exchange_rate_date IS NULL) THEN
414: OKL_API.set_message(p_app_name => G_APP_NAME,
415: p_msg_name => G_PAYMENT_METHOD_INVALID );
416: RAISE okl_api.G_EXCEPTION_ERROR;
417: END IF;
418: */
419:
420: -- Create record in Internal Transaction Table.

Line 454: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

450: ,x_rctv_rec
451: ,x_rcav_tbl
452: );
453:
454: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
457: RAISE okl_api.G_EXCEPTION_ERROR;
458: END IF;

Line 455: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

451: ,x_rcav_tbl
452: );
453:
454: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
457: RAISE okl_api.G_EXCEPTION_ERROR;
458: END IF;
459:

Line 456: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

452: );
453:
454: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
457: RAISE okl_api.G_EXCEPTION_ERROR;
458: END IF;
459:
460: x_payment_id := x_rctv_rec.id;

Line 457: RAISE okl_api.G_EXCEPTION_ERROR;

453:
454: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
457: RAISE okl_api.G_EXCEPTION_ERROR;
458: END IF;
459:
460: x_payment_id := x_rctv_rec.id;
461: x_return_status := l_return_status;

Line 465: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

461: x_return_status := l_return_status;
462:
463: /* Processing Ends */
464:
465: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
466:
467: EXCEPTION
468: WHEN okl_api.G_EXCEPTION_ERROR THEN
469: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 468: WHEN okl_api.G_EXCEPTION_ERROR THEN

464:
465: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
466:
467: EXCEPTION
468: WHEN okl_api.G_EXCEPTION_ERROR THEN
469: x_return_status := okl_api.HANDLE_EXCEPTIONS
470: (
471: l_api_name,
472: G_PKG_NAME,

Line 469: x_return_status := okl_api.HANDLE_EXCEPTIONS

465: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
466:
467: EXCEPTION
468: WHEN okl_api.G_EXCEPTION_ERROR THEN
469: x_return_status := okl_api.HANDLE_EXCEPTIONS
470: (
471: l_api_name,
472: G_PKG_NAME,
473: 'okl_api.G_RET_STS_ERROR',

Line 473: 'okl_api.G_RET_STS_ERROR',

469: x_return_status := okl_api.HANDLE_EXCEPTIONS
470: (
471: l_api_name,
472: G_PKG_NAME,
473: 'okl_api.G_RET_STS_ERROR',
474: x_msg_count,
475: x_msg_data,
476: '_PAYMENT'
477: );

Line 478: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

474: x_msg_count,
475: x_msg_data,
476: '_PAYMENT'
477: );
478: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
479: x_return_status :=okl_api.HANDLE_EXCEPTIONS
480: (
481: l_api_name,
482: G_PKG_NAME,

Line 479: x_return_status :=okl_api.HANDLE_EXCEPTIONS

475: x_msg_data,
476: '_PAYMENT'
477: );
478: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
479: x_return_status :=okl_api.HANDLE_EXCEPTIONS
480: (
481: l_api_name,
482: G_PKG_NAME,
483: 'okl_api.G_RET_STS_UNEXP_ERROR',

Line 483: 'okl_api.G_RET_STS_UNEXP_ERROR',

479: x_return_status :=okl_api.HANDLE_EXCEPTIONS
480: (
481: l_api_name,
482: G_PKG_NAME,
483: 'okl_api.G_RET_STS_UNEXP_ERROR',
484: x_msg_count,
485: x_msg_data,
486: '_PAYMENT'
487: );

Line 489: x_return_status :=okl_api.HANDLE_EXCEPTIONS

485: x_msg_data,
486: '_PAYMENT'
487: );
488: WHEN OTHERS THEN
489: x_return_status :=okl_api.HANDLE_EXCEPTIONS
490: (
491: l_api_name,
492: G_PKG_NAME,
493: 'OTHERS',

Line 506: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

502: -- PROCEDURE CREATE_PAYMENTS
503: ---------------------------------------------------------------------------
504: PROCEDURE CREATE_PAYMENTS(
505: p_api_version IN NUMBER,
506: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
507: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
508: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
509: x_return_status OUT NOCOPY VARCHAR2,
510: x_msg_count OUT NOCOPY NUMBER,

Line 522: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

518: IS
519:
520: l_api_version CONSTANT NUMBER := 1.0;
521: l_api_name CONSTANT VARCHAR2(30) := 'OKL_PAYMENT_PVT';
522: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
523: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
524: l_msg_count NUMBER;
525: l_msg_data VARCHAR2(2000);
526: i NUMBER := 1;

Line 673: l_return_status := okl_api.START_ACTIVITY(l_api_name,

669: 'p_expiration_date :'||p_receipt_rec.expiration_date);
670:
671: END IF;
672:
673: l_return_status := okl_api.START_ACTIVITY(l_api_name,
674: G_PKG_NAME,
675: p_init_msg_list,
676: l_api_version,
677: p_api_version,

Line 814: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

810: END loop;
811: MO_GLOBAL.set_policy_context('M',-1);
812: x_return_status := l_return_status;
813:
814: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;

Line 815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

811: MO_GLOBAL.set_policy_context('M',-1);
812: x_return_status := l_return_status;
813:
814: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;
819:

Line 816: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

812: x_return_status := l_return_status;
813:
814: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;
819:
820: IF l_cash_receipt_id IS NOT NULL THEN

Line 817: RAISE OKL_API.G_EXCEPTION_ERROR;

813:
814: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;
819:
820: IF l_cash_receipt_id IS NOT NULL THEN
821: l_payment_ref_number := OKL_PAYMENT_PUB.get_ar_receipt_number(l_cash_receipt_id);

Line 828: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

824: x_msg_data := l_msg_data;
825: x_msg_count := l_msg_count;
826: x_payment_ref_number := l_payment_ref_number;
827: x_cash_receipt_id := l_cash_receipt_id;
828: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
829:
830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PAYMENT_PVT.CREATE_PAYMENTS','end(-)');
832: END IF;

Line 839: WHEN OKL_API.G_EXCEPTION_ERROR THEN

835:
836: WHEN G_EXCEPTION_HALT_VALIDATION THEN
837: x_return_status := OKC_API.G_RET_STS_ERROR;
838:
839: WHEN OKL_API.G_EXCEPTION_ERROR THEN
840: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
842: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
843: END IF;

Line 842: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

838:
839: WHEN OKL_API.G_EXCEPTION_ERROR THEN
840: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
842: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
843: END IF;
844:
845: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
846: l_api_name,

Line 845: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

841: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
842: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
843: END IF;
844:
845: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
846: l_api_name,
847: G_PKG_NAME,
848: 'OKL_API.G_RET_STS_ERROR',
849: x_msg_count,

Line 848: 'OKL_API.G_RET_STS_ERROR',

844:
845: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
846: l_api_name,
847: G_PKG_NAME,
848: 'OKL_API.G_RET_STS_ERROR',
849: x_msg_count,
850: x_msg_data,
851: '_PVT');
852:

Line 853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

849: x_msg_count,
850: x_msg_data,
851: '_PVT');
852:
853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
854: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
856: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
857: END IF;

Line 856: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

852:
853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
854: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
856: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
857: END IF;
858:
859: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
860: l_api_name,

Line 859: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
856: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
857: END IF;
858:
859: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
860: l_api_name,
861: G_PKG_NAME,
862: 'OKL_API.G_RET_STS_UNEXP_ERROR',
863: x_msg_count,

Line 862: 'OKL_API.G_RET_STS_UNEXP_ERROR',

858:
859: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
860: l_api_name,
861: G_PKG_NAME,
862: 'OKL_API.G_RET_STS_UNEXP_ERROR',
863: x_msg_count,
864: x_msg_data,
865: '_PVT');
866:

Line 874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

870: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PAYMENT.CREATE_PAYMENTS ',
871: 'EXCEPTION :'||sqlerrm);
872: END IF;
873:
874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
875: l_api_name,
876: G_PKG_NAME,
877: 'OTHERS',
878: x_msg_count,