DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 516: INSERT INTO DPP_CUSTOMER_CLAIMS_ALL(TRANSACTION_HEADER_ID,

512: l_cust_claim_amt := (l_reported_inventory * (l_last_price - l_rnd_cust_new_price));
513: l_supp_claim_amt := (l_reported_inventory * l_rnd_price_change);
514:
515: BEGIN
516: INSERT INTO DPP_CUSTOMER_CLAIMS_ALL(TRANSACTION_HEADER_ID,
517: CUSTOMER_INV_LINE_ID,
518: LINE_NUMBER,
519: LAST_PRICE,
520: SUPPLIER_NEW_PRICE,

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