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_CASH_APPL_RULES dependencies on OKC_API

Line 49: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

45: -- PROCEDURE handle_manual_pay
46: ---------------------------------------------------------------------------
47:
48: PROCEDURE handle_manual_pay ( p_api_version IN NUMBER
49: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
50: ,x_return_status OUT NOCOPY VARCHAR2
51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL

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

171: l_cons_bill_applic VARCHAR2(1) DEFAULT 'N';
172:
173:
174: l_api_version NUMBER := 1.0;
175: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
176: l_return_status VARCHAR2(1);
177: l_msg_count NUMBER;
178: l_msg_data VARCHAR2(2000);
179:

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

485: l_currency_code okl_k_headers_full_v.currency_code%type;
486: --end code by pgomes on 03/05/2003
487: BEGIN
488:
489: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
490: G_PKG_NAME,
491: p_init_msg_list,
492: l_api_version,
493: p_api_version,

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

493: p_api_version,
494: '_PVT',
495: l_return_status);
496:
497: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
500: RAISE OKC_API.G_EXCEPTION_ERROR;
501: END IF;

Line 498: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

494: '_PVT',
495: l_return_status);
496:
497: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
500: RAISE OKC_API.G_EXCEPTION_ERROR;
501: END IF;
502:

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

495: l_return_status);
496:
497: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
500: RAISE OKC_API.G_EXCEPTION_ERROR;
501: END IF;
502:
503: l_functional_currency := okl_accounting_util.get_func_curr_code;

Line 500: RAISE OKC_API.G_EXCEPTION_ERROR;

496:
497: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
499: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
500: RAISE OKC_API.G_EXCEPTION_ERROR;
501: END IF;
502:
503: l_functional_currency := okl_accounting_util.get_func_curr_code;
504:

Line 518: x_return_status := OKC_API.G_RET_STS_ERROR;

514: l_rcpt_date = '' OR
515: l_rcpt_amount = '0' THEN
516:
517: -- Message Text: Please enter all mandatory fields
518: x_return_status := OKC_API.G_RET_STS_ERROR;
519: OKC_API.set_message( p_app_name => G_APP_NAME,
520: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
521:
522: RAISE G_EXCEPTION_HALT_VALIDATION;

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

515: l_rcpt_amount = '0' THEN
516:
517: -- Message Text: Please enter all mandatory fields
518: x_return_status := OKC_API.G_RET_STS_ERROR;
519: OKC_API.set_message( p_app_name => G_APP_NAME,
520: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
521:
522: RAISE G_EXCEPTION_HALT_VALIDATION;
523:

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

529: FETCH l_khr_curr_csr INTO l_currency_code;
530: CLOSE l_khr_curr_csr;
531:
532: IF (l_currency_code <> p_currency_code) THEN
533: OKC_API.set_message( p_app_name => G_APP_NAME,
534: p_msg_name =>'OKL_BPD_RCPT_KHR_CURR_ERROR');
535:
536: RAISE G_EXCEPTION_HALT_VALIDATION;
537: END IF;

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

540: FETCH l_inv_curr_csr INTO l_currency_code;
541: CLOSE l_inv_curr_csr;
542:
543: IF (l_currency_code <> p_currency_code) THEN
544: OKC_API.set_message( p_app_name => G_APP_NAME,
545: p_msg_name =>'OKL_BPD_RCPT_INV_CURR_ERROR');
546:
547: RAISE G_EXCEPTION_HALT_VALIDATION;
548: END IF;

Line 601: x_return_status := OKC_API.G_RET_STS_ERROR;

597: l_currency_conv_type IN ('NONE') THEN
598:
599:
600: -- Message Text: Please enter a currency type.
601: x_return_status := OKC_API.G_RET_STS_ERROR;
602: OKC_API.set_message( p_app_name => G_APP_NAME,
603: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
604:
605: RAISE G_EXCEPTION_HALT_VALIDATION;

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

598:
599:
600: -- Message Text: Please enter a currency type.
601: x_return_status := OKC_API.G_RET_STS_ERROR;
602: OKC_API.set_message( p_app_name => G_APP_NAME,
603: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
604:
605: RAISE G_EXCEPTION_HALT_VALIDATION;
606:

Line 616: x_return_status := OKC_API.G_RET_STS_ERROR;

612: IF l_currency_conv_type IN ('CORPORATE', 'SPOT', 'USER') OR
613: l_currency_conv_rate <> '0' THEN
614:
615: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
616: x_return_status := OKC_API.G_RET_STS_ERROR;
617: OKC_API.set_message( p_app_name => G_APP_NAME,
618: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
619:
620: RAISE G_EXCEPTION_HALT_VALIDATION;

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

613: l_currency_conv_rate <> '0' THEN
614:
615: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
616: x_return_status := OKC_API.G_RET_STS_ERROR;
617: OKC_API.set_message( p_app_name => G_APP_NAME,
618: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
619:
620: RAISE G_EXCEPTION_HALT_VALIDATION;
621:

Line 659: x_return_status := OKC_API.G_RET_STS_ERROR;

655:
656: IF l_functional_conversion_rate IN (0,-1) THEN
657:
658: -- Message Text: No exchange rate defined
659: x_return_status := OKC_API.G_RET_STS_ERROR;
660: OKC_API.set_message( p_app_name => G_APP_NAME,
661: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
662:
663: RAISE G_EXCEPTION_HALT_VALIDATION;

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

656: IF l_functional_conversion_rate IN (0,-1) THEN
657:
658: -- Message Text: No exchange rate defined
659: x_return_status := OKC_API.G_RET_STS_ERROR;
660: OKC_API.set_message( p_app_name => G_APP_NAME,
661: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
662:
663: RAISE G_EXCEPTION_HALT_VALIDATION;
664:

Line 676: x_return_status := OKC_API.G_RET_STS_ERROR;

672:
673: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
674:
675: -- Message Text: No exchange rate defined for currency conversion type USER.
676: x_return_status := OKC_API.G_RET_STS_ERROR;
677: OKC_API.set_message( p_app_name => G_APP_NAME,
678: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
679:
680: RAISE G_EXCEPTION_HALT_VALIDATION;

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

673: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
674:
675: -- Message Text: No exchange rate defined for currency conversion type USER.
676: x_return_status := OKC_API.G_RET_STS_ERROR;
677: OKC_API.set_message( p_app_name => G_APP_NAME,
678: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
679:
680: RAISE G_EXCEPTION_HALT_VALIDATION;
681:

Line 713: x_return_status := OKC_API.G_RET_STS_ERROR;

709:
710: IF l_conversion_rate IN (0,-1) THEN
711:
712: -- Message Text: No exchange rate defined
713: x_return_status := OKC_API.G_RET_STS_ERROR;
714: OKC_API.set_message( p_app_name => G_APP_NAME,
715: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
716:
717: RAISE G_EXCEPTION_HALT_VALIDATION;

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

710: IF l_conversion_rate IN (0,-1) THEN
711:
712: -- Message Text: No exchange rate defined
713: x_return_status := OKC_API.G_RET_STS_ERROR;
714: OKC_API.set_message( p_app_name => G_APP_NAME,
715: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
716:
717: RAISE G_EXCEPTION_HALT_VALIDATION;
718:

Line 732: x_return_status := OKC_API.G_RET_STS_ERROR;

728:
729: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
730:
731: -- Message Text: The receipt cannot have a value of zero
732: x_return_status := OKC_API.G_RET_STS_ERROR;
733: OKC_API.set_message( p_app_name => G_APP_NAME,
734: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
735:
736: RAISE G_EXCEPTION_HALT_VALIDATION;

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

729: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
730:
731: -- Message Text: The receipt cannot have a value of zero
732: x_return_status := OKC_API.G_RET_STS_ERROR;
733: OKC_API.set_message( p_app_name => G_APP_NAME,
734: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
735:
736: RAISE G_EXCEPTION_HALT_VALIDATION;
737:

Line 741: x_return_status := OKC_API.G_RET_STS_ERROR;

737:
738: ELSIF l_inv_tot = 0 OR l_inv_tot IS NULL THEN
739:
740: -- Message Text: The invoice has an amount of zero
741: x_return_status := OKC_API.G_RET_STS_ERROR;
742: OKC_API.set_message( p_app_name => G_APP_NAME,
743: p_msg_name => 'OKL_BPD_ZERO_INVOICE');
744:
745: RAISE G_EXCEPTION_HALT_VALIDATION;

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

738: ELSIF l_inv_tot = 0 OR l_inv_tot IS NULL THEN
739:
740: -- Message Text: The invoice has an amount of zero
741: x_return_status := OKC_API.G_RET_STS_ERROR;
742: OKC_API.set_message( p_app_name => G_APP_NAME,
743: p_msg_name => 'OKL_BPD_ZERO_INVOICE');
744:
745: RAISE G_EXCEPTION_HALT_VALIDATION;
746:

Line 752: x_return_status := OKC_API.G_RET_STS_ERROR;

748: ELSIF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
749: OR l_dflt_over_payment IS NULL OR l_dflt_receipt_msmtch IS NULL THEN
750:
751: -- Message Text: No DEFAULT cash application rule defined
752: x_return_status := OKC_API.G_RET_STS_ERROR;
753: OKC_API.set_message( p_app_name => G_APP_NAME,
754: p_msg_name => 'OKL_BPD_NO_CSH_RLS_DEF');
755:
756: RAISE G_EXCEPTION_HALT_VALIDATION;

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

749: OR l_dflt_over_payment IS NULL OR l_dflt_receipt_msmtch IS NULL THEN
750:
751: -- Message Text: No DEFAULT cash application rule defined
752: x_return_status := OKC_API.G_RET_STS_ERROR;
753: OKC_API.set_message( p_app_name => G_APP_NAME,
754: p_msg_name => 'OKL_BPD_NO_CSH_RLS_DEF');
755:
756: RAISE G_EXCEPTION_HALT_VALIDATION;
757:

Line 762: x_return_status := OKC_API.G_RET_STS_ERROR;

758: ELSIF l_rcpt_amount >= l_inv_tot AND
759: l_create_receipt_flag = 'N' THEN -- allocate receipt
760:
761: -- Message Text: No cash allocation required
762: x_return_status := OKC_API.G_RET_STS_ERROR;
763: OKC_API.set_message( p_app_name => G_APP_NAME,
764: p_msg_name => 'OKL_BPD_NO_ALLOC_REQ');
765:
766: RAISE G_EXCEPTION_HALT_VALIDATION;

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

759: l_create_receipt_flag = 'N' THEN -- allocate receipt
760:
761: -- Message Text: No cash allocation required
762: x_return_status := OKC_API.G_RET_STS_ERROR;
763: OKC_API.set_message( p_app_name => G_APP_NAME,
764: p_msg_name => 'OKL_BPD_NO_ALLOC_REQ');
765:
766: RAISE G_EXCEPTION_HALT_VALIDATION;
767:

Line 783: x_return_status := OKC_API.G_RET_STS_ERROR;

779:
780: IF l_dup_rcpt_flag = 1 THEN
781:
782: -- Message Text: Duplicate receipt number for customer
783: x_return_status := OKC_API.G_RET_STS_ERROR;
784: OKC_API.set_message( p_app_name => G_APP_NAME,
785: p_msg_name => 'OKL_BPD_DUP_RECEIPT');
786:
787: RAISE G_EXCEPTION_HALT_VALIDATION;

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

780: IF l_dup_rcpt_flag = 1 THEN
781:
782: -- Message Text: Duplicate receipt number for customer
783: x_return_status := OKC_API.G_RET_STS_ERROR;
784: OKC_API.set_message( p_app_name => G_APP_NAME,
785: p_msg_name => 'OKL_BPD_DUP_RECEIPT');
786:
787: RAISE G_EXCEPTION_HALT_VALIDATION;
788:

Line 1017: x_return_status := OKC_API.G_RET_STS_ERROR;

1013:
1014: IF l_order_count = 0 THEN
1015:
1016: -- Message Text: No order transaction types for contract
1017: x_return_status := OKC_API.G_RET_STS_ERROR;
1018:
1019: OKC_API.set_message( p_app_name => G_APP_NAME
1020: ,p_msg_name => 'OKL_BPD_NO_ORDER_STRMS'
1021: ,p_token1 => 'RULE_NAME'

Line 1019: OKC_API.set_message( p_app_name => G_APP_NAME

1015:
1016: -- Message Text: No order transaction types for contract
1017: x_return_status := OKC_API.G_RET_STS_ERROR;
1018:
1019: OKC_API.set_message( p_app_name => G_APP_NAME
1020: ,p_msg_name => 'OKL_BPD_NO_ORDER_STRMS'
1021: ,p_token1 => 'RULE_NAME'
1022: ,p_token1_value => l_rule_name
1023: ,p_token2 => 'CONTRACT_NUMBER'

Line 1073: x_return_status := OKC_API.G_RET_STS_ERROR;

1069:
1070: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
1071:
1072: -- Message Text: No prorated transaction types for contract
1073: x_return_status := OKC_API.G_RET_STS_ERROR;
1074: OKC_API.set_message( p_app_name => G_APP_NAME
1075: ,p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS'
1076: ,p_token1 => 'RULE_NAME'
1077: ,p_token1_value => l_rule_name

Line 1074: OKC_API.set_message( p_app_name => G_APP_NAME

1070: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
1071:
1072: -- Message Text: No prorated transaction types for contract
1073: x_return_status := OKC_API.G_RET_STS_ERROR;
1074: OKC_API.set_message( p_app_name => G_APP_NAME
1075: ,p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS'
1076: ,p_token1 => 'RULE_NAME'
1077: ,p_token1_value => l_rule_name
1078: ,p_token2 => 'CONTRACT_NUMBER'

Line 1344: x_return_status := OKC_API.G_RET_STS_ERROR;

1340:
1341: IF l_order_count = 0 THEN
1342:
1343: -- Message Text: No prorated transaction types for rule.
1344: x_return_status := OKC_API.G_RET_STS_ERROR;
1345:
1346: OKC_API.set_message( p_app_name => G_APP_NAME
1347: ,p_msg_name => 'OKL_BPD_DEF_NO_ORD'
1348: );

Line 1346: OKC_API.set_message( p_app_name => G_APP_NAME

1342:
1343: -- Message Text: No prorated transaction types for rule.
1344: x_return_status := OKC_API.G_RET_STS_ERROR;
1345:
1346: OKC_API.set_message( p_app_name => G_APP_NAME
1347: ,p_msg_name => 'OKL_BPD_DEF_NO_ORD'
1348: );
1349:
1350: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1403: x_return_status := OKC_API.G_RET_STS_ERROR;

1399:
1400: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
1401:
1402: -- Message Text: No prorated transaction types for contract.
1403: x_return_status := OKC_API.G_RET_STS_ERROR;
1404:
1405: OKC_API.set_message( p_app_name => G_APP_NAME
1406: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
1407: );

Line 1405: OKC_API.set_message( p_app_name => G_APP_NAME

1401:
1402: -- Message Text: No prorated transaction types for contract.
1403: x_return_status := OKC_API.G_RET_STS_ERROR;
1404:
1405: OKC_API.set_message( p_app_name => G_APP_NAME
1406: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
1407: );
1408:
1409: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1433: x_return_status := OKC_API.G_RET_STS_ERROR;

1429: END LOOP;
1430:
1431: ELSE -- added by BV
1432: -- Message Text: No prorated transaction types for contract
1433: x_return_status := OKC_API.G_RET_STS_ERROR;
1434:
1435: OKC_API.set_message( p_app_name => G_APP_NAME
1436: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
1437: );

Line 1435: OKC_API.set_message( p_app_name => G_APP_NAME

1431: ELSE -- added by BV
1432: -- Message Text: No prorated transaction types for contract
1433: x_return_status := OKC_API.G_RET_STS_ERROR;
1434:
1435: OKC_API.set_message( p_app_name => G_APP_NAME
1436: ,p_msg_name => 'OKL_BPD_DEF_NO_PRO'
1437: );
1438:
1439: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1668: x_return_status := OKC_API.G_RET_STS_ERROR;

1664:
1665: IF l_order_count = 0 THEN
1666:
1667: -- Message Text: No prorated transaction types for contract.
1668: x_return_status := OKC_API.G_RET_STS_ERROR;
1669:
1670: OKC_API.set_message( p_app_name => G_APP_NAME
1671: ,p_msg_name => 'OKL_BPD_NO_ORDER_STRMS'
1672: ,p_token1 => 'RULE_NAME'

Line 1670: OKC_API.set_message( p_app_name => G_APP_NAME

1666:
1667: -- Message Text: No prorated transaction types for contract.
1668: x_return_status := OKC_API.G_RET_STS_ERROR;
1669:
1670: OKC_API.set_message( p_app_name => G_APP_NAME
1671: ,p_msg_name => 'OKL_BPD_NO_ORDER_STRMS'
1672: ,p_token1 => 'RULE_NAME'
1673: ,p_token1_value => l_rule_name
1674: ,p_token2 => 'CONTRACT_NUMBER'

Line 1732: x_return_status := OKC_API.G_RET_STS_ERROR;

1728:
1729: IF l_pro_rate_inv_total IS NULL OR l_pro_rate_inv_total = 0 THEN
1730:
1731: -- Message Text: No prorated transaction types for contract.
1732: x_return_status := OKC_API.G_RET_STS_ERROR;
1733:
1734: OKC_API.set_message( p_app_name => G_APP_NAME
1735: ,p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS'
1736: ,p_token1 => 'RULE_NAME'

Line 1734: OKC_API.set_message( p_app_name => G_APP_NAME

1730:
1731: -- Message Text: No prorated transaction types for contract.
1732: x_return_status := OKC_API.G_RET_STS_ERROR;
1733:
1734: OKC_API.set_message( p_app_name => G_APP_NAME
1735: ,p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS'
1736: ,p_token1 => 'RULE_NAME'
1737: ,p_token1_value => l_rule_name
1738: ,p_token2 => 'CONTRACT_NUMBER'

Line 1766: x_return_status := OKC_API.G_RET_STS_ERROR;

1762: END LOOP;
1763:
1764: ELSE -- added by BV
1765: -- Message Text: No prorated transaction types for contract
1766: x_return_status := OKC_API.G_RET_STS_ERROR;
1767:
1768: OKC_API.set_message( p_app_name => G_APP_NAME
1769: ,p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS'
1770: ,p_token1 => 'RULE_NAME'

Line 1768: OKC_API.set_message( p_app_name => G_APP_NAME

1764: ELSE -- added by BV
1765: -- Message Text: No prorated transaction types for contract
1766: x_return_status := OKC_API.G_RET_STS_ERROR;
1767:
1768: OKC_API.set_message( p_app_name => G_APP_NAME
1769: ,p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS'
1770: ,p_token1 => 'RULE_NAME'
1771: ,p_token1_value => l_rule_name
1772: ,p_token2 => 'CONTRACT_NUMBER'

Line 2109: x_return_status := OKC_API.G_RET_STS_ERROR;

2105:
2106: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2107:
2108: -- Message Text: Error creating receipt in AR
2109: x_return_status := OKC_API.G_RET_STS_ERROR;
2110: OKC_API.set_message( p_app_name => G_APP_NAME,
2111: p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
2112:
2113: RAISE G_EXCEPTION_HALT_VALIDATION;

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

2106: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2107:
2108: -- Message Text: Error creating receipt in AR
2109: x_return_status := OKC_API.G_RET_STS_ERROR;
2110: OKC_API.set_message( p_app_name => G_APP_NAME,
2111: p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
2112:
2113: RAISE G_EXCEPTION_HALT_VALIDATION;
2114:

Line 2169: x_return_status := OKC_API.G_RET_STS_ERROR;

2165:
2166: EXCEPTION
2167:
2168: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2169: x_return_status := OKC_API.G_RET_STS_ERROR;
2170:
2171:
2172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2173: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2172: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2168: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2169: x_return_status := OKC_API.G_RET_STS_ERROR;
2170:
2171:
2172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2174: (
2175: l_api_name,
2176: G_PKG_NAME,

Line 2173: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2169: x_return_status := OKC_API.G_RET_STS_ERROR;
2170:
2171:
2172: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2174: (
2175: l_api_name,
2176: G_PKG_NAME,
2177: 'OKC_API.G_RET_STS_ERROR',

Line 2177: 'OKC_API.G_RET_STS_ERROR',

2173: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2174: (
2175: l_api_name,
2176: G_PKG_NAME,
2177: 'OKC_API.G_RET_STS_ERROR',
2178: x_msg_count,
2179: x_msg_data,
2180: '_PVT'
2181: );

Line 2195: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

2191:
2192: END handle_manual_pay;
2193:
2194: PROCEDURE create_manual_receipt ( p_api_version IN NUMBER
2195: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2196: ,x_return_status OUT NOCOPY VARCHAR2
2197: ,x_msg_count OUT NOCOPY NUMBER
2198: ,x_msg_data OUT NOCOPY VARCHAR2
2199: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL

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

2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;
2225: l_dup_rcpt_flag NUMBER DEFAULT NULL;
2226: l_api_version NUMBER := 1.0;
2227: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
2228: l_return_status VARCHAR2(1);
2229: l_msg_count NUMBER;
2230: l_msg_data VARCHAR2(2000);
2231: l_api_name CONSTANT VARCHAR2(30) := 'create_manual_receipt';

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

2246: AND receipt_number = cp_check_num
2247: AND TRUNC(RECEIPT_DATE) = TRUNC(cp_receipt_date);
2248:
2249: BEGIN
2250: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2251: G_PKG_NAME,
2252: p_init_msg_list,
2253: l_api_version,
2254: p_api_version,

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

2253: l_api_version,
2254: p_api_version,
2255: '_PVT',
2256: l_return_status);
2257: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2260: RAISE OKC_API.G_EXCEPTION_ERROR;
2261: END IF;

Line 2258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2254: p_api_version,
2255: '_PVT',
2256: l_return_status);
2257: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2260: RAISE OKC_API.G_EXCEPTION_ERROR;
2261: END IF;
2262: l_functional_currency := okl_accounting_util.get_func_curr_code;

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

2255: '_PVT',
2256: l_return_status);
2257: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2260: RAISE OKC_API.G_EXCEPTION_ERROR;
2261: END IF;
2262: l_functional_currency := okl_accounting_util.get_func_curr_code;
2263:

Line 2260: RAISE OKC_API.G_EXCEPTION_ERROR;

2256: l_return_status);
2257: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2260: RAISE OKC_API.G_EXCEPTION_ERROR;
2261: END IF;
2262: l_functional_currency := okl_accounting_util.get_func_curr_code;
2263:
2264: -- check for mandatory fields

Line 2267: l_customer_id = OKC_API.G_MISS_NUM OR

2263:
2264: -- check for mandatory fields
2265:
2266: IF l_customer_id IS NULL OR
2267: l_customer_id = OKC_API.G_MISS_NUM OR
2268: l_receipt_currency_code IS NULL OR
2269: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
2270: l_irm_id IS NULL OR
2271: l_irm_id = OKC_API.G_MISS_NUM OR

Line 2269: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR

2265:
2266: IF l_customer_id IS NULL OR
2267: l_customer_id = OKC_API.G_MISS_NUM OR
2268: l_receipt_currency_code IS NULL OR
2269: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
2270: l_irm_id IS NULL OR
2271: l_irm_id = OKC_API.G_MISS_NUM OR
2272: l_rcpt_date IS NULL OR
2273: l_rcpt_date = OKC_API.G_MISS_DATE OR

Line 2271: l_irm_id = OKC_API.G_MISS_NUM OR

2267: l_customer_id = OKC_API.G_MISS_NUM OR
2268: l_receipt_currency_code IS NULL OR
2269: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
2270: l_irm_id IS NULL OR
2271: l_irm_id = OKC_API.G_MISS_NUM OR
2272: l_rcpt_date IS NULL OR
2273: l_rcpt_date = OKC_API.G_MISS_DATE OR
2274: l_gl_date IS NULL OR
2275: l_gl_date = OKC_API.G_MISS_DATE OR

Line 2273: l_rcpt_date = OKC_API.G_MISS_DATE OR

2269: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
2270: l_irm_id IS NULL OR
2271: l_irm_id = OKC_API.G_MISS_NUM OR
2272: l_rcpt_date IS NULL OR
2273: l_rcpt_date = OKC_API.G_MISS_DATE OR
2274: l_gl_date IS NULL OR
2275: l_gl_date = OKC_API.G_MISS_DATE OR
2276: l_org_id IS NULL OR
2277: l_org_id = OKC_API.G_MISS_NUM OR

Line 2275: l_gl_date = OKC_API.G_MISS_DATE OR

2271: l_irm_id = OKC_API.G_MISS_NUM OR
2272: l_rcpt_date IS NULL OR
2273: l_rcpt_date = OKC_API.G_MISS_DATE OR
2274: l_gl_date IS NULL OR
2275: l_gl_date = OKC_API.G_MISS_DATE OR
2276: l_org_id IS NULL OR
2277: l_org_id = OKC_API.G_MISS_NUM OR
2278: l_rcpt_amount = 0 OR
2279: l_rcpt_amount = OKC_API.G_MISS_NUM OR

Line 2277: l_org_id = OKC_API.G_MISS_NUM OR

2273: l_rcpt_date = OKC_API.G_MISS_DATE OR
2274: l_gl_date IS NULL OR
2275: l_gl_date = OKC_API.G_MISS_DATE OR
2276: l_org_id IS NULL OR
2277: l_org_id = OKC_API.G_MISS_NUM OR
2278: l_rcpt_amount = 0 OR
2279: l_rcpt_amount = OKC_API.G_MISS_NUM OR
2280: l_rcpt_amount IS NULL THEN
2281:

Line 2279: l_rcpt_amount = OKC_API.G_MISS_NUM OR

2275: l_gl_date = OKC_API.G_MISS_DATE OR
2276: l_org_id IS NULL OR
2277: l_org_id = OKC_API.G_MISS_NUM OR
2278: l_rcpt_amount = 0 OR
2279: l_rcpt_amount = OKC_API.G_MISS_NUM OR
2280: l_rcpt_amount IS NULL THEN
2281:
2282: -- Message Text: Please enter all mandatory fields
2283: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 2283: x_return_status := OKC_API.G_RET_STS_ERROR;

2279: l_rcpt_amount = OKC_API.G_MISS_NUM OR
2280: l_rcpt_amount IS NULL THEN
2281:
2282: -- Message Text: Please enter all mandatory fields
2283: x_return_status := OKC_API.G_RET_STS_ERROR;
2284: OKC_API.set_message( p_app_name => G_APP_NAME,
2285: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
2286:
2287: RAISE G_EXCEPTION_HALT_VALIDATION;

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

2280: l_rcpt_amount IS NULL THEN
2281:
2282: -- Message Text: Please enter all mandatory fields
2283: x_return_status := OKC_API.G_RET_STS_ERROR;
2284: OKC_API.set_message( p_app_name => G_APP_NAME,
2285: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
2286:
2287: RAISE G_EXCEPTION_HALT_VALIDATION;
2288:

Line 2295: x_return_status := OKC_API.G_RET_STS_ERROR;

2291:
2292: IF l_functional_currency <> l_receipt_currency_code AND
2293: l_currency_conv_type IN ('NONE') THEN
2294: -- Message Text: Please enter a currency type.
2295: x_return_status := OKC_API.G_RET_STS_ERROR;
2296: OKC_API.set_message( p_app_name => G_APP_NAME,
2297: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
2298: RAISE G_EXCEPTION_HALT_VALIDATION;
2299: END IF;

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

2292: IF l_functional_currency <> l_receipt_currency_code AND
2293: l_currency_conv_type IN ('NONE') THEN
2294: -- Message Text: Please enter a currency type.
2295: x_return_status := OKC_API.G_RET_STS_ERROR;
2296: OKC_API.set_message( p_app_name => G_APP_NAME,
2297: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
2298: RAISE G_EXCEPTION_HALT_VALIDATION;
2299: END IF;
2300: IF l_functional_currency = l_receipt_currency_code THEN

Line 2304: x_return_status := OKC_API.G_RET_STS_ERROR;

2300: IF l_functional_currency = l_receipt_currency_code THEN
2301: IF l_currency_conv_type IN ('CORPORATE', 'SPOT', 'USER') OR
2302: l_currency_conv_rate <> '0' THEN
2303: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
2304: x_return_status := OKC_API.G_RET_STS_ERROR;
2305: OKC_API.set_message( p_app_name => G_APP_NAME,
2306: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
2307: RAISE G_EXCEPTION_HALT_VALIDATION;
2308: END IF;

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

2301: IF l_currency_conv_type IN ('CORPORATE', 'SPOT', 'USER') OR
2302: l_currency_conv_rate <> '0' THEN
2303: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
2304: x_return_status := OKC_API.G_RET_STS_ERROR;
2305: OKC_API.set_message( p_app_name => G_APP_NAME,
2306: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
2307: RAISE G_EXCEPTION_HALT_VALIDATION;
2308: END IF;
2309: END IF;

Line 2335: x_return_status := OKC_API.G_RET_STS_ERROR;

2331: );
2332:
2333: IF l_functional_conversion_rate IN (0,-1) THEN
2334: --No exchange rate defined
2335: x_return_status := OKC_API.G_RET_STS_ERROR;
2336: OKC_API.set_message( p_app_name => G_APP_NAME,
2337: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2338: RAISE G_EXCEPTION_HALT_VALIDATION;
2339: END IF;

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

2332:
2333: IF l_functional_conversion_rate IN (0,-1) THEN
2334: --No exchange rate defined
2335: x_return_status := OKC_API.G_RET_STS_ERROR;
2336: OKC_API.set_message( p_app_name => G_APP_NAME,
2337: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2338: RAISE G_EXCEPTION_HALT_VALIDATION;
2339: END IF;
2340:

Line 2347: x_return_status := OKC_API.G_RET_STS_ERROR;

2343: ELSIF l_functional_currency <> l_receipt_currency_code AND
2344: l_currency_conv_type IN ('USER') THEN
2345: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
2346: -- Message Text: No exchange rate defined for currency conversion type USER.
2347: x_return_status := OKC_API.G_RET_STS_ERROR;
2348: OKC_API.set_message( p_app_name => G_APP_NAME,
2349: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
2350: RAISE G_EXCEPTION_HALT_VALIDATION;
2351: ELSE

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

2344: l_currency_conv_type IN ('USER') THEN
2345: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
2346: -- Message Text: No exchange rate defined for currency conversion type USER.
2347: x_return_status := OKC_API.G_RET_STS_ERROR;
2348: OKC_API.set_message( p_app_name => G_APP_NAME,
2349: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
2350: RAISE G_EXCEPTION_HALT_VALIDATION;
2351: ELSE
2352: l_functional_conversion_rate := l_currency_conv_rate;

Line 2367: x_return_status := OKC_API.G_RET_STS_ERROR;

2363: END IF;
2364: -- Check for exceptions
2365: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
2366: -- Message Text: The receipt cannot have a value of zero
2367: x_return_status := OKC_API.G_RET_STS_ERROR;
2368: OKC_API.set_message( p_app_name => G_APP_NAME,
2369: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
2370: RAISE G_EXCEPTION_HALT_VALIDATION;
2371: END IF;

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

2364: -- Check for exceptions
2365: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
2366: -- Message Text: The receipt cannot have a value of zero
2367: x_return_status := OKC_API.G_RET_STS_ERROR;
2368: OKC_API.set_message( p_app_name => G_APP_NAME,
2369: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
2370: RAISE G_EXCEPTION_HALT_VALIDATION;
2371: END IF;
2372: OPEN c_dup_rcpt(l_customer_id, l_check_number, TRUNC(l_rcpt_date));

Line 2379: x_return_status := OKC_API.G_RET_STS_ERROR;

2375:
2376:
2377: IF l_dup_rcpt_flag = 1 THEN
2378: --Message Text: Duplicate receipt number for customer
2379: x_return_status := OKC_API.G_RET_STS_ERROR;
2380: OKC_API.set_message( p_app_name => G_APP_NAME,
2381: p_msg_name => 'OKL_BPD_DUP_RECEIPT');
2382:
2383: RAISE G_EXCEPTION_HALT_VALIDATION;

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

2376:
2377: IF l_dup_rcpt_flag = 1 THEN
2378: --Message Text: Duplicate receipt number for customer
2379: x_return_status := OKC_API.G_RET_STS_ERROR;
2380: OKC_API.set_message( p_app_name => G_APP_NAME,
2381: p_msg_name => 'OKL_BPD_DUP_RECEIPT');
2382:
2383: RAISE G_EXCEPTION_HALT_VALIDATION;
2384: END IF;

Line 2413: x_return_status := OKC_API.G_RET_STS_ERROR;

2409: x_return_status := l_return_status;
2410:
2411: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2412: -- Message Text: Error creating receipt in AR
2413: x_return_status := OKC_API.G_RET_STS_ERROR;
2414: OKC_API.set_message( p_app_name => G_APP_NAME,
2415: p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
2416: RAISE G_EXCEPTION_HALT_VALIDATION;
2417: END IF;

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

2410:
2411: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2412: -- Message Text: Error creating receipt in AR
2413: x_return_status := OKC_API.G_RET_STS_ERROR;
2414: OKC_API.set_message( p_app_name => G_APP_NAME,
2415: p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
2416: RAISE G_EXCEPTION_HALT_VALIDATION;
2417: END IF;
2418:

Line 2437: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2433: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2434: x_return_status := OKL_API.G_RET_STS_ERROR;
2435:
2436:
2437: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2438: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2439: (
2440: l_api_name,
2441: G_PKG_NAME,

Line 2442: 'OKC_API.G_RET_STS_ERROR',

2438: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2439: (
2440: l_api_name,
2441: G_PKG_NAME,
2442: 'OKC_API.G_RET_STS_ERROR',
2443: x_msg_count,
2444: x_msg_data,
2445: '_PVT'
2446: );