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.DPP_CUSTOMERCLAIMS_PVT dependencies on FND_LOG

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 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 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 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 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,