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 DPP_UTILITY_PVT

Line 139: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

135: END IF;
136:
137: -- Debug Message
138: IF g_debug THEN
139: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
140: END IF;
141: -- Initialize API return status to sucess
142: l_return_status := FND_API.G_RET_STS_SUCCESS;
143: --

Line 190: DPP_UTILITY_PVT.debug_message('Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );

186: l_count := l_count + 1;
187: l_customer_price_tbl(l_count).cust_account_id := get_customer_rec.customer_id;
188: -- Debug Message
189: IF g_debug THEN
190: DPP_UTILITY_PVT.debug_message('Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
191: DPP_UTILITY_PVT.debug_message('End Date: ' || l_cust_hdr_rec.Effective_End_Date );
192: DPP_UTILITY_PVT.debug_message('Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
193: DPP_UTILITY_PVT.debug_message('Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
194: END IF;

Line 191: DPP_UTILITY_PVT.debug_message('End Date: ' || l_cust_hdr_rec.Effective_End_Date );

187: l_customer_price_tbl(l_count).cust_account_id := get_customer_rec.customer_id;
188: -- Debug Message
189: IF g_debug THEN
190: DPP_UTILITY_PVT.debug_message('Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
191: DPP_UTILITY_PVT.debug_message('End Date: ' || l_cust_hdr_rec.Effective_End_Date );
192: DPP_UTILITY_PVT.debug_message('Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
193: DPP_UTILITY_PVT.debug_message('Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
194: END IF;
195: FOR get_last_price_rec IN get_last_price_csr(to_number(l_cust_hdr_rec.org_id),

Line 192: DPP_UTILITY_PVT.debug_message('Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );

188: -- Debug Message
189: IF g_debug THEN
190: DPP_UTILITY_PVT.debug_message('Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
191: DPP_UTILITY_PVT.debug_message('End Date: ' || l_cust_hdr_rec.Effective_End_Date );
192: DPP_UTILITY_PVT.debug_message('Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
193: DPP_UTILITY_PVT.debug_message('Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
194: END IF;
195: FOR get_last_price_rec IN get_last_price_csr(to_number(l_cust_hdr_rec.org_id),
196: to_number(l_customer_tbl(i).inventory_item_id),

Line 193: DPP_UTILITY_PVT.debug_message('Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );

189: IF g_debug THEN
190: DPP_UTILITY_PVT.debug_message('Start Date: ' || l_cust_hdr_rec.Effective_Start_Date );
191: DPP_UTILITY_PVT.debug_message('End Date: ' || l_cust_hdr_rec.Effective_End_Date );
192: DPP_UTILITY_PVT.debug_message('Formatted Start Date: ' || to_char(l_cust_hdr_rec.Effective_Start_Date,'DD-MON-YYYY') );
193: DPP_UTILITY_PVT.debug_message('Formatted End Date: ' || to_char(l_cust_hdr_rec.Effective_End_Date,'DD-MON-YYYY') );
194: END IF;
195: FOR get_last_price_rec IN get_last_price_csr(to_number(l_cust_hdr_rec.org_id),
196: to_number(l_customer_tbl(i).inventory_item_id),
197: get_customer_rec.customer_id,

Line 232: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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

Line 335: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;

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

Line 336: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;

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

Line 338: --l_lastprice_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;

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

Line 378: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

374: END IF;
375:
376: -- Debug Message
377: IF g_debug THEN
378: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
379: END IF;
380: -- Initialize API return status to sucess
381: l_return_status := FND_API.G_RET_STS_SUCCESS;
382: --

Line 431: DPP_UTILITY_PVT.debug_message('Supp Price: '||l_supp_new_price);

427: l_supp_new_price := 0;
428: END;
429: -- Debug Message
430: IF g_debug THEN
431: DPP_UTILITY_PVT.debug_message('Supp Price: '||l_supp_new_price);
432: END IF;
433: IF l_customer_tbl(i).customer_price_tbl.EXISTS(1) THEN
434: FOR j IN l_customer_tbl(i).customer_price_tbl.FIRST..l_customer_tbl(i).customer_price_tbl.LAST LOOP
435: l_conv_supp_new_price := 0;

Line 453: DPP_UTILITY_PVT.Get_CustomerInventory(p_hdr_rec => l_hdr_rec

449: l_cust_inv_tbl.delete();
450: l_cust_inv_tbl(1).inventory_item_id := to_number(l_customer_tbl(i).inventory_item_id);
451: l_cust_inv_tbl(1).customer_id := l_customer_tbl(i).customer_price_tbl(j).cust_account_id;
452:
453: DPP_UTILITY_PVT.Get_CustomerInventory(p_hdr_rec => l_hdr_rec
454: ,p_cust_inv_tbl => l_cust_inv_tbl
455: ,x_rec_count => l_rec_count
456: ,x_return_status => l_return_status
457: );

Line 460: DPP_UTILITY_PVT.debug_message('Return status for Get_CustomerInventory: '||l_return_status);

456: ,x_return_status => l_return_status
457: );
458: --Debug Message
459: IF g_debug THEN
460: DPP_UTILITY_PVT.debug_message('Return status for Get_CustomerInventory: '||l_return_status);
461: DPP_UTILITY_PVT.debug_message('Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
462: DPP_UTILITY_PVT.debug_message('Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
463: END IF;
464: --Convert supp new price

Line 461: DPP_UTILITY_PVT.debug_message('Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);

457: );
458: --Debug Message
459: IF g_debug THEN
460: DPP_UTILITY_PVT.debug_message('Return status for Get_CustomerInventory: '||l_return_status);
461: DPP_UTILITY_PVT.debug_message('Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
462: DPP_UTILITY_PVT.debug_message('Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
463: END IF;
464: --Convert supp new price
465: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code

Line 462: DPP_UTILITY_PVT.debug_message('Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);

458: --Debug Message
459: IF g_debug THEN
460: DPP_UTILITY_PVT.debug_message('Return status for Get_CustomerInventory: '||l_return_status);
461: DPP_UTILITY_PVT.debug_message('Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
462: DPP_UTILITY_PVT.debug_message('Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
463: END IF;
464: --Convert supp new price
465: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
466: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code

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

461: DPP_UTILITY_PVT.debug_message('Cust O/H: '||l_cust_inv_tbl(1).onhand_quantity);
462: DPP_UTILITY_PVT.debug_message('Customer ID: '||l_customer_tbl(i).customer_price_tbl(j).cust_account_id);
463: END IF;
464: --Convert supp new price
465: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
466: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
467: ,p_conv_type => FND_API.G_MISS_CHAR
468: ,p_conv_rate => FND_API.G_MISS_NUM
469: ,p_conv_date => trunc(SYSDATE)

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

473: ,x_rate => l_exchange_rate);
474: l_rnd_supp_new_price := ROUND(l_conv_supp_new_price,l_rounding);
475: IF l_price_change <> 0 THEN
476: -- convert price change
477: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
478: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
479: ,p_conv_type => FND_API.G_MISS_CHAR
480: ,p_conv_rate => FND_API.G_MISS_NUM
481: ,p_conv_date => trunc(SYSDATE)

Line 575: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_ALL');

571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END;
573: -- Debug Message
574: IF g_debug THEN
575: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_ALL');
576: END IF;
577: --Assign values to l_claim_lines_tbl for insertion into Log table
578: l_claim_lines_tbl(i).log_mode := 'I'; -- Insert
579: l_claim_lines_tbl(i).transaction_header_id := l_cust_hdr_rec.transaction_header_id;

Line 615: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');

611: ,p_claim_lines_tbl => l_claim_lines_tbl
612: );
613: -- Debug Message
614: IF g_debug THEN
615: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');
616: DPP_UTILITY_PVT.debug_message('Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);
617: END IF;
618:
619: UPDATE DPP_EXECUTION_DETAILS

Line 616: DPP_UTILITY_PVT.debug_message('Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);

612: );
613: -- Debug Message
614: IF g_debug THEN
615: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_LOG');
616: DPP_UTILITY_PVT.debug_message('Return Status from DPP_LOG_PVT.Insert_ClaimsLog: '|| l_return_status);
617: END IF;
618:
619: UPDATE DPP_EXECUTION_DETAILS
620: SET execution_end_date = sysdate

Line 632: DPP_UTILITY_PVT.debug_message(l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);

628: ,object_version_number = nvl(object_version_number,0) + 1
629: WHERE execution_detail_id = l_cust_hdr_rec.Execution_Detail_ID;
630: -- Debug Message
631: IF g_debug THEN
632: DPP_UTILITY_PVT.debug_message(l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);
633: DPP_UTILITY_PVT.debug_message(l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');
634: END IF;
635: ELSE
636: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 633: DPP_UTILITY_PVT.debug_message(l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');

629: WHERE execution_detail_id = l_cust_hdr_rec.Execution_Detail_ID;
630: -- Debug Message
631: IF g_debug THEN
632: DPP_UTILITY_PVT.debug_message(l_api_name||': Exe Detail ID: '||l_cust_hdr_rec.Execution_Detail_ID);
633: DPP_UTILITY_PVT.debug_message(l_api_name|| ': '||SQL%ROWCOUNT ||' row(s) updated in DPP_EXECUTION_DETAILS.');
634: END IF;
635: ELSE
636: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
637: FND_MESSAGE.set_token('ID', 'Line Details');

Line 651: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

647: COMMIT WORK;
648: END IF;
649: -- Debug Message
650: IF g_debug THEN
651: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
652: END IF;
653: -- Standard call to get message count and if count is 1, get message info.
654: FND_MSG_PUB.Count_And_Get
655: (p_count => x_msg_count,

Line 667: WHEN DPP_UTILITY_PVT.resource_locked THEN

663: END IF;
664:
665: --Exception Handling
666: EXCEPTION
667: WHEN DPP_UTILITY_PVT.resource_locked THEN
668: ROLLBACK TO Populate_CustomerPrice_PVT;
669: x_return_status := FND_API.g_ret_sts_error;
670: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
671: FND_MSG_PUB.Count_And_Get (

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

666: EXCEPTION
667: WHEN DPP_UTILITY_PVT.resource_locked THEN
668: ROLLBACK TO Populate_CustomerPrice_PVT;
669: x_return_status := FND_API.g_ret_sts_error;
670: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data

Line 720: DPP_UTILITY_PVT.debug_message('Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);

716: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
717: fnd_message.set_token('ERRNO', sqlcode);
718: fnd_message.set_token('REASON', sqlerrm);
719: FND_MSG_PUB.ADD;
720: DPP_UTILITY_PVT.debug_message('Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);
721:
722: -- Standard call to get message count and if count=1, get the message
723: FND_MSG_PUB.Count_And_Get (
724: p_encoded => FND_API.G_FALSE,