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_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

387: l_rounding := 4;
388: END IF;
389:
390: IF l_cust_hdr_rec.org_id IS NULL THEN
391: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
392: FND_MESSAGE.set_token('ID', 'Org Id');
393: FND_MSG_PUB.add;
394: RAISE FND_API.G_EXC_ERROR;
395: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN

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

388: END IF;
389:
390: IF l_cust_hdr_rec.org_id IS NULL THEN
391: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
392: FND_MESSAGE.set_token('ID', 'Org Id');
393: FND_MSG_PUB.add;
394: RAISE FND_API.G_EXC_ERROR;
395: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

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

392: FND_MESSAGE.set_token('ID', 'Org Id');
393: FND_MSG_PUB.add;
394: RAISE FND_API.G_EXC_ERROR;
395: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: 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_end_date IS NULL THEN

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

393: FND_MSG_PUB.add;
394: RAISE FND_API.G_EXC_ERROR;
395: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: 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_end_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', 'Effective Start Date');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
402: 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.currency_code IS NULL THEN

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

398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
402: 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.currency_code 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 End Date');
403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
407: FND_MESSAGE.set_token('ID', 'Currency Code');
408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSE

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

403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
407: FND_MESSAGE.set_token('ID', 'Currency Code');
408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSE
411: IF l_customer_tbl.EXISTS(1) THEN

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

411: IF l_customer_tbl.EXISTS(1) THEN
412: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
413: l_supp_new_price := 0;
414: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
415: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
416: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
417: FND_MSG_PUB.add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSE

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

412: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
413: l_supp_new_price := 0;
414: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
415: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
416: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
417: FND_MSG_PUB.add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSE
420: BEGIN

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

562: 'N',
563: 'N');
564: EXCEPTION
565: WHEN OTHERS THEN
566: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
567: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
568: fnd_message.set_token('ERRNO', sqlcode);
569: fnd_message.set_token('REASON', sqlerrm);
570: fnd_msg_pub.add;

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

563: 'N');
564: EXCEPTION
565: WHEN OTHERS THEN
566: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
567: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
568: fnd_message.set_token('ERRNO', sqlcode);
569: fnd_message.set_token('REASON', sqlerrm);
570: fnd_msg_pub.add;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

564: EXCEPTION
565: WHEN OTHERS THEN
566: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
567: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
568: fnd_message.set_token('ERRNO', sqlcode);
569: fnd_message.set_token('REASON', sqlerrm);
570: fnd_msg_pub.add;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END;

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

565: WHEN OTHERS THEN
566: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
567: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
568: fnd_message.set_token('ERRNO', sqlcode);
569: fnd_message.set_token('REASON', sqlerrm);
570: fnd_msg_pub.add;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END;
573: -- Debug Message

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

592: l_claim_lines_tbl(i).org_id := l_cust_hdr_rec.org_id;
593: END IF; --If cust account id is not null
594: END LOOP; --customer_price_tbl loop
595: ELSE --customer_price_tbl exists
596: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
597: FND_MESSAGE.set_token('ID', 'Line Details');
598: FND_MSG_PUB.add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF; --customer_price_tbl exists

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

593: END IF; --If cust account id is not null
594: END LOOP; --customer_price_tbl loop
595: ELSE --customer_price_tbl exists
596: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
597: FND_MESSAGE.set_token('ID', 'Line Details');
598: FND_MSG_PUB.add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF; --customer_price_tbl exists
601: END IF; --inventory_item_id is not null

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

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

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

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');
638: FND_MSG_PUB.add;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF; --l_customer_tbl.EXISTS(1)
641: END IF; --l_cust_hdr_rec.org_id IS NULL

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

711:
712: WHEN OTHERS THEN
713: ROLLBACK TO Populate_CustomerPrice_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
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;

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

712: WHEN OTHERS THEN
713: ROLLBACK TO Populate_CustomerPrice_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
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);

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

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

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

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