DBA Data[Home] [Help]

APPS.ASO_CREDIT_CHECK_PVT dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.initialize;

65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.to_Boolean( p_init_msg_list )
68: THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72:
73:

Line 94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

90: -- Validate Environment
91: -- ******************************************************************
92: IF FND_GLOBAL.User_Id IS NULL
93: THEN
94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
95: THEN
96: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_CANNOT_GET_PROFILE_VALUE');
97: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
98: FND_MSG_PUB.ADD;

Line 98: FND_MSG_PUB.ADD;

94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
95: THEN
96: FND_MESSAGE.Set_Name(' + appShortName +', 'ASO_CANNOT_GET_PROFILE_VALUE');
97: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
98: FND_MSG_PUB.ADD;
99: END IF;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:

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

138: aso_debug_pub.add(' Credit Check Lock Exists : x_status '||NVL(x_status,'null'), 1, 'Y');
139: END IF;
140:
141: IF (x_status = FND_API.G_TRUE) THEN
142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
143: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
144: FND_MSG_PUB.ADD;
145: END IF;
146: RAISE FND_API.G_EXC_ERROR;

Line 144: FND_MSG_PUB.ADD;

140:
141: IF (x_status = FND_API.G_TRUE) THEN
142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
143: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
144: FND_MSG_PUB.ADD;
145: END IF;
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:

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

161: WHEN OTHERS THEN
162: IF aso_debug_pub.g_debug_flag = 'Y' THEN
163: aso_debug_pub.add('Exception ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');
164: END IF;
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
166: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
167: FND_MESSAGE.Set_Token('COLUMN', 'Quote_header_id', FALSE);
168: FND_MESSAGE.Set_Token('VALUE', l_qte_header_rec.quote_header_id, FALSE);
169: FND_MSG_PUB.ADD;

Line 169: FND_MSG_PUB.ADD;

165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
166: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
167: FND_MESSAGE.Set_Token('COLUMN', 'Quote_header_id', FALSE);
168: FND_MESSAGE.Set_Token('VALUE', l_qte_header_rec.quote_header_id, FALSE);
169: FND_MSG_PUB.ADD;
170: END IF;
171: raise FND_API.G_EXC_ERROR;
172: END;
173: ELSE

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

223: END IF;
224:
225:
226: IF ( C_functional_currency%NOTFOUND) Then
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
228: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_GL_CURRENCY');
229: FND_MSG_PUB.ADD;
230: END IF;
231: raise FND_API.G_EXC_ERROR;

Line 229: FND_MSG_PUB.ADD;

225:
226: IF ( C_functional_currency%NOTFOUND) Then
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
228: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_GL_CURRENCY');
229: FND_MSG_PUB.ADD;
230: END IF;
231: raise FND_API.G_EXC_ERROR;
232: END IF;
233:

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

232: END IF;
233:
234: CLOSE C_functional_currency;
235: ELSE
236: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
237: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_OE_PROFILE');
238: FND_MSG_PUB.ADD;
239: END IF;
240: raise FND_API.G_EXC_ERROR;

Line 238: FND_MSG_PUB.ADD;

234: CLOSE C_functional_currency;
235: ELSE
236: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
237: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_OE_PROFILE');
238: FND_MSG_PUB.ADD;
239: END IF;
240: raise FND_API.G_EXC_ERROR;
241: END IF;
242:

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

262:
263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR
264: NVL(l_site_use_id ,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
265: THEN
266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
267: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_BILLTO_INFO');
268: FND_MSG_PUB.ADD;
269: END IF;
270: raise FND_API.G_EXC_ERROR;

Line 268: FND_MSG_PUB.ADD;

264: NVL(l_site_use_id ,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
265: THEN
266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
267: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_BILLTO_INFO');
268: FND_MSG_PUB.ADD;
269: END IF;
270: raise FND_API.G_EXC_ERROR;
271: END IF;
272:

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

285: aso_debug_pub.add('Include Freight Charges Flag : '||NVL(l_incl_freight_charges_flag,'null'), 1, 'Y');
286: END IF;
287:
288: IF ( C_credit_check_flag%NOTFOUND) Then
289: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
290: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_TAX_FREIGHT_INFO');
291: FND_MSG_PUB.ADD;
292: END IF;
293: raise FND_API.G_EXC_ERROR;

Line 291: FND_MSG_PUB.ADD;

287:
288: IF ( C_credit_check_flag%NOTFOUND) Then
289: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
290: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_TAX_FREIGHT_INFO');
291: FND_MSG_PUB.ADD;
292: END IF;
293: raise FND_API.G_EXC_ERROR;
294: END IF;
295:

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

341: aso_debug_pub.add('After OM Public API call - msg data :'||nvl(x_msg_data,'null'), 1, 'Y');
342: END IF;
343: -- Check return status from the above procedure call
344: IF x_return_status = FND_API.G_RET_STS_ERROR then
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: oe_msg_pub.count_and_get( p_encoded => 'F'
347: , p_count => x_msg_count
348: , p_data => x_msg_data);
349: for k in 1 .. x_msg_count loop

Line 357: FND_MSG_PUB.ADD;

353: aso_debug_pub.add('k='||k||'.OM error Message :'||nvl(x_msg_data,'null'), 1, 'Y');
354: END IF;
355: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
356: FND_MESSAGE.Set_Token('MSG_TXT', x_msg_data, FALSE);
357: FND_MSG_PUB.ADD;
358: end loop;
359: END IF;
360: raise FND_API.G_EXC_ERROR;
361: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

358: end loop;
359: END IF;
360: raise FND_API.G_EXC_ERROR;
361: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
363: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
364: FND_MESSAGE.Set_Token('ROW', 'ASO_CREDIT_CHECK_PVT AFTER OM CALL', TRUE);
365: FND_MSG_PUB.ADD;
366: END IF;

Line 365: FND_MSG_PUB.ADD;

361: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
363: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
364: FND_MESSAGE.Set_Token('ROW', 'ASO_CREDIT_CHECK_PVT AFTER OM CALL', TRUE);
365: FND_MSG_PUB.ADD;
366: END IF;
367: raise FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: ELSE

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

366: END IF;
367: raise FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: ELSE
370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
371: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
372: FND_MESSAGE.Set_Token('COLUMN', 'Internal Credit Check Required ', FALSE);
373: FND_MSG_PUB.ADD;
374: END IF;

Line 373: FND_MSG_PUB.ADD;

369: ELSE
370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
371: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
372: FND_MESSAGE.Set_Token('COLUMN', 'Internal Credit Check Required ', FALSE);
373: FND_MSG_PUB.ADD;
374: END IF;
375: raise FND_API.G_EXC_ERROR;
376: END IF; -- Missing Values Check
377:

Line 394: FND_MSG_PUB.Count_And_Get

390:
391:
392:
393: -- Standard call to get message count and if count is 1, get message info.
394: FND_MSG_PUB.Count_And_Get
395: ( p_count => x_msg_count,
396: p_data => x_msg_data
397: );
398:

Line 404: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

400: WHEN FND_API.G_EXC_ERROR THEN
401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
406: ,P_SQLCODE => SQLCODE
407: ,P_SQLERRM => SQLERRM
408: ,X_MSG_COUNT => X_MSG_COUNT

Line 416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME
415: ,P_PKG_NAME => G_PKG_NAME
416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
417: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
418: ,P_SQLCODE => SQLCODE
419: ,P_SQLERRM => SQLERRM
420: ,X_MSG_COUNT => X_MSG_COUNT