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 3772: p_tapv_rec.INVOICE_TYPE := G_STANDARD;

3768:
3769: IF (p_tapv_rec.INVOICE_TYPE is null or
3770: p_tapv_rec.INVOICE_TYPE = OKL_API.G_MISS_CHAR) THEN
3771:
3772: p_tapv_rec.INVOICE_TYPE := G_STANDARD;
3773:
3774: END IF;
3775: --start:| 06-Aug-08 cklee Fixed bug: 6860777 |
3776: /* system shall not convert wrong data to correct data, instead, display error and request user

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

3774: END IF;
3775: --start:| 06-Aug-08 cklee Fixed bug: 6860777 |
3776: /* system shall not convert wrong data to correct data, instead, display error and request user
3777: to fix before proceed.
3778: -- 8. If invoice type is G_STANDARD then invoice amount is positive
3779: -- If invoice type is G_CREDIT then the invoice amount is negative.
3780: -- sjalasut, made changes to incorporate the business rule as part
3781: -- of OKLR12B Disbursements Project
3782: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)

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

3778: -- 8. If invoice type is G_STANDARD then invoice amount is positive
3779: -- If invoice type is G_CREDIT then the invoice amount is negative.
3780: -- sjalasut, made changes to incorporate the business rule as part
3781: -- of OKLR12B Disbursements Project
3782: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)
3783: OR(p_tapv_rec.INVOICE_TYPE = G_CREDIT AND p_tapv_rec.AMOUNT > 0))THEN
3784: p_tapv_rec.AMOUNT := ((p_tapv_rec.AMOUNT) * (-1));
3785: END IF;
3786: */

Line 4343: p_tapv_rec.invoice_type <> G_STANDARD) THEN

4339: */
4340: IF (p_tapv_rec.funding_type_code in (G_SUPPLIER_RETENTION_TYPE_CODE, G_ASSET_SUBSIDY) and
4341: p_tapv_rec.invoice_type <> G_CREDIT) OR
4342: (p_tapv_rec.funding_type_code in (G_EXPENSE, G_ASSET_TYPE_CODE, G_BORROWER_PAYMENT_TYPE_CODE) and
4343: p_tapv_rec.invoice_type <> G_STANDARD) THEN
4344: --start: cklee 3/01/07 added invoice type and amount sign check at line level
4345:
4346: open c_funding_type(p_tapv_rec.funding_type_code);
4347: fetch c_funding_type into l_funding_type;

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

4378:
4379: -------------------------------------------------------------------------
4380: -- validate_invoice_type_and_sign
4381: -- sjalasut, added this function to implement new business validation
4382: -- that when the invoice_type is STANDARD, the invoice amount should be
4383: -- positive and when the invoice_type is CREDIT, invoice amount should be
4384: -- negative.
4385: -------------------------------------------------------------------------
4386: FUNCTION validate_invoice_type_and_sign(p_tapv_rec IN tapv_rec_type

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

4386: FUNCTION validate_invoice_type_and_sign(p_tapv_rec IN tapv_rec_type
4387: ) RETURN VARCHAR2 IS
4388: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4389: BEGIN
4390: -- If invoice type is G_STANDARD then invoice amount is positive
4391: -- If invoice type is G_CREDIT then the invoice amount is negative.
4392: -- sjalasut, made changes to incorporate the business rule as part
4393: -- of OKLR12B Disbursements Project
4394:

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

4396: -- wrong data.
4397: IF p_tapv_rec.trx_status_code = 'ENTERED' THEN
4398: --end: cklee 03/01/07 added the following condition, somehow UI has passed
4399: -- wrong data.
4400: IF((p_tapv_rec.INVOICE_TYPE = G_STANDARD AND p_tapv_rec.AMOUNT < 0)
4401: OR(p_tapv_rec.INVOICE_TYPE = G_CREDIT AND p_tapv_rec.AMOUNT > 0))THEN
4402: OKL_API.set_message(
4403: p_app_name => G_APP_NAME
4404: ,p_msg_name => 'OKL_LLA_INV_TYPE_AND_SIGN'

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

4667: p_token1_value => 'Amount');
4668: RAISE G_EXCEPTION_HALT_VALIDATION;
4669: END IF;
4670: --start: cklee 3/01/07 added invoice type and amount sign check at line level
4671: -- If invoice type is G_STANDARD then invoice amount is positive
4672: -- If invoice type is G_CREDIT then the invoice amount is negative.
4673: -- cklee, made changes to incorporate the business rule as part
4674: -- of OKLR12B Disbursements Project
4675: open c_invoice_type(p_tplv_rec.tap_id);

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

4675: open c_invoice_type(p_tplv_rec.tap_id);
4676: fetch c_invoice_type into l_invoice_type;
4677: close c_invoice_type;
4678:
4679: IF((l_invoice_type = G_STANDARD AND p_tplv_rec.AMOUNT < 0)
4680: OR(l_invoice_type = G_CREDIT AND p_tplv_rec.AMOUNT > 0))THEN
4681: OKL_API.set_message(
4682: p_app_name => G_APP_NAME
4683: ,p_msg_name => 'OKL_LLA_INV_TYPE_AND_SIGN'

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

6894: l_tapv_rec.CURRENCY_CODE := l_currency_code;
6895: l_tapv_rec.PAYMENT_METHOD_CODE := 'CHECK';
6896: l_tapv_rec.DATE_ENTERED := sysdate;
6897:
6898: -- sjalasut, modified the invoice_type from G_STANDARD to G_CREDIT
6899: -- changes made as part of OKLR12B Disbursements Project
6900: l_tapv_rec.INVOICE_TYPE := G_CREDIT;
6901:
6902: -- sjalasut, added code to make sure that the invoice amount on the credit memo