DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 522: INSERT INTO DPP_CUSTOMER_CLAIMS_ALL(TRANSACTION_HEADER_ID,

518: l_cust_claim_amt := (l_reported_inventory * (l_last_price - l_rnd_cust_new_price));
519: l_supp_claim_amt := (l_reported_inventory * l_rnd_price_change);
520:
521: BEGIN
522: INSERT INTO DPP_CUSTOMER_CLAIMS_ALL(TRANSACTION_HEADER_ID,
523: CUSTOMER_INV_LINE_ID,
524: LINE_NUMBER,
525: LAST_PRICE,
526: SUPPLIER_NEW_PRICE,

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