DBA Data[Home] [Help]

APPS.ASO_SUBMIT_QUOTE_PVT dependencies on FND_MSG_PUB

Line 207: FND_MSG_PUB.initialize;

203: END IF;
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list ) THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209:
210: -- Debug Message
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

207: FND_MSG_PUB.initialize;
208: END IF;
209:
210: -- Debug Message
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
212: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
213: FND_MSG_PUB.Add;
214: END IF;
215:

Line 213: FND_MSG_PUB.Add;

209:
210: -- Debug Message
211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
212: FND_MESSAGE.Set_Name('ASO', 'Copy Quote API: Start');
213: FND_MSG_PUB.Add;
214: END IF;
215:
216: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
217: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

234: -- ******************************************************************
235: -- Validate Environment
236: -- ******************************************************************
237: IF FND_GLOBAL.User_Id IS NULL THEN
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
240: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
241: FND_MSG_PUB.ADD;
242: END IF;

Line 241: FND_MSG_PUB.ADD;

237: IF FND_GLOBAL.User_Id IS NULL THEN
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
240: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
241: FND_MSG_PUB.ADD;
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: -- ******************************************************************

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

259: END IF;
260:
261: IF (C_Get_Update_Date%NOTFOUND) OR
262: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
265: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
266: FND_MSG_PUB.ADD;
267: END IF;

Line 266: FND_MSG_PUB.ADD;

262: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
265: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
266: FND_MSG_PUB.ADD;
267: END IF;
268: CLOSE C_Get_Update_Date;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;

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

273:
274: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
275: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
276: (l_last_upd_date <> p_qte_header_rec.last_update_date) Then
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
278: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
279: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
280: FND_MSG_PUB.ADD;
281: END IF;

Line 280: FND_MSG_PUB.ADD;

276: (l_last_upd_date <> p_qte_header_rec.last_update_date) Then
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
278: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
279: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
280: FND_MSG_PUB.ADD;
281: END IF;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: -- vtariker - Check Whether record has been changed

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

288: p_quote_header_id => p_qte_header_rec.quote_header_id,
289: x_status => lx_status);
290:
291: IF (lx_status = FND_API.G_TRUE) THEN
292: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
293: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
294: FND_MSG_PUB.ADD;
295: END IF;
296: RAISE FND_API.G_EXC_ERROR;

Line 294: FND_MSG_PUB.ADD;

290:
291: IF (lx_status = FND_API.G_TRUE) THEN
292: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
293: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
294: FND_MSG_PUB.ADD;
295: END IF;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;
298: -- 2692785

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

301: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
302: OPEN C_Validate_Quote (p_qte_header_rec.quote_header_id);
303: FETCH C_Validate_Quote into l_val;
304: IF C_Validate_Quote%NOTFOUND THEN
305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
307: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
308: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
309: FND_MSG_PUB.ADD;

Line 309: FND_MSG_PUB.ADD;

305: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
307: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
308: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
309: FND_MSG_PUB.ADD;
310: END IF;
311: CLOSE C_Validate_Quote;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;

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

369: x_msg_count => x_msg_count,
370: x_msg_data => x_msg_data
371: );
372: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
374: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SUB_EXPIRATION_DATE');
375: FND_MSG_PUB.ADD;
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;

Line 375: FND_MSG_PUB.ADD;

371: );
372: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
374: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SUB_EXPIRATION_DATE');
375: FND_MSG_PUB.ADD;
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:

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

409: x_msg_data => x_msg_data);
410:
411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
412: IF l_qte_header_rec.quote_status_id = l_qte_status_id then
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
415: FND_MSG_PUB.ADD;
416: END IF;
417: END IF;

Line 415: FND_MSG_PUB.ADD;

411: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
412: IF l_qte_header_rec.quote_status_id = l_qte_status_id then
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
415: FND_MSG_PUB.ADD;
416: END IF;
417: END IF;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;

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

522: FETCH C_Get_Config_Flag INTO l_complete_config, l_valid_config, l_instance_id;
523:
524: IF C_Get_Config_Flag%NOTFOUND THEN
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
528: FND_MSG_PUB.ADD;
529: END IF;
530: CLOSE C_Get_Config_Flag;

Line 528: FND_MSG_PUB.ADD;

524: IF C_Get_Config_Flag%NOTFOUND THEN
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
528: FND_MSG_PUB.ADD;
529: END IF;
530: CLOSE C_Get_Config_Flag;
531: RAISE FND_API.G_EXC_ERROR;
532: ELSE

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

539: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker
540:
541: IF (NVL(l_complete_config,'N') = 'N' OR NVL(l_valid_config,'N') = 'N') THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
544: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
545: FND_MSG_PUB.ADD;
546: END IF;
547: CLOSE C_Get_Config_Flag;

Line 545: FND_MSG_PUB.ADD;

541: IF (NVL(l_complete_config,'N') = 'N' OR NVL(l_valid_config,'N') = 'N') THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
544: FND_MESSAGE.Set_Name('ASO', 'ASO_INCOMPLETE_CONFIGURATION');
545: FND_MSG_PUB.ADD;
546: END IF;
547: CLOSE C_Get_Config_Flag;
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;

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

844: IF aso_debug_pub.g_debug_flag = 'Y' THEN
845: aso_debug_pub.add('Submit_Q: After Create_Order x_return_status: '||x_return_status, 1, 'N');
846: END IF;
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
849: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
850: FND_MSG_PUB.ADD;
851: END IF;
852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 850: FND_MSG_PUB.ADD;

846: END IF;
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
849: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');
850: FND_MSG_PUB.ADD;
851: END IF;
852: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;

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

925: IF aso_debug_pub.g_debug_flag = 'Y' THEN
926: aso_debug_pub.add('Submit_Q: After Create_Related_Obj x_return_status: '||x_return_status, 1, 'N');
927: END IF;
928: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
930: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');
931: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
932: FND_MSG_PUB.ADD;
933: END IF;

Line 932: FND_MSG_PUB.ADD;

928: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
930: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');
931: FND_MESSAGE.Set_Token('COLUMN', l_related_obj_rec.RELATIONSHIP_TYPE_CODE, TRUE);
932: FND_MSG_PUB.ADD;
933: END IF;
934: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;

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

985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');
987: END IF;
988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
990: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
991: FND_MSG_PUB.ADD;
992: END IF;
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 991: FND_MSG_PUB.ADD;

987: END IF;
988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
990: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');
991: FND_MSG_PUB.ADD;
992: END IF;
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;

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

1018: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1019: aso_debug_pub.add('Submit_Q: After Transfer_Reservation x_return_status: '||x_return_status, 1, 'N');
1020: END IF;
1021: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1023: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1024: FND_MSG_PUB.ADD;

1020: END IF;
1021: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1023: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');
1024: FND_MSG_PUB.ADD;
1025: END IF;
1026: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;

Line 1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1115: aso_debug_pub.add('Submit_Q: End of submit_quote x_return_status: '||x_return_status, 1, 'N');
1116: END IF;
1117:
1118: -- Debug Message
1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1120: THEN
1121: FND_MESSAGE.Set_Name('ASO', 'Submit Quote API: End');
1122: FND_MSG_PUB.Add;
1123: END IF;

Line 1122: FND_MSG_PUB.Add;

1118: -- Debug Message
1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1120: THEN
1121: FND_MESSAGE.Set_Name('ASO', 'Submit Quote API: End');
1122: FND_MSG_PUB.Add;
1123: END IF;
1124:
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_count => x_msg_count,

Line 1125: FND_MSG_PUB.Count_And_Get

1121: FND_MESSAGE.Set_Name('ASO', 'Submit Quote API: End');
1122: FND_MSG_PUB.Add;
1123: END IF;
1124:
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );
1129:

Line 1156: FND_MSG_PUB.Count_And_Get

1152: END;
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR ;
1155:
1156: FND_MSG_PUB.Count_And_Get
1157: ( p_count => x_msg_count,
1158: p_data => x_msg_data
1159: );
1160:

Line 1179: FND_MSG_PUB.Count_And_Get

1175: END;
1176:
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178:
1179: FND_MSG_PUB.Count_And_Get
1180: ( p_count => x_msg_count,
1181: p_data => x_msg_data
1182: );
1183:

Line 1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1198: END;
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME,
1206: l_api_name

Line 1204: FND_MSG_PUB.Add_Exc_Msg

1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME,
1206: l_api_name
1207: );
1208: END IF;

Line 1210: FND_MSG_PUB.Count_And_Get

1206: l_api_name
1207: );
1208: END IF;
1209:
1210: FND_MSG_PUB.Count_And_Get
1211: ( p_count => x_msg_count,
1212: p_data => x_msg_data
1213: );
1214: