[Home] [Help]
6231: END IF;
6232:
6233: --Risk Score evaluation -- Bug 6805953
6234: IF nvl(p_risk_eval_flag, 'Y') = 'Y' THEN --change flag to p_risk_eval_flag l_RiskEval_Enable_Flag verify
6235: -- l_risk_threshold := oe_sys_parameters.value('RISK_FACTOR_THRESHOLD');
6236: IF l_debug_level > 0 THEN
6237: oe_debug_pub.add('Risk threshold value....'||L_auth_result.risk_result.Risk_Threshold_Val);
6238: oe_debug_pub.add('Risk score...'||L_auth_result.risk_result.risk_score);
6239: oe_debug_pub.add('Risky Flag : ' || L_auth_result.risk_result.risky_flag);
7407: (SELECT 'Non Invoiceable Item Line'
7408: FROM mtl_system_items mti
7409: WHERE mti.inventory_item_id = ool.inventory_item_id
7410: AND mti.organization_id = nvl(ool.ship_from_org_id,
7411: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7412: AND (mti.invoiceable_item_flag = 'N'
7413: OR mti.invoice_enabled_flag = 'N'));
7414:
7415: EXCEPTION
7436: FROM mtl_system_items mti, oe_order_lines_all ool
7437: WHERE ool.line_id = op.line_id
7438: AND mti.inventory_item_id = ool.inventory_item_id
7439: AND mti.organization_id = nvl(ool.ship_from_org_id,
7440: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7441: AND (mti.invoiceable_item_flag = 'N'
7442: OR mti.invoice_enabled_flag = 'N'));
7443: ELSE
7444: SELECT --nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price) -- sol_ord_er #16014165
7455: (SELECT 'Non Invoiceable Item Line'
7456: FROM mtl_system_items mti
7457: WHERE mti.inventory_item_id = ool.inventory_item_id
7458: AND mti.organization_id = nvl(ool.ship_from_org_id,
7459: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7460: AND (mti.invoiceable_item_flag = 'N'
7461: OR mti.invoice_enabled_flag = 'N'));
7462: END IF;
7463:
7526: + nvl(l_charge_amount,0);
7527:
7528: --pnpl adding the checks w.r.t p_amount_type
7529: IF p_amount_type IS NULL THEN
7530: --IF oe_sys_parameters.value('ACCOUNT_FIRST_INSTALLMENT_ONLY') = 'Y'
7531: --pnpl
7532: IF Oe_Prepayment_Util.Get_Installment_Options = 'AUTHORIZE_FIRST_INSTALLMENT' THEN
7533:
7534: l_pay_now_total_detail_tbl(1).line_id := p_line_id;
7683: (SELECT 'Non Invoiceable Item Line'
7684: FROM mtl_system_items mti
7685: WHERE mti.inventory_item_id = ool.inventory_item_id
7686: AND mti.organization_id = nvl(ool.ship_from_org_id,
7687: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7688: AND (mti.invoiceable_item_flag = 'N'
7689: OR mti.invoice_enabled_flag = 'N'));
7690: EXCEPTION
7691: WHEN NO_DATA_FOUND THEN
7711: FROM mtl_system_items mti, oe_order_lines_all ool
7712: WHERE ool.line_id = op.line_id
7713: AND mti.inventory_item_id = ool.inventory_item_id
7714: AND mti.organization_id = nvl(ool.ship_from_org_id,
7715: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7716: AND (mti.invoiceable_item_flag = 'N'
7717: OR mti.invoice_enabled_flag = 'N'));
7718: ELSE
7719: SELECT --nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price) -- sol_ord_er #16014165
7728: (SELECT 'Non Invoiceable Item Line'
7729: FROM mtl_system_items mti
7730: WHERE mti.inventory_item_id = ool.inventory_item_id
7731: AND mti.organization_id = nvl(ool.ship_from_org_id,
7732: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7733: AND (mti.invoiceable_item_flag = 'N'
7734: OR mti.invoice_enabled_flag = 'N'));
7735: END IF;
7736:
7922: (SELECT 'Non Invoiceable Item Line'
7923: FROM mtl_system_items mti
7924: WHERE mti.inventory_item_id = ool.inventory_item_id
7925: AND mti.organization_id = nvl(ool.ship_from_org_id,
7926: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7927: AND (mti.invoiceable_item_flag = 'N'
7928: OR mti.invoice_enabled_flag = 'N'));
7929:
7930: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7942: FROM mtl_system_items mti, oe_order_lines_all ool
7943: WHERE ool.line_id = op.line_id
7944: AND mti.inventory_item_id = ool.inventory_item_id
7945: AND mti.organization_id = nvl(ool.ship_from_org_id,
7946: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7947: AND (mti.invoiceable_item_flag = 'N'
7948: OR mti.invoice_enabled_flag = 'N'));
7949: ELSE
7950: -- Select the Outbound Extended Price for lines that have committment
7964: (SELECT 'Non Invoiceable Item Line'
7965: FROM mtl_system_items mti
7966: WHERE mti.inventory_item_id = ool.inventory_item_id
7967: AND mti.organization_id = nvl(ool.ship_from_org_id,
7968: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7969: AND (mti.invoiceable_item_flag = 'N'
7970: OR mti.invoice_enabled_flag = 'N'));
7971: END IF;
7972:
8009: (SELECT 'Non Invoiceable Item Line'
8010: FROM MTL_SYSTEM_ITEMS MTI
8011: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
8012: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
8013: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', L.org_id))
8014: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'
8015: OR MTI.INVOICE_ENABLED_FLAG = 'N'));
8016:
8017: l_charges := nvl(l_chgs_wo_line_id,0) + nvl(l_chgs_w_line_id,0);
9014: oe_debug_pub.add( 'Entering Get_CC_Rev_Reauth_Code.', 1 ) ;
9015: END IF;
9016:
9017: BEGIN
9018: SELECT NVL(ordr_type.CREDIT_CARD_REV_REAUTH_CODE,oe_sys_parameters.value('OE_CC_REVERSAL_REAUTHORIZATION'))
9019: INTO l_cc_rev_reauth_code
9020: FROM OE_ORDER_HEADERS_ALL ordr ,
9021: OE_TRANSACTION_TYPES_ALL ordr_type
9022: WHERE ordr.ORDER_TYPE_ID = ordr_type.TRANSACTION_TYPE_ID