DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on FND_MESSAGE

Line 148: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

144: --
145: -- API body
146: --
147: IF l_cust_hdr_rec.org_id IS NULL THEN
148: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
149: FND_MESSAGE.set_token('ID', 'Org ID');
150: FND_MSG_PUB.add;
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_cust_hdr_rec.Effective_Start_Date IS NULL THEN

Line 149: FND_MESSAGE.set_token('ID', 'Org ID');

145: -- API body
146: --
147: IF l_cust_hdr_rec.org_id IS NULL THEN
148: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
149: FND_MESSAGE.set_token('ID', 'Org ID');
150: FND_MSG_PUB.add;
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_cust_hdr_rec.Effective_Start_Date IS NULL THEN
153: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 153: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

149: FND_MESSAGE.set_token('ID', 'Org ID');
150: FND_MSG_PUB.add;
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_cust_hdr_rec.Effective_Start_Date IS NULL THEN
153: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
154: FND_MESSAGE.set_token('ID', 'Effective Start Date');
155: FND_MSG_PUB.add;
156: RAISE FND_API.G_EXC_ERROR;
157: ELSIF l_cust_hdr_rec.Effective_End_Date IS NULL THEN

Line 154: FND_MESSAGE.set_token('ID', 'Effective Start Date');

150: FND_MSG_PUB.add;
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_cust_hdr_rec.Effective_Start_Date IS NULL THEN
153: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
154: FND_MESSAGE.set_token('ID', 'Effective Start Date');
155: FND_MSG_PUB.add;
156: RAISE FND_API.G_EXC_ERROR;
157: ELSIF l_cust_hdr_rec.Effective_End_Date IS NULL THEN
158: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 158: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

154: FND_MESSAGE.set_token('ID', 'Effective Start Date');
155: FND_MSG_PUB.add;
156: RAISE FND_API.G_EXC_ERROR;
157: ELSIF l_cust_hdr_rec.Effective_End_Date IS NULL THEN
158: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
159: FND_MESSAGE.set_token('ID', 'Effective End Date');
160: FND_MSG_PUB.add;
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN

Line 159: FND_MESSAGE.set_token('ID', 'Effective End Date');

155: FND_MSG_PUB.add;
156: RAISE FND_API.G_EXC_ERROR;
157: ELSIF l_cust_hdr_rec.Effective_End_Date IS NULL THEN
158: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
159: FND_MESSAGE.set_token('ID', 'Effective End Date');
160: FND_MSG_PUB.add;
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
163: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 163: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

159: FND_MESSAGE.set_token('ID', 'Effective End Date');
160: FND_MSG_PUB.add;
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
163: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
164: FND_MESSAGE.set_token('ID', 'Currency Code');
165: FND_MSG_PUB.add;
166: RAISE FND_API.G_EXC_ERROR;
167: ELSE

Line 164: FND_MESSAGE.set_token('ID', 'Currency Code');

160: FND_MSG_PUB.add;
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
163: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
164: FND_MESSAGE.set_token('ID', 'Currency Code');
165: FND_MSG_PUB.add;
166: RAISE FND_API.G_EXC_ERROR;
167: ELSE
168: IF l_customer_tbl.EXISTS(1) THEN

Line 171: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

167: ELSE
168: IF l_customer_tbl.EXISTS(1) THEN
169: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
170: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
171: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
172: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
173: FND_MSG_PUB.add;
174: RAISE FND_API.G_EXC_ERROR;
175: ELSIF l_customer_tbl(i).uom_code IS NULL THEN

Line 172: FND_MESSAGE.set_token('ID', 'Inventory Item Id');

168: IF l_customer_tbl.EXISTS(1) THEN
169: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
170: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
171: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
172: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
173: FND_MSG_PUB.add;
174: RAISE FND_API.G_EXC_ERROR;
175: ELSIF l_customer_tbl(i).uom_code IS NULL THEN
176: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 176: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

172: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
173: FND_MSG_PUB.add;
174: RAISE FND_API.G_EXC_ERROR;
175: ELSIF l_customer_tbl(i).uom_code IS NULL THEN
176: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
177: FND_MESSAGE.set_token('ID', 'UOM Code');
178: FND_MSG_PUB.add;
179: RAISE FND_API.G_EXC_ERROR;
180: ELSE --Inventory item id null

Line 177: FND_MESSAGE.set_token('ID', 'UOM Code');

173: FND_MSG_PUB.add;
174: RAISE FND_API.G_EXC_ERROR;
175: ELSIF l_customer_tbl(i).uom_code IS NULL THEN
176: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
177: FND_MESSAGE.set_token('ID', 'UOM Code');
178: FND_MSG_PUB.add;
179: RAISE FND_API.G_EXC_ERROR;
180: ELSE --Inventory item id null
181: l_customer_price_tbl.delete();

Line 217: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

213: l_customer_tbl(i).customer_price_tbl := l_customer_price_tbl;
214: END IF; --Inventory item id null
215: END LOOP;
216: ELSE --No line details available
217: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
218: FND_MESSAGE.set_token('ID', 'Line Details');
219: FND_MSG_PUB.add;
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;

Line 218: FND_MESSAGE.set_token('ID', 'Line Details');

214: END IF; --Inventory item id null
215: END LOOP;
216: ELSE --No line details available
217: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
218: FND_MESSAGE.set_token('ID', 'Line Details');
219: FND_MSG_PUB.add;
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:

Line 278: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

274:
275: WHEN OTHERS THEN
276: ROLLBACK TO Select_CustomerPrice_PVT;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
280: fnd_message.set_token('ERRNO', sqlcode);
281: fnd_message.set_token('REASON', sqlerrm);
282: FND_MSG_PUB.add;

Line 279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');

275: WHEN OTHERS THEN
276: ROLLBACK TO Select_CustomerPrice_PVT;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
280: fnd_message.set_token('ERRNO', sqlcode);
281: fnd_message.set_token('REASON', sqlerrm);
282: FND_MSG_PUB.add;
283: -- Standard call to get message count and if count=1, get the message

Line 280: fnd_message.set_token('ERRNO', sqlcode);

276: ROLLBACK TO Select_CustomerPrice_PVT;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
280: fnd_message.set_token('ERRNO', sqlcode);
281: fnd_message.set_token('REASON', sqlerrm);
282: FND_MSG_PUB.add;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (

Line 281: fnd_message.set_token('REASON', sqlerrm);

277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
280: fnd_message.set_token('ERRNO', sqlcode);
281: fnd_message.set_token('REASON', sqlerrm);
282: FND_MSG_PUB.add;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,

Line 396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

392: l_rounding := 4;
393: END IF;
394:
395: IF l_cust_hdr_rec.org_id IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: FND_MESSAGE.set_token('ID', 'Org Id');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN

Line 397: FND_MESSAGE.set_token('ID', 'Org Id');

393: END IF;
394:
395: IF l_cust_hdr_rec.org_id IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: FND_MESSAGE.set_token('ID', 'Org Id');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

397: FND_MESSAGE.set_token('ID', 'Org Id');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
402: FND_MESSAGE.set_token('ID', 'Effective Start Date');
403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN

Line 402: FND_MESSAGE.set_token('ID', 'Effective Start Date');

398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
402: FND_MESSAGE.set_token('ID', 'Effective Start Date');
403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

402: FND_MESSAGE.set_token('ID', 'Effective Start Date');
403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
407: FND_MESSAGE.set_token('ID', 'Effective End Date');
408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN

Line 407: FND_MESSAGE.set_token('ID', 'Effective End Date');

403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
407: FND_MESSAGE.set_token('ID', 'Effective End Date');
408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
411: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 411: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

407: FND_MESSAGE.set_token('ID', 'Effective End Date');
408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
411: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
412: FND_MESSAGE.set_token('ID', 'Currency Code');
413: FND_MSG_PUB.add;
414: RAISE FND_API.G_EXC_ERROR;
415: ELSE

Line 412: FND_MESSAGE.set_token('ID', 'Currency Code');

408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
411: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
412: FND_MESSAGE.set_token('ID', 'Currency Code');
413: FND_MSG_PUB.add;
414: RAISE FND_API.G_EXC_ERROR;
415: ELSE
416: IF l_customer_tbl.EXISTS(1) THEN

Line 421: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

417: IF l_profile_option_value = 'Y' OR l_profile_option_value IS NULL THEN
418: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
419: l_supp_new_price := 0;
420: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
421: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
422: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
423: FND_MSG_PUB.add;
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE

Line 422: FND_MESSAGE.set_token('ID', 'Inventory Item Id');

418: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
419: l_supp_new_price := 0;
420: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
421: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
422: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
423: FND_MSG_PUB.add;
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE
426: BEGIN

Line 572: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

568: 'N',
569: 'N');
570: EXCEPTION
571: WHEN OTHERS THEN
572: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
574: fnd_message.set_token('ERRNO', sqlcode);
575: fnd_message.set_token('REASON', sqlerrm);
576: fnd_msg_pub.add;

Line 573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');

569: 'N');
570: EXCEPTION
571: WHEN OTHERS THEN
572: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
574: fnd_message.set_token('ERRNO', sqlcode);
575: fnd_message.set_token('REASON', sqlerrm);
576: fnd_msg_pub.add;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 574: fnd_message.set_token('ERRNO', sqlcode);

570: EXCEPTION
571: WHEN OTHERS THEN
572: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
574: fnd_message.set_token('ERRNO', sqlcode);
575: fnd_message.set_token('REASON', sqlerrm);
576: fnd_msg_pub.add;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END;

Line 575: fnd_message.set_token('REASON', sqlerrm);

571: WHEN OTHERS THEN
572: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
574: fnd_message.set_token('ERRNO', sqlcode);
575: fnd_message.set_token('REASON', sqlerrm);
576: fnd_msg_pub.add;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END;
579: -- Debug Message

Line 602: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

598: l_claim_lines_tbl(i).org_id := l_cust_hdr_rec.org_id;
599: END IF; --If cust account id is not null
600: END LOOP; --customer_price_tbl loop
601: ELSE --customer_price_tbl exists
602: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
603: FND_MESSAGE.set_token('ID', 'Line Details');
604: FND_MSG_PUB.add;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF; --customer_price_tbl exists

Line 603: FND_MESSAGE.set_token('ID', 'Line Details');

599: END IF; --If cust account id is not null
600: END LOOP; --customer_price_tbl loop
601: ELSE --customer_price_tbl exists
602: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
603: FND_MESSAGE.set_token('ID', 'Line Details');
604: FND_MSG_PUB.add;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF; --customer_price_tbl exists
607: END IF; --inventory_item_id is not null

Line 643: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

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');
645: FND_MSG_PUB.add;
646: RAISE FND_API.G_EXC_ERROR;
647: END IF; --l_customer_tbl.EXISTS(1)

Line 644: FND_MESSAGE.set_token('ID', 'Line Details');

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');
645: FND_MSG_PUB.add;
646: RAISE FND_API.G_EXC_ERROR;
647: END IF; --l_customer_tbl.EXISTS(1)
648: END IF; --l_cust_hdr_rec.org_id IS NULL

Line 722: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

718:
719: WHEN OTHERS THEN
720: ROLLBACK TO Populate_CustomerPrice_PVT;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
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;

Line 723: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');

719: WHEN OTHERS THEN
720: ROLLBACK TO Populate_CustomerPrice_PVT;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
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);

Line 724: fnd_message.set_token('ERRNO', sqlcode);

720: ROLLBACK TO Populate_CustomerPrice_PVT;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
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:

Line 725: fnd_message.set_token('REASON', sqlerrm);

721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
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