[Home] [Help]
129: organization_id = p_org_id;
130:
131: BEGIN
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version,
135: p_api_version,
136: l_api_name,
137: G_PKG_NAME)
231:
232:
233: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
234:
235: -- Standard call to get message count and if count is 1, get message info.
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,
238: p_data => x_msg_data
239: );
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data
260:
261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
262:
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,
268: p_data => x_msg_data
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,
289: p_count => x_msg_count,
290: p_data => x_msg_data
426: organization_id = p_org_id;
427:
428: BEGIN
429:
430: -- Standard call to check for call compatibility.
431: IF NOT FND_API.Compatible_API_Call ( l_api_version,
432: p_api_version,
433: l_api_name,
434: G_PKG_NAME)
528: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'return status for API =>'||x_return_status);
529:
530: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_full_name || 'end');
531:
532: -- Standard call to get message count and if count is 1, get message info.
533: FND_MSG_PUB.Count_And_Get
534: (p_count => x_msg_count,
535: p_data => x_msg_data
536: );
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: -- Standard call to get message count and if count=1, get the message
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556:
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
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
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data
728: organization_id = p_org_id;
729:
730: BEGIN
731:
732: -- Standard call to check for call compatibility.
733: IF NOT FND_API.Compatible_API_Call ( l_api_version,
734: p_api_version,
735: l_api_name,
736: G_PKG_NAME)
824:
825: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'return status for API =>'||x_return_status);
826:
827: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
828: -- Standard call to get message count and if count is 1, get message info.
829: FND_MSG_PUB.Count_And_Get
830: (p_count => x_msg_count,
831: p_data => x_msg_data
832: );
834:
835: WHEN FND_API.G_EXC_ERROR THEN
836:
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: -- Standard call to get message count and if count=1, get the message
839: FND_MSG_PUB.Count_And_Get (
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data
850:
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852:
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: -- Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data
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
879: FND_MSG_PUB.Count_And_Get (
880: p_encoded => FND_API.G_FALSE,
881: p_count => x_msg_count,
882: p_data => x_msg_data