DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on DPP_UTILITY_PVT

Line 140: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');

136: END IF;
137:
138: -- Debug Message
139:
140: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');
141:
142: -- Initialize API return status to sucess
143: l_return_status := FND_API.G_RET_STS_SUCCESS;
144: --

Line 191: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );

187: l_count := l_count + 1;
188: l_customer_price_tbl(l_count).cust_account_id := get_customer_rec.customer_id;
189: -- Debug Message
190:
191: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
192: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'End Date: ' || l_cust_hdr_rec.Effective_End_Date );
193: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
194: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
195:

Line 192: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'End Date: ' || l_cust_hdr_rec.Effective_End_Date );

188: l_customer_price_tbl(l_count).cust_account_id := get_customer_rec.customer_id;
189: -- Debug Message
190:
191: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
192: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'End Date: ' || l_cust_hdr_rec.Effective_End_Date );
193: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
194: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
195:
196: FOR get_last_price_rec IN get_last_price_csr(to_number(l_cust_hdr_rec.org_id),

Line 193: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );

189: -- Debug Message
190:
191: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
192: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'End Date: ' || l_cust_hdr_rec.Effective_End_Date );
193: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
194: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
195:
196: FOR get_last_price_rec IN get_last_price_csr(to_number(l_cust_hdr_rec.org_id),
197: to_number(l_customer_tbl(i).inventory_item_id),

Line 194: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );

190:
191: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
192: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'End Date: ' || l_cust_hdr_rec.Effective_End_Date );
193: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
194: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
195:
196: FOR get_last_price_rec IN get_last_price_csr(to_number(l_cust_hdr_rec.org_id),
197: to_number(l_customer_tbl(i).inventory_item_id),
198: get_customer_rec.customer_id,

Line 233: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');

229: COMMIT WORK;
230: END IF;
231: -- Debug Message
232:
233: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
234:
235: -- Standard call to get message count and if count is 1, get message info.
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,

Line 336: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;

332: l_cust_hdr_rec dpp_cust_hdr_rec_type := p_cust_hdr_rec;
333: l_customer_tbl dpp_customer_tbl_type := p_customer_tbl;
334: l_customer_price_tbl dpp_customer_price_tbl_type;
335: l_claim_lines_tbl DPP_LOG_PVT.dpp_claim_line_tbl_type;
336: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
337: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;
338:
339: --l_lastprice_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;
340: l_result NUMBER;

Line 337: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;

333: l_customer_tbl dpp_customer_tbl_type := p_customer_tbl;
334: l_customer_price_tbl dpp_customer_price_tbl_type;
335: l_claim_lines_tbl DPP_LOG_PVT.dpp_claim_line_tbl_type;
336: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
337: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;
338:
339: --l_lastprice_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;
340: l_result NUMBER;
341: l_cust_inv_line_id NUMBER;

Line 339: --l_lastprice_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;

335: l_claim_lines_tbl DPP_LOG_PVT.dpp_claim_line_tbl_type;
336: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
337: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;
338:
339: --l_lastprice_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;
340: l_result NUMBER;
341: l_cust_inv_line_id NUMBER;
342: l_line_number NUMBER := 0;
343: l_sysdate DATE := SYSDATE;

Line 381: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');

377: END IF;
378:
379: -- Debug Message
380:
381: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');
382:
383: -- Initialize API return status to sucess
384: l_return_status := FND_API.G_RET_STS_SUCCESS;
385:

Line 437: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Supp Price: '||l_supp_new_price);

433: l_supp_new_price := 0;
434: END;
435: -- Debug Message
436:
437: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Supp Price: '||l_supp_new_price);
438:
439: IF l_customer_tbl(i).customer_price_tbl.EXISTS(1) THEN
440: FOR j IN l_customer_tbl(i).customer_price_tbl.FIRST..l_customer_tbl(i).customer_price_tbl.LAST LOOP
441: l_conv_supp_new_price := 0;

Line 459: DPP_UTILITY_PVT.Get_CustomerInventory(p_hdr_rec => l_hdr_rec

455: l_cust_inv_tbl.delete();
456: l_cust_inv_tbl(1).inventory_item_id := to_number(l_customer_tbl(i).inventory_item_id);
457: l_cust_inv_tbl(1).customer_id := l_customer_tbl(i).customer_price_tbl(j).cust_account_id;
458:
459: DPP_UTILITY_PVT.Get_CustomerInventory(p_hdr_rec => l_hdr_rec
460: ,p_cust_inv_tbl => l_cust_inv_tbl
461: ,x_rec_count => l_rec_count
462: ,x_return_status => l_return_status
463: );

Line 466: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return status for Get_CustomerInventory: '||l_return_status);

462: ,x_return_status => l_return_status
463: );
464: --Debug Message
465:
466: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return status for Get_CustomerInventory: '||l_return_status);
467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
468: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
469:
470: --Convert supp new price

Line 467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);

463: );
464: --Debug Message
465:
466: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return status for Get_CustomerInventory: '||l_return_status);
467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
468: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
469:
470: --Convert supp new price
471: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code

Line 468: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);

464: --Debug Message
465:
466: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return status for Get_CustomerInventory: '||l_return_status);
467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
468: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
469:
470: --Convert supp new price
471: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
472: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code

Line 471: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code

467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
468: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
469:
470: --Convert supp new price
471: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
472: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
473: ,p_conv_type => FND_API.G_MISS_CHAR
474: ,p_conv_rate => FND_API.G_MISS_NUM
475: ,p_conv_date => trunc(SYSDATE)

Line 483: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code

479: ,x_rate => l_exchange_rate);
480: l_rnd_supp_new_price := ROUND(l_conv_supp_new_price,l_rounding);
481: IF l_price_change <> 0 THEN
482: -- convert price change
483: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
484: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
485: ,p_conv_type => FND_API.G_MISS_CHAR
486: ,p_conv_rate => FND_API.G_MISS_NUM
487: ,p_conv_date => trunc(SYSDATE)

Line 581: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Insertion Done in table DPP_CUSTOMER_CLAIMS_ALL');

577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END;
579: -- Debug Message
580:
581: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Insertion Done in table DPP_CUSTOMER_CLAIMS_ALL');
582:
583: --Assign values to l_claim_lines_tbl for insertion into Log table
584: l_claim_lines_tbl(i).log_mode := 'I'; -- Insert
585: l_claim_lines_tbl(i).transaction_header_id := l_cust_hdr_rec.transaction_header_id;

Line 621: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');

617: ,p_claim_lines_tbl => l_claim_lines_tbl
618: );
619: -- Debug Message
620:
621: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');
622: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);
623:
624: END IF; --IF l_profile_option_value = 'Y' OR l_profile_option_value IS NULL THEN
625:

Line 622: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);

618: );
619: -- Debug Message
620:
621: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');
622: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);
623:
624: END IF; --IF l_profile_option_value = 'Y' OR l_profile_option_value IS NULL THEN
625:
626: UPDATE DPP_EXECUTION_DETAILS

Line 639: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);

635: ,object_version_number = nvl(object_version_number,0) + 1
636: WHERE execution_detail_id = l_cust_hdr_rec.Execution_Detail_ID;
637: -- Debug Message
638:
639: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);
640: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');
641:
642: ELSE
643: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 640: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');

636: WHERE execution_detail_id = l_cust_hdr_rec.Execution_Detail_ID;
637: -- Debug Message
638:
639: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);
640: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');
641:
642: ELSE
643: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
644: FND_MESSAGE.set_token('ID', 'Line Details');

Line 658: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');

654: COMMIT WORK;
655: END IF;
656: -- Debug Message
657:
658: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
659:
660: -- Standard call to get message count and if count is 1, get message info.
661: FND_MSG_PUB.Count_And_Get
662: (p_count => x_msg_count,

Line 674: WHEN DPP_UTILITY_PVT.resource_locked THEN

670: END IF;
671:
672: --Exception Handling
673: EXCEPTION
674: WHEN DPP_UTILITY_PVT.resource_locked THEN
675: ROLLBACK TO Populate_CustomerPrice_PVT;
676: x_return_status := FND_API.g_ret_sts_error;
677: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
678: FND_MSG_PUB.Count_And_Get (

Line 677: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');

673: EXCEPTION
674: WHEN DPP_UTILITY_PVT.resource_locked THEN
675: ROLLBACK TO Populate_CustomerPrice_PVT;
676: x_return_status := FND_API.g_ret_sts_error;
677: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
678: FND_MSG_PUB.Count_And_Get (
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data

Line 727: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);

723: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
724: fnd_message.set_token('ERRNO', sqlcode);
725: fnd_message.set_token('REASON', sqlerrm);
726: FND_MSG_PUB.ADD;
727: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);
728:
729: -- Standard call to get message count and if count=1, get the message
730: FND_MSG_PUB.Count_And_Get (
731: p_encoded => FND_API.G_FALSE,