DBA Data[Home] [Help]

APPS.ASO_PRICE_ADJ_RLTSHIP_PVT dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.initialize;

73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list )
76: THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80:
81: -- Initialize API return status to SUCCESS

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

106: -- Validate Environment
107: -- ******************************************************************
108: IF FND_GLOBAL.User_Id IS NULL
109: THEN
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
111: THEN
112: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
113: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
114: FND_MSG_PUB.ADD;

Line 114: FND_MSG_PUB.ADD;

110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
111: THEN
112: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
113: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
114: FND_MSG_PUB.ADD;
115: END IF;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:

Line 175: FND_MSG_PUB.Count_And_Get

171: END IF;
172:
173:
174: -- Standard call to get message count and if count is 1, get message info.
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179:

Line 202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

198: WHEN FND_API.G_EXC_ERROR THEN
199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
200: P_API_NAME => L_API_NAME
201: ,P_PKG_NAME => G_PKG_NAME
202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
204: ,X_MSG_COUNT => X_MSG_COUNT
205: ,X_MSG_DATA => X_MSG_DATA
206: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 212: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_API_NAME => L_API_NAME
211: ,P_PKG_NAME => G_PKG_NAME
212: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
214: ,X_MSG_COUNT => X_MSG_COUNT
215: ,X_MSG_DATA => X_MSG_DATA
216: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 312: FND_MSG_PUB.initialize;

308:
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_Boolean( p_init_msg_list )
311: THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314:
315:
316: -- Initialize API return status to SUCCESS

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

357: l_ref_PRICE_ADJ_RLTSHIP_rec.RLTD_PRICE_ADJ_ID ;
358:
359:
360: If ( C_Get_price_rltship%NOTFOUND) Then
361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
362: THEN
363: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
364: FND_MESSAGE.Set_Token ('INFO', 'price_adj_rltship', FALSE);
365: FND_MSG_PUB.Add;

Line 365: FND_MSG_PUB.Add;

361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
362: THEN
363: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
364: FND_MESSAGE.Set_Token ('INFO', 'price_adj_rltship', FALSE);
365: FND_MSG_PUB.Add;
366: END IF;
367: raise FND_API.G_EXC_ERROR;
368: END IF;
369: -- Debug Message

Line 370: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

366: END IF;
367: raise FND_API.G_EXC_ERROR;
368: END IF;
369: -- Debug Message
370: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
371: Close C_Get_price_rltship;
372:
373:
374:

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

373:
374:
375: If (l_tar_PRICE_ADJ_RLTSHIP_rec.last_update_date is NULL or
376: l_tar_PRICE_ADJ_RLTSHIP_rec.last_update_date = FND_API.G_MISS_Date ) Then
377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
380: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
381: FND_MSG_PUB.ADD;

Line 381: FND_MSG_PUB.ADD;

377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
380: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
381: FND_MSG_PUB.ADD;
382: END IF;
383: raise FND_API.G_EXC_ERROR;
384: End if;
385: -- Check Whether record has been changed by someone else

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

383: raise FND_API.G_EXC_ERROR;
384: End if;
385: -- Check Whether record has been changed by someone else
386: If (l_tar_PRICE_ADJ_RLTSHIP_rec.last_update_date <> l_ref_PRICE_ADJ_RLTSHIP_rec.last_update_date) Then
387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
388: THEN
389: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
390: FND_MESSAGE.Set_Token('INFO', 'price_adj_rltship', FALSE);
391: FND_MSG_PUB.ADD;

Line 391: FND_MSG_PUB.ADD;

387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
388: THEN
389: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
390: FND_MESSAGE.Set_Token('INFO', 'price_adj_rltship', FALSE);
391: FND_MSG_PUB.ADD;
392: END IF;
393: raise FND_API.G_EXC_ERROR;
394: End if;
395:

Line 417: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

413:
414: -- Hint: Add corresponding Master-Detail business logic here if necessary.
415:
416: -- Debug Message
417: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
418:
419: -- Invoke table handler
420: ASO_PRICE_RLTSHIPS_PKG.Update_row
421: (

Line 451: FND_MSG_PUB.Count_And_Get

447: END IF;
448:
449:
450: -- Standard call to get message count and if count is 1, get message info.
451: FND_MSG_PUB.Count_And_Get
452: ( p_count => x_msg_count,
453: p_data => x_msg_data
454: );
455:

Line 479: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

475: WHEN FND_API.G_EXC_ERROR THEN
476: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
477: P_API_NAME => L_API_NAME
478: ,P_PKG_NAME => G_PKG_NAME
479: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
480: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
481: ,X_MSG_COUNT => X_MSG_COUNT
482: ,X_MSG_DATA => X_MSG_DATA
483: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 489: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
487: P_API_NAME => L_API_NAME
488: ,P_PKG_NAME => G_PKG_NAME
489: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
490: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
491: ,X_MSG_COUNT => X_MSG_COUNT
492: ,X_MSG_DATA => X_MSG_DATA
493: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 573: FND_MSG_PUB.initialize;

569:
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF FND_API.to_Boolean( p_init_msg_list )
572: THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576:
577: -- Initialize API return status to SUCCESS

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

602: -- Validate Environment
603: -- ******************************************************************
604: IF FND_GLOBAL.User_Id IS NULL
605: THEN
606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
607: THEN
608: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
609: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
610: FND_MSG_PUB.ADD;

Line 610: FND_MSG_PUB.ADD;

606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
607: THEN
608: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
609: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
610: FND_MSG_PUB.ADD;
611: END IF;
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614:

Line 638: FND_MSG_PUB.Count_And_Get

634: END IF;
635:
636:
637: -- Standard call to get message count and if count is 1, get message info.
638: FND_MSG_PUB.Count_And_Get
639: ( p_count => x_msg_count,
640: p_data => x_msg_data
641: );
642:

Line 665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

661: WHEN FND_API.G_EXC_ERROR THEN
662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME
664: ,P_PKG_NAME => G_PKG_NAME
665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
667: ,X_MSG_COUNT => X_MSG_COUNT
668: ,X_MSG_DATA => X_MSG_DATA
669: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 675: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
673: P_API_NAME => L_API_NAME
674: ,P_PKG_NAME => G_PKG_NAME
675: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
676: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
677: ,X_MSG_COUNT => X_MSG_COUNT
678: ,X_MSG_DATA => X_MSG_DATA
679: ,X_RETURN_STATUS => X_RETURN_STATUS);