DBA Data[Home] [Help]

APPS.ASO_DEAL_PUB dependencies on FND_MSG_PUB

Line 218: FND_MSG_PUB.initialize;

214:
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list )
217: THEN
218: FND_MSG_PUB.initialize;
219: END IF;
220:
221: -- Initialize API return status to SUCCESS
222: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

241: END IF;
242: --pp_debug('Access level:' || l_access_level);
243: IF ((l_access_level <> 'UPDATE') or (l_max_version_flag <> 'Y') or (l_price_request_id is not null)) THEN
244: x_return_status := fnd_api.g_ret_sts_error;
245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
246: if (l_max_version_flag <> 'Y') then
247: FND_MESSAGE.Set_Name('QOT', 'QOT_QTE_NOT_HIGH_VERSION');
248: FND_MSG_PUB.Add;
249: elsif (l_price_request_id is not null) then

Line 248: FND_MSG_PUB.Add;

244: x_return_status := fnd_api.g_ret_sts_error;
245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
246: if (l_max_version_flag <> 'Y') then
247: FND_MESSAGE.Set_Name('QOT', 'QOT_QTE_NOT_HIGH_VERSION');
248: FND_MSG_PUB.Add;
249: elsif (l_price_request_id is not null) then
250: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
251: FND_MSG_PUB.Add;
252: end if;

Line 251: FND_MSG_PUB.Add;

247: FND_MESSAGE.Set_Name('QOT', 'QOT_QTE_NOT_HIGH_VERSION');
248: FND_MSG_PUB.Add;
249: elsif (l_price_request_id is not null) then
250: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
251: FND_MSG_PUB.Add;
252: end if;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255:

Line 259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

255:
256: ELSIF l_pricing_status IS NULL OR
257: l_pricing_status <> 'C' THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICING_INCOMPLETE');
261: FND_MSG_PUB.ADD;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR;

Line 261: FND_MSG_PUB.ADD;

257: l_pricing_status <> 'C' THEN
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICING_INCOMPLETE');
261: FND_MSG_PUB.ADD;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR;
264: ELSIF l_tax_status IS NULL OR
265: l_tax_status <> 'C' THEN

Line 267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

263: RAISE FND_API.G_EXC_ERROR;
264: ELSIF l_tax_status IS NULL OR
265: l_tax_status <> 'C' THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
268: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_INCOMPLETE');
269: FND_MSG_PUB.ADD;
270: END IF;
271: RAISE FND_API.G_EXC_ERROR;

Line 269: FND_MSG_PUB.ADD;

265: l_tax_status <> 'C' THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
268: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_INCOMPLETE');
269: FND_MSG_PUB.ADD;
270: END IF;
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:

Line 301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

297: --pp_debug('After status validation In Event Submitted'||ln_quote_Status_id);
298:
299: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
300: --pp_debug('After status validation failure');
301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
302: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;

Line 303: FND_MSG_PUB.ADD;

299: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
300: --pp_debug('After status validation failure');
301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
302: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306:
307: end if;

Line 340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

336: aso_debug_pub.add('ASO_DEAL_PUB:Status ln_count=0', 1, 'Y');
337: END IF;
338:
339: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
341: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;

Line 342: FND_MSG_PUB.ADD;

338:
339: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
341: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: end if;
346: else -- if valid transition to price approval pending

Line 374: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

370: x_msg_data => x_msg_data);
371:
372: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
373: --pp_debug('After status validation failure');
374: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
375: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;

Line 376: FND_MSG_PUB.ADD;

372: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
373: --pp_debug('After status validation failure');
374: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
375: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379: end if;
380:

Line 397: FND_MSG_PUB.ADD;

393:
394: IF L_modifier_line_id is NULL THEN
395: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');
396: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');
397: FND_MSG_PUB.ADD;
398: IF aso_debug_pub.g_debug_flag='Y' THEN
399: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;
400: END IF;
401: RAISE FND_API.G_EXC_ERROR;

Line 605: FND_MSG_PUB.ADD;

601:
602: IF L_modifier_line_id is NULL THEN
603: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');
604: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');
605: FND_MSG_PUB.ADD;
606: IF aso_debug_pub.g_debug_flag='Y' THEN
607: aso_debug_pub.add( 'Profile is NULL ' , 1 ) ;
608: END IF;
609: RAISE FND_API.G_EXC_ERROR;

Line 650: FND_MSG_PUB.ADD;

646: AND t.LANGUAGE(+) = userenv('LANG');
647:
648: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_ADJ_NOT_DEFINED');
649: FND_MESSAGE.SET_TOKEN('COLUMN', l_modifier_name);
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: end if;
653:
654:

Line 732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

728: x_msg_count => x_msg_count,
729: x_msg_data => x_msg_data);
730:
731: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
733: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
734: FND_MSG_PUB.ADD;
735: END IF;
736: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 734: FND_MSG_PUB.ADD;

730:
731: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
733: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');
734: FND_MSG_PUB.ADD;
735: END IF;
736: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 828: FND_MSG_PUB.Count_And_Get

824: END IF; -- end if status
825:
826:
827: -- Standard call to get message count and if count is 1, get message info.
828: FND_MSG_PUB.Count_And_Get
829: ( p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832:

Line 845: FND_MSG_PUB.Count_And_Get

841: end if;
842:
843: x_return_status := FND_API.G_RET_STS_ERROR;
844:
845: FND_MSG_PUB.Count_And_Get
846: ( p_count => x_msg_count,
847: p_data => x_msg_data
848: );
849:

Line 864: FND_MSG_PUB.Count_And_Get

860: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
861: end if;
862:
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get
865: ( p_count => x_msg_count,
866: p_data => x_msg_data
867: );
868: ASO_UTILITY_PVT.Get_Messages(x_msg_count, x_msg_data);

Line 882: FND_MSG_PUB.ADD;

878:
879: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
880: FND_MESSAGE.Set_token('PKG_NAME' , g_pkg_name);
881: FND_MESSAGE.Set_token('API_NAME' , l_api_name);
882: FND_MSG_PUB.ADD;
883:
884: l_len_sqlerrm := Length(SQLERRM) ;
885: While l_len_sqlerrm >= l_err Loop
886: FND_MESSAGE.Set_Name('ASO', 'ASO_SQLERRM');

Line 889: FND_MSG_PUB.ADD;

885: While l_len_sqlerrm >= l_err Loop
886: FND_MESSAGE.Set_Name('ASO', 'ASO_SQLERRM');
887: FND_MESSAGE.Set_token('ERR_TEXT' , substr(SQLERRM,l_err,240));
888: l_err := l_err + 240;
889: FND_MSG_PUB.ADD;
890: end loop;
891:
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893:

Line 895: FND_MSG_PUB.Count_And_Get

891:
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893:
894:
895: FND_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899: ASO_UTILITY_PVT.Get_Messages(x_msg_count, x_msg_data);