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_PRICING_PVT dependencies on FND_MESSAGE

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

153: -- API body
154: --
155: IF l_pl_notify_hdr_rec.vendor_id IS NULL THEN
156: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor ID cannot be NULL');
157: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
158: FND_MESSAGE.set_token('ID', 'Vendor ID');
159: FND_MSG_PUB.add;
160: RAISE FND_API.G_EXC_ERROR;
161: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN

Line 158: FND_MESSAGE.set_token('ID', 'Vendor ID');

154: --
155: IF l_pl_notify_hdr_rec.vendor_id IS NULL THEN
156: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor ID cannot be NULL');
157: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
158: FND_MESSAGE.set_token('ID', 'Vendor ID');
159: FND_MSG_PUB.add;
160: RAISE FND_API.G_EXC_ERROR;
161: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
162: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');

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

159: FND_MSG_PUB.add;
160: RAISE FND_API.G_EXC_ERROR;
161: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
162: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');
163: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
164: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
165: FND_MSG_PUB.add;
166: RAISE FND_API.G_EXC_ERROR;
167: ELSE

Line 164: FND_MESSAGE.set_token('ID', 'Vendor Site ID');

160: RAISE FND_API.G_EXC_ERROR;
161: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
162: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');
163: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
164: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
165: FND_MSG_PUB.add;
166: RAISE FND_API.G_EXC_ERROR;
167: ELSE
168: FOR get_vendor_rec IN get_vendor_csr(p_pl_notify_hdr_rec.vendor_id)

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

195:
196: IF l_pl_notify_line_tbl(i).inventory_item_id IS NULL THEN
197: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Item ID cannot be NULL');
198:
199: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
200: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
201: FND_MSG_PUB.add;
202: RAISE FND_API.G_EXC_ERROR;
203:

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

196: IF l_pl_notify_line_tbl(i).inventory_item_id IS NULL THEN
197: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Item ID cannot be NULL');
198:
199: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
200: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
201: FND_MSG_PUB.add;
202: RAISE FND_API.G_EXC_ERROR;
203:
204: ELSE

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

277: WHEN OTHERS THEN
278:
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
281: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');
283: fnd_message.set_token('ERRNO', sqlcode);
284: fnd_message.set_token('REASON', sqlerrm);
285: END IF;

Line 282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');

278:
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
281: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');
283: fnd_message.set_token('ERRNO', sqlcode);
284: fnd_message.set_token('REASON', sqlerrm);
285: END IF;
286: -- Standard call to get message count and if count=1, get the message

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

279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
281: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');
283: fnd_message.set_token('ERRNO', sqlcode);
284: fnd_message.set_token('REASON', sqlerrm);
285: END IF;
286: -- Standard call to get message count and if count=1, get the message
287: FND_MSG_PUB.Count_And_Get (

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

280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
281: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');
283: fnd_message.set_token('ERRNO', sqlcode);
284: fnd_message.set_token('REASON', sqlerrm);
285: END IF;
286: -- Standard call to get message count and if count=1, get the message
287: FND_MSG_PUB.Count_And_Get (
288: p_encoded => FND_API.G_FALSE,

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

451: -- API body
452: --
453: IF l_pl_notify_hdr_rec.vendor_id IS NULL THEN
454: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor ID cannot be NULL');
455: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
456: FND_MESSAGE.set_token('ID', 'Vendor ID');
457: FND_MSG_PUB.add;
458: RAISE FND_API.G_EXC_ERROR;
459: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN

Line 456: FND_MESSAGE.set_token('ID', 'Vendor ID');

452: --
453: IF l_pl_notify_hdr_rec.vendor_id IS NULL THEN
454: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor ID cannot be NULL');
455: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
456: FND_MESSAGE.set_token('ID', 'Vendor ID');
457: FND_MSG_PUB.add;
458: RAISE FND_API.G_EXC_ERROR;
459: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
460: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');

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

457: FND_MSG_PUB.add;
458: RAISE FND_API.G_EXC_ERROR;
459: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
460: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');
461: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
462: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
463: FND_MSG_PUB.add;
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE

Line 462: FND_MESSAGE.set_token('ID', 'Vendor Site ID');

458: RAISE FND_API.G_EXC_ERROR;
459: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
460: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');
461: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
462: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
463: FND_MSG_PUB.add;
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: FOR get_vendor_rec IN get_vendor_csr(p_pl_notify_hdr_rec.vendor_id)

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

490: LOOP
491:
492: IF l_pl_notify_line_tbl(i).inventory_item_id IS NULL THEN
493: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Item ID cannot be NULL');
494: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
495: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
496: FND_MSG_PUB.add;
497: RAISE FND_API.G_EXC_ERROR;
498:

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

491:
492: IF l_pl_notify_line_tbl(i).inventory_item_id IS NULL THEN
493: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Item ID cannot be NULL');
494: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
495: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
496: FND_MSG_PUB.add;
497: RAISE FND_API.G_EXC_ERROR;
498:
499: ELSE

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

571:
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
574: THEN
575: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');
577: fnd_message.set_token('ERRNO', sqlcode);
578: fnd_message.set_token('REASON', sqlerrm);
579: FND_MSG_PUB.ADD;

Line 576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');

572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
574: THEN
575: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');
577: fnd_message.set_token('ERRNO', sqlcode);
578: fnd_message.set_token('REASON', sqlerrm);
579: FND_MSG_PUB.ADD;
580: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify inbound pricelists: '||SQLERRM);

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

573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
574: THEN
575: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');
577: fnd_message.set_token('ERRNO', sqlcode);
578: fnd_message.set_token('REASON', sqlerrm);
579: FND_MSG_PUB.ADD;
580: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify inbound pricelists: '||SQLERRM);
581: END IF;

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

574: THEN
575: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');
577: fnd_message.set_token('ERRNO', sqlcode);
578: fnd_message.set_token('REASON', sqlerrm);
579: FND_MSG_PUB.ADD;
580: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify inbound pricelists: '||SQLERRM);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message

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

754: --
755:
756: IF l_pl_notify_hdr_rec.vendor_id IS NULL THEN
757: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor ID cannot be NULL');
758: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
759: FND_MESSAGE.set_token('ID', 'Vendor ID');
760: FND_MSG_PUB.add;
761: RAISE FND_API.G_EXC_ERROR;
762: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN

Line 759: FND_MESSAGE.set_token('ID', 'Vendor ID');

755:
756: IF l_pl_notify_hdr_rec.vendor_id IS NULL THEN
757: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor ID cannot be NULL');
758: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
759: FND_MESSAGE.set_token('ID', 'Vendor ID');
760: FND_MSG_PUB.add;
761: RAISE FND_API.G_EXC_ERROR;
762: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
763: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');

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

760: FND_MSG_PUB.add;
761: RAISE FND_API.G_EXC_ERROR;
762: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
763: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');
764: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
765: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
766: FND_MSG_PUB.add;
767: RAISE FND_API.G_EXC_ERROR;
768: ELSIF l_pl_notify_hdr_rec.org_id IS NULL THEN

Line 765: FND_MESSAGE.set_token('ID', 'Vendor Site ID');

761: RAISE FND_API.G_EXC_ERROR;
762: ELSIF l_pl_notify_hdr_rec.vendor_site_id IS NULL THEN
763: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Vendor Site ID cannot be NULL');
764: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
765: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
766: FND_MSG_PUB.add;
767: RAISE FND_API.G_EXC_ERROR;
768: ELSIF l_pl_notify_hdr_rec.org_id IS NULL THEN
769: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Org ID cannot be NULL');

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

766: FND_MSG_PUB.add;
767: RAISE FND_API.G_EXC_ERROR;
768: ELSIF l_pl_notify_hdr_rec.org_id IS NULL THEN
769: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Org ID cannot be NULL');
770: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
771: FND_MESSAGE.set_token('ID', 'Org ID');
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_ERROR;
774: ELSE

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

767: RAISE FND_API.G_EXC_ERROR;
768: ELSIF l_pl_notify_hdr_rec.org_id IS NULL THEN
769: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Org ID cannot be NULL');
770: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
771: FND_MESSAGE.set_token('ID', 'Org ID');
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_ERROR;
774: ELSE
775: FOR get_vendor_rec IN get_vendor_csr(p_pl_notify_hdr_rec.vendor_id) LOOP

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

788: IF l_pl_notify_line_tbl.EXISTS(1) THEN
789: FOR i in l_pl_notify_line_tbl.FIRST..l_pl_notify_line_tbl.LAST LOOP
790: IF l_pl_notify_line_tbl(i).inventory_item_id IS NULL THEN
791: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Item ID cannot be NULL');
792: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
793: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
794: FND_MSG_PUB.add;
795: RAISE FND_API.G_EXC_ERROR;
796: ELSE

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

789: FOR i in l_pl_notify_line_tbl.FIRST..l_pl_notify_line_tbl.LAST LOOP
790: IF l_pl_notify_line_tbl(i).inventory_item_id IS NULL THEN
791: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Item ID cannot be NULL');
792: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
793: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
794: FND_MSG_PUB.add;
795: RAISE FND_API.G_EXC_ERROR;
796: ELSE
797: FOR get_item_number_rec IN get_item_number_csr(l_pl_notify_line_tbl(i).Inventory_Item_ID) LOOP

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

811: END IF;
812: END LOOP;
813: ELSE
814: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Line detals cannot be NULL');
815: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
816: FND_MESSAGE.set_token('ID', 'Line Details');
817: FND_MSG_PUB.add;
818: RAISE FND_API.G_EXC_ERROR;
819: END IF;

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

812: END LOOP;
813: ELSE
814: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Line detals cannot be NULL');
815: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
816: FND_MESSAGE.set_token('ID', 'Line Details');
817: FND_MSG_PUB.add;
818: RAISE FND_API.G_EXC_ERROR;
819: END IF;
820: END IF;

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

867:
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');
873: fnd_message.set_token('ERRNO', sqlcode);
874: fnd_message.set_token('REASON', sqlerrm);
875: FND_MSG_PUB.ADD;

Line 872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');

868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');
873: fnd_message.set_token('ERRNO', sqlcode);
874: fnd_message.set_token('REASON', sqlerrm);
875: FND_MSG_PUB.ADD;
876: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify promotions: '||SQLERRM);

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

869: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');
873: fnd_message.set_token('ERRNO', sqlcode);
874: fnd_message.set_token('REASON', sqlerrm);
875: FND_MSG_PUB.ADD;
876: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify promotions: '||SQLERRM);
877: END IF;

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

870: THEN
871: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');
873: fnd_message.set_token('ERRNO', sqlcode);
874: fnd_message.set_token('REASON', sqlerrm);
875: FND_MSG_PUB.ADD;
876: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify promotions: '||SQLERRM);
877: END IF;
878: -- Standard call to get message count and if count=1, get the message