4633: OZF_Utility_PVT.debug_message('Product Level Type: ' || l_product_level_type);
4634: OZF_Utility_PVT.debug_message('Product Id : ' || l_product_id);
4635: END IF;
4636: IF p_claim_rec.created_from = 'AUTOPAY' THEN
4637: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
4638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
4641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
4634: OZF_Utility_PVT.debug_message('Product Id : ' || l_product_id);
4635: END IF;
4636: IF p_claim_rec.created_from = 'AUTOPAY' THEN
4637: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
4638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
4641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
4642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
4635: END IF;
4636: IF p_claim_rec.created_from = 'AUTOPAY' THEN
4637: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
4638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
4641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
4642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
4643: END IF;
4636: IF p_claim_rec.created_from = 'AUTOPAY' THEN
4637: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
4638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
4641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
4642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
4643: END IF;
4644:
4637: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
4638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
4641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
4642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
4643: END IF;
4644:
4645: IF l_plan_type = 'OFFR' THEN
4638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
4641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
4642: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
4643: END IF;
4644:
4645: IF l_plan_type = 'OFFR' THEN
4646: Check_Offer_Performance(
4725: END IF;
4726: CLOSE csr_uom_code;
4727: END IF;
4728:
4729: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_total_acctd_amount_rem : ' || l_total_acctd_amount_rem);
4730: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_amount : ' || l_amount);
4731:
4732:
4733: l_total_acctd_amount_rem := l_total_acctd_amount_rem + l_amount;
4726: CLOSE csr_uom_code;
4727: END IF;
4728:
4729: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_total_acctd_amount_rem : ' || l_total_acctd_amount_rem);
4730: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_amount : ' || l_amount);
4731:
4732:
4733: l_total_acctd_amount_rem := l_total_acctd_amount_rem + l_amount;
4734:
4749: IF OZF_DEBUG_HIGH_ON THEN
4750: OZF_Utility_PVT.debug_message('Performance requirements not met.');
4751: END IF;
4752: IF p_claim_rec.created_from = 'AUTOPAY' THEN
4753: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Performance requirements not met.');
4754: END IF;
4755: END IF;
4756: END IF;
4757: ELSE
5321: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
5322: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
5323:
5324: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5322: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
5323:
5324: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5330: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5323:
5324: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5330: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5331:
5324: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5330: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5331:
5332: -- Fix for Bug 7632911
5325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5330: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5331:
5332: -- Fix for Bug 7632911
5333: IF (l_total_amount >= l_amount AND l_claim_class <>'CHARGE') THEN
5326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5330: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5331:
5332: -- Fix for Bug 7632911
5333: IF (l_total_amount >= l_amount AND l_claim_class <>'CHARGE') THEN
5334: l_line_tbl(l_counter).claim_currency_amount := l_amount;