DBA Data[Home] [Help]

APPS.OKL_BPD_CAP_ADV_MON_PVT dependencies on OKC_API

Line 27: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

23: -- End of comments
24: ---------------------------------------------------------------------------
25:
26: PROCEDURE handle_advanced_manual_pay ( p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: p_adv_rcpt_rec IN adv_rcpt_rec,

Line 103: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;

99: l_cont_applic VARCHAR2(1) DEFAULT 'N';
100: l_cons_bill_applic VARCHAR2(1) DEFAULT 'N';
101:
102: l_api_version NUMBER := 1.0;
103: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
104: l_return_status VARCHAR2(1);
105: l_msg_count NUMBER;
106: l_msg_data VARCHAR2(2000);
107:

Line 213: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

209: l_currency_code okl_k_headers_full_v.currency_code%type;
210:
211: BEGIN
212:
213: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
214: G_PKG_NAME,
215: p_init_msg_list,
216: l_api_version,
217: p_api_version,

Line 221: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

217: p_api_version,
218: '_PVT',
219: l_return_status);
220:
221: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
224: RAISE OKC_API.G_EXCEPTION_ERROR;
225: END IF;

Line 222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

218: '_PVT',
219: l_return_status);
220:
221: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
224: RAISE OKC_API.G_EXCEPTION_ERROR;
225: END IF;
226:

Line 223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

219: l_return_status);
220:
221: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
224: RAISE OKC_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: l_functional_currency := okl_accounting_util.get_func_curr_code;

Line 224: RAISE OKC_API.G_EXCEPTION_ERROR;

220:
221: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
224: RAISE OKC_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: l_functional_currency := okl_accounting_util.get_func_curr_code;
228:

Line 241: OKC_API.set_message( p_app_name => G_APP_NAME,

237: FETCH l_khr_curr_csr INTO l_currency_code;
238: CLOSE l_khr_curr_csr;
239:
240: IF (l_currency_code <> lp_adv_rcpt_rec.currency_code) THEN
241: OKC_API.set_message( p_app_name => G_APP_NAME,
242: p_msg_name =>'OKL_BPD_RCPT_KHR_CURR_ERROR');
243:
244: RAISE G_EXCEPTION_HALT_VALIDATION;
245: END IF;

Line 254: x_return_status := OKC_API.G_RET_STS_ERROR;

250: CLOSE c_dup_rcpt;
251:
252: IF l_dup_rcpt_flag = 1 THEN
253: -- Message Text: Duplicate receipt number for customer
254: x_return_status := OKC_API.G_RET_STS_ERROR;
255: OKC_API.set_message( p_app_name => G_APP_NAME,
256: p_msg_name => 'OKL_BPD_DUP_RECEIPT');
257:
258: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 255: OKC_API.set_message( p_app_name => G_APP_NAME,

251:
252: IF l_dup_rcpt_flag = 1 THEN
253: -- Message Text: Duplicate receipt number for customer
254: x_return_status := OKC_API.G_RET_STS_ERROR;
255: OKC_API.set_message( p_app_name => G_APP_NAME,
256: p_msg_name => 'OKL_BPD_DUP_RECEIPT');
257:
258: RAISE G_EXCEPTION_HALT_VALIDATION;
259: END IF;

Line 266: x_return_status := OKC_API.G_RET_STS_ERROR;

262: -- is not specified then display the error.
263: IF l_functional_currency <> l_receipt_currency_code AND l_currency_conv_type IN ('NONE') THEN
264:
265: -- Message Text: Please enter a currency type.
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267: OKC_API.set_message( p_app_name => G_APP_NAME,
268: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
269:
270: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 267: OKC_API.set_message( p_app_name => G_APP_NAME,

263: IF l_functional_currency <> l_receipt_currency_code AND l_currency_conv_type IN ('NONE') THEN
264:
265: -- Message Text: Please enter a currency type.
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267: OKC_API.set_message( p_app_name => G_APP_NAME,
268: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
269:
270: RAISE G_EXCEPTION_HALT_VALIDATION;
271:

Line 278: x_return_status := OKC_API.G_RET_STS_ERROR;

274: IF l_functional_currency = l_receipt_currency_code THEN
275: IF l_currency_conv_type IN ('CORPORATE', 'SPOT', 'USER') OR l_currency_conv_rate <> '0' THEN
276:
277: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
278: x_return_status := OKC_API.G_RET_STS_ERROR;
279: OKC_API.set_message( p_app_name => G_APP_NAME,
280: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
281:
282: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 279: OKC_API.set_message( p_app_name => G_APP_NAME,

275: IF l_currency_conv_type IN ('CORPORATE', 'SPOT', 'USER') OR l_currency_conv_rate <> '0' THEN
276:
277: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
278: x_return_status := OKC_API.G_RET_STS_ERROR;
279: OKC_API.set_message( p_app_name => G_APP_NAME,
280: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
281:
282: RAISE G_EXCEPTION_HALT_VALIDATION;
283:

Line 316: x_return_status := OKC_API.G_RET_STS_ERROR;

312:
313: IF l_functional_conversion_rate IN (0,-1) THEN
314:
315: -- Message Text: No exchange rate defined
316: x_return_status := OKC_API.G_RET_STS_ERROR;
317: OKC_API.set_message( p_app_name => G_APP_NAME,
318: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
319:
320: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 317: OKC_API.set_message( p_app_name => G_APP_NAME,

313: IF l_functional_conversion_rate IN (0,-1) THEN
314:
315: -- Message Text: No exchange rate defined
316: x_return_status := OKC_API.G_RET_STS_ERROR;
317: OKC_API.set_message( p_app_name => G_APP_NAME,
318: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
319:
320: RAISE G_EXCEPTION_HALT_VALIDATION;
321: END IF;

Line 330: x_return_status := OKC_API.G_RET_STS_ERROR;

326:
327: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
328:
329: -- Message Text: No exchange rate defined for currency conversion type USER.
330: x_return_status := OKC_API.G_RET_STS_ERROR;
331: OKC_API.set_message( p_app_name => G_APP_NAME,
332: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
333:
334: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 331: OKC_API.set_message( p_app_name => G_APP_NAME,

327: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
328:
329: -- Message Text: No exchange rate defined for currency conversion type USER.
330: x_return_status := OKC_API.G_RET_STS_ERROR;
331: OKC_API.set_message( p_app_name => G_APP_NAME,
332: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
333:
334: RAISE G_EXCEPTION_HALT_VALIDATION;
335:

Line 356: x_return_status := OKC_API.G_RET_STS_ERROR;

352: END IF;
353:
354: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
355: -- Message Text: The receipt cannot have a value of zero
356: x_return_status := OKC_API.G_RET_STS_ERROR;
357: OKC_API.set_message( p_app_name => G_APP_NAME,
358: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
359:
360: RAISE G_EXCEPTION_HALT_VALIDATION;

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

353:
354: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
355: -- Message Text: The receipt cannot have a value of zero
356: x_return_status := OKC_API.G_RET_STS_ERROR;
357: OKC_API.set_message( p_app_name => G_APP_NAME,
358: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
359:
360: RAISE G_EXCEPTION_HALT_VALIDATION;
361: END IF;

Line 534: x_return_status := OKC_API.G_RET_STS_ERROR;

530:
531: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
532:
533: -- Message Text: Error creating receipt in AR
534: x_return_status := OKC_API.G_RET_STS_ERROR;
535: OKC_API.set_message( p_app_name => G_APP_NAME,
536: p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
537: RAISE G_EXCEPTION_HALT_VALIDATION;
538:

Line 535: OKC_API.set_message( p_app_name => G_APP_NAME,

531: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
532:
533: -- Message Text: Error creating receipt in AR
534: x_return_status := OKC_API.G_RET_STS_ERROR;
535: OKC_API.set_message( p_app_name => G_APP_NAME,
536: p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
537: RAISE G_EXCEPTION_HALT_VALIDATION;
538:
539: END IF;

Line 612: x_return_status := OKC_API.HANDLE_EXCEPTIONS

608:
609: EXCEPTION
610:
611: WHEN G_EXCEPTION_HALT_VALIDATION THEN
612: x_return_status := OKC_API.HANDLE_EXCEPTIONS
613: (
614: l_api_name,
615: G_PKG_NAME,
616: 'OKC_API.G_RET_STS_ERROR',

Line 616: 'OKC_API.G_RET_STS_ERROR',

612: x_return_status := OKC_API.HANDLE_EXCEPTIONS
613: (
614: l_api_name,
615: G_PKG_NAME,
616: 'OKC_API.G_RET_STS_ERROR',
617: x_msg_count,
618: x_msg_data,
619: '_PVT'
620: );

Line 623: WHEN OKC_API.G_EXCEPTION_ERROR THEN

619: '_PVT'
620: );
621:
622:
623: WHEN OKC_API.G_EXCEPTION_ERROR THEN
624: x_return_status := OKC_API.HANDLE_EXCEPTIONS
625: (
626: l_api_name,
627: G_PKG_NAME,

Line 624: x_return_status := OKC_API.HANDLE_EXCEPTIONS

620: );
621:
622:
623: WHEN OKC_API.G_EXCEPTION_ERROR THEN
624: x_return_status := OKC_API.HANDLE_EXCEPTIONS
625: (
626: l_api_name,
627: G_PKG_NAME,
628: 'OKC_API.G_EXCEPTION_ERROR',

Line 628: 'OKC_API.G_EXCEPTION_ERROR',

624: x_return_status := OKC_API.HANDLE_EXCEPTIONS
625: (
626: l_api_name,
627: G_PKG_NAME,
628: 'OKC_API.G_EXCEPTION_ERROR',
629: x_msg_count,
630: x_msg_data,
631: '_PVT'
632: );

Line 635: x_return_status := OKC_API.HANDLE_EXCEPTIONS

631: '_PVT'
632: );
633:
634: WHEN OTHERS THEN
635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,
639: 'OKC_API.G_OTHERS',

Line 639: 'OKC_API.G_OTHERS',

635: x_return_status := OKC_API.HANDLE_EXCEPTIONS
636: (
637: l_api_name,
638: G_PKG_NAME,
639: 'OKC_API.G_OTHERS',
640: x_msg_count,
641: x_msg_data,
642: '_PVT'
643: );