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_FUNDING_PVT dependencies on STANDARD

Line 276: -- sjalasut, modified invoice_type from G_STANDARD to G_CREDIT

272: l_tapv_rec.DATE_GL := sysdate;
273: l_tapv_rec.ASSET_TAP_ID := r_khr.tap_id;
274: -- l_tapv_rec.VENDOR_ID := r_khr.vendor_id;
275:
276: -- sjalasut, modified invoice_type from G_STANDARD to G_CREDIT
277: -- changes made as part of OKLR12B disbursements project
278: l_tapv_rec.INVOICE_TYPE := G_CREDIT;
279:
280: create_funding_header(

Line 3902: p_tapv_rec.INVOICE_TYPE := G_STANDARD;

3898:
3899: IF (p_tapv_rec.INVOICE_TYPE is null or
3900: p_tapv_rec.INVOICE_TYPE = OKL_API.G_MISS_CHAR) THEN
3901:
3902: p_tapv_rec.INVOICE_TYPE := G_STANDARD;
3903:
3904: END IF;
3905: --start:| 06-Aug-08 cklee Fixed bug: 6860777 |
3906: /* system shall not convert wrong data to correct data, instead, display error and request user

Line 3908: -- 8. If invoice type is G_STANDARD then invoice amount is positive

3904: END IF;
3905: --start:| 06-Aug-08 cklee Fixed bug: 6860777 |
3906: /* system shall not convert wrong data to correct data, instead, display error and request user
3907: to fix before proceed.
3908: -- 8. If invoice type is G_STANDARD then invoice amount is positive
3909: -- If invoice type is G_CREDIT then the invoice amount is negative.
3910: -- sjalasut, made changes to incorporate the business rule as part
3911: -- of OKLR12B Disbursements Project
3912: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)

Line 3912: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)

3908: -- 8. If invoice type is G_STANDARD then invoice amount is positive
3909: -- If invoice type is G_CREDIT then the invoice amount is negative.
3910: -- sjalasut, made changes to incorporate the business rule as part
3911: -- of OKLR12B Disbursements Project
3912: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)
3913: OR(p_tapv_rec.INVOICE_TYPE = G_CREDIT AND p_tapv_rec.AMOUNT > 0))THEN
3914: p_tapv_rec.AMOUNT := ((p_tapv_rec.AMOUNT) * (-1));
3915: END IF;
3916: */

Line 4479: p_tapv_rec.invoice_type <> G_STANDARD) THEN

4475: */
4476: IF (p_tapv_rec.funding_type_code in (G_SUPPLIER_RETENTION_TYPE_CODE, G_ASSET_SUBSIDY) and
4477: p_tapv_rec.invoice_type <> G_CREDIT) OR
4478: (p_tapv_rec.funding_type_code in (G_EXPENSE, G_ASSET_TYPE_CODE, G_BORROWER_PAYMENT_TYPE_CODE) and
4479: p_tapv_rec.invoice_type <> G_STANDARD) THEN
4480: --start: cklee 3/01/07 added invoice type and amount sign check at line level
4481:
4482: open c_funding_type(p_tapv_rec.funding_type_code);
4483: fetch c_funding_type into l_funding_type;

Line 4518: -- that when the invoice_type is STANDARD, the invoice amount should be

4514:
4515: -------------------------------------------------------------------------
4516: -- validate_invoice_type_and_sign
4517: -- sjalasut, added this function to implement new business validation
4518: -- that when the invoice_type is STANDARD, the invoice amount should be
4519: -- positive and when the invoice_type is CREDIT, invoice amount should be
4520: -- negative.
4521: -------------------------------------------------------------------------
4522: FUNCTION validate_invoice_type_and_sign(p_tapv_rec IN tapv_rec_type

Line 4526: -- If invoice type is G_STANDARD then invoice amount is positive

4522: FUNCTION validate_invoice_type_and_sign(p_tapv_rec IN tapv_rec_type
4523: ) RETURN VARCHAR2 IS
4524: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4525: BEGIN
4526: -- If invoice type is G_STANDARD then invoice amount is positive
4527: -- If invoice type is G_CREDIT then the invoice amount is negative.
4528: -- sjalasut, made changes to incorporate the business rule as part
4529: -- of OKLR12B Disbursements Project
4530:

Line 4536: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)

4532: -- wrong data.
4533: IF p_tapv_rec.trx_status_code = 'ENTERED' THEN
4534: --end: cklee 03/01/07 added the following condition, somehow UI has passed
4535: -- wrong data.
4536: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)
4537: OR(p_tapv_rec.INVOICE_TYPE = G_CREDIT AND p_tapv_rec.AMOUNT > 0))THEN
4538: OKL_API.set_message(
4539: p_app_name => G_APP_NAME
4540: ,p_msg_name => 'OKL_LLA_INV_TYPE_AND_SIGN'

Line 4807: -- If invoice type is G_STANDARD then invoice amount is positive

4803: p_token1_value => 'Amount');
4804: RAISE G_EXCEPTION_HALT_VALIDATION;
4805: END IF;
4806: --start: cklee 3/01/07 added invoice type and amount sign check at line level
4807: -- If invoice type is G_STANDARD then invoice amount is positive
4808: -- If invoice type is G_CREDIT then the invoice amount is negative.
4809: -- cklee, made changes to incorporate the business rule as part
4810: -- of OKLR12B Disbursements Project
4811: open c_invoice_type(p_tplv_rec.tap_id);

Line 4815: IF((l_invoice_type = G_STANDARD AND p_tplv_rec.AMOUNT < 0)

4811: open c_invoice_type(p_tplv_rec.tap_id);
4812: fetch c_invoice_type into l_invoice_type;
4813: close c_invoice_type;
4814:
4815: IF((l_invoice_type = G_STANDARD AND p_tplv_rec.AMOUNT < 0)
4816: OR(l_invoice_type = G_CREDIT AND p_tplv_rec.AMOUNT > 0))THEN
4817: OKL_API.set_message(
4818: p_app_name => G_APP_NAME
4819: ,p_msg_name => 'OKL_LLA_INV_TYPE_AND_SIGN'

Line 7055: -- sjalasut, modified the invoice_type from G_STANDARD to G_CREDIT

7051: l_tapv_rec.CURRENCY_CODE := l_currency_code;
7052: l_tapv_rec.PAYMENT_METHOD_CODE := 'CHECK';
7053: l_tapv_rec.DATE_ENTERED := sysdate;
7054:
7055: -- sjalasut, modified the invoice_type from G_STANDARD to G_CREDIT
7056: -- changes made as part of OKLR12B Disbursements Project
7057: l_tapv_rec.INVOICE_TYPE := G_CREDIT;
7058:
7059: -- sjalasut, added code to make sure that the invoice amount on the credit memo