DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on FND_FILE

Line 5107: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');

5103: -- Added For Bug 8402328
5104: OZF_Utility_PVT.debug_message('l_funds_util_flt.utilization_id : ' || l_funds_util_flt.utilization_id);
5105: END IF;
5106: IF p_claim_rec.created_from = 'AUTOPAY' THEN
5107: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);

Line 5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);

5104: OZF_Utility_PVT.debug_message('l_funds_util_flt.utilization_id : ' || l_funds_util_flt.utilization_id);
5105: END IF;
5106: IF p_claim_rec.created_from = 'AUTOPAY' THEN
5107: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);

Line 5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);

5105: END IF;
5106: IF p_claim_rec.created_from = 'AUTOPAY' THEN
5107: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5113: END IF;

Line 5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);

5106: IF p_claim_rec.created_from = 'AUTOPAY' THEN
5107: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5113: END IF;
5114:

Line 5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);

5107: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5113: END IF;
5114:
5115: IF l_plan_type = 'OFFR' THEN

Line 5112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);

5108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
5109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
5110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
5111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
5112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
5113: END IF;
5114:
5115: IF l_plan_type = 'OFFR' THEN
5116: Check_Offer_Performance(

Line 5229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_total_acctd_amount_rem : ' || l_total_acctd_amount_rem);

5225: END IF;
5226: CLOSE csr_uom_code;
5227: END IF;
5228:
5229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_total_acctd_amount_rem : ' || l_total_acctd_amount_rem);
5230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_amount : ' || l_amount);
5231:
5232:
5233: l_total_acctd_amount_rem := l_total_acctd_amount_rem + l_amount;

Line 5230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_amount : ' || l_amount);

5226: CLOSE csr_uom_code;
5227: END IF;
5228:
5229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_total_acctd_amount_rem : ' || l_total_acctd_amount_rem);
5230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NP l_amount : ' || l_amount);
5231:
5232:
5233: l_total_acctd_amount_rem := l_total_acctd_amount_rem + l_amount;
5234:

Line 5254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Performance requirements not met.');

5250: IF OZF_DEBUG_HIGH_ON THEN
5251: OZF_Utility_PVT.debug_message('Performance requirements not met.');
5252: END IF;
5253: IF p_claim_rec.created_from = 'AUTOPAY' THEN
5254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Performance requirements not met.');
5255: END IF;
5256: END IF;
5257: END IF;
5258: ELSE

Line 5732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Performance requirements not met.');

5728: IF OZF_DEBUG_HIGH_ON THEN
5729: OZF_Utility_PVT.debug_message('Performance requirements not met.');
5730: END IF;
5731: IF p_claim_rec.created_from = 'AUTOPAY' THEN
5732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Performance requirements not met.');
5733: END IF;
5734:
5735: END IF; -- End of l_amount <> 0
5736:

Line 6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);

6411: DBMS_SQL.column_value(l_emp_csr, 7, l_amount);
6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
6413:
6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);

Line 6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);

6412: DBMS_SQL.column_value(l_emp_csr, 8, l_currency_code);
6413:
6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
6420: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');

Line 6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);

6413:
6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
6420: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
6421:

Line 6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);

6414: IF l_amount IS NOT NULL AND l_amount <> 0 THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
6420: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
6421:
6422: -- Fix for Bug 7632911

Line 6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);

6415: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line ' || l_counter || ': Amount='||l_amount);
6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
6420: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
6421:
6422: -- Fix for Bug 7632911
6423: IF (l_total_amount >= l_amount AND l_claim_class <>'CHARGE') THEN

Line 6420: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');

6416: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Type : ' || l_plan_type);
6417: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Plan Id : ' || l_plan_id);
6418: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Level Type: ' || l_product_level_type);
6419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Product Id : ' || l_product_id);
6420: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------');
6421:
6422: -- Fix for Bug 7632911
6423: IF (l_total_amount >= l_amount AND l_claim_class <>'CHARGE') THEN
6424: l_line_tbl(l_counter).claim_currency_amount := l_amount;

Line 12634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_ship_debit_type = ' || p_ship_debit_type);

12630: IF (p_ship_debit_type IN ('SUPPLIER','INTERNAL') and l_claim_rec.amount <> 0) THEN
12631:
12632: IF (p_ship_debit_type = 'SUPPLIER' AND l_claim_rec.amount < 0) THEN
12633:
12634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_ship_debit_type = ' || p_ship_debit_type);
12635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_claim_rec.amount = ' || l_claim_rec.amount);
12636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sup_neg_batch = ' || l_sup_neg_batch);
12637: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim11 = ' || l_create_claim);
12638:

Line 12635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_claim_rec.amount = ' || l_claim_rec.amount);

12631:
12632: IF (p_ship_debit_type = 'SUPPLIER' AND l_claim_rec.amount < 0) THEN
12633:
12634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_ship_debit_type = ' || p_ship_debit_type);
12635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_claim_rec.amount = ' || l_claim_rec.amount);
12636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sup_neg_batch = ' || l_sup_neg_batch);
12637: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim11 = ' || l_create_claim);
12638:
12639: IF (l_sup_neg_batch is null) THEN

Line 12636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sup_neg_batch = ' || l_sup_neg_batch);

12632: IF (p_ship_debit_type = 'SUPPLIER' AND l_claim_rec.amount < 0) THEN
12633:
12634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_ship_debit_type = ' || p_ship_debit_type);
12635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_claim_rec.amount = ' || l_claim_rec.amount);
12636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sup_neg_batch = ' || l_sup_neg_batch);
12637: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim11 = ' || l_create_claim);
12638:
12639: IF (l_sup_neg_batch is null) THEN
12640: IF(nvl(fnd_profile.value('OZF_NEG_BATCH_CREATION'),'N') = 'Y') THEN

Line 12637: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim11 = ' || l_create_claim);

12633:
12634: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_ship_debit_type = ' || p_ship_debit_type);
12635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_claim_rec.amount = ' || l_claim_rec.amount);
12636: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sup_neg_batch = ' || l_sup_neg_batch);
12637: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim11 = ' || l_create_claim);
12638:
12639: IF (l_sup_neg_batch is null) THEN
12640: IF(nvl(fnd_profile.value('OZF_NEG_BATCH_CREATION'),'N') = 'Y') THEN
12641: l_create_claim := 'Y';

Line 12648: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim22 = ' || l_create_claim);

12644: l_create_claim := 'N';
12645: END IF;
12646: ELSIF(l_sup_neg_batch = 'YES') THEN
12647: l_create_claim := 'Y';
12648: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_create_claim22 = ' || l_create_claim);
12649: ELSE
12650: l_create_claim := 'N';
12651: --Raise error, if claim amount is negative.
12652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN