DBA Data[Home] [Help]

APPS.ASO_DEAL_PUB dependencies on FND_MESSAGE

Line 247: FND_MESSAGE.Set_Name('QOT', 'QOT_QTE_NOT_HIGH_VERSION');

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
250: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
251: FND_MSG_PUB.Add;

Line 250: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');

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;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;

Line 260: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICING_INCOMPLETE');

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;
264: ELSIF l_tax_status IS NULL OR

Line 268: FND_MESSAGE.Set_Name('ASO', 'ASO_TAX_INCOMPLETE');

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;
272: END IF;

Line 302: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');

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;
306:

Line 341: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');

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;
345: end if;

Line 375: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');

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;
379: end if;

Line 395: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');

391: l_modifier_line_profile:=fnd_profile.value('QPR_DEAL_DIFF_MODIFIER');
392: L_modifier_line_id:=to_number(l_modifier_line_profile);
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 ) ;

Line 396: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');

392: L_modifier_line_id:=to_number(l_modifier_line_profile);
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;

Line 603: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_PROFILE_NOT_SET');

599: aso_debug_pub.add( 'Line Modifier Value'||L_modifier_line_id, 1 ) ;
600: END IF;
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 ) ;

Line 604: --FND_MESSAGE.SET_TOKEN('PROFILE', 'QPR_DEAL_DIFF_MODIFIER');

600: END IF;
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;

Line 648: FND_MESSAGE.SET_NAME('ASO','ASO_DEAL_PRC_ADJ_NOT_DEFINED');

644: where t.list_header_id = td.list_header_id
645: and list_line_id=l_modifier_line_id
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;

Line 649: FND_MESSAGE.SET_TOKEN('COLUMN', l_modifier_name);

645: and list_line_id=l_modifier_line_id
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:

Line 733: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_NO_QTE_STAT_TRANSITION');

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
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 879: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');

875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');
876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
877: END IF;
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:

Line 880: FND_MESSAGE.Set_token('PKG_NAME' , g_pkg_name);

876: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
877: END IF;
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) ;

Line 881: FND_MESSAGE.Set_token('API_NAME' , l_api_name);

877: END IF;
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

Line 886: FND_MESSAGE.Set_Name('ASO', 'ASO_SQLERRM');

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');
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;

Line 887: FND_MESSAGE.Set_token('ERR_TEXT' , substr(SQLERRM,l_err,240));

883:
884: l_len_sqlerrm := Length(SQLERRM) ;
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: