eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMLIFT_PVT dependencies on FND_MSG_PUB

Line 34: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

30: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
31: ***/
32:
33: -- Hint: Primary key needs to be returned.
34: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
35: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
36: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
37:
38: PROCEDURE Lock_Dmlift(

Line 35: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

31: ***/
32:
33: -- Hint: Primary key needs to be returned.
34: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
35: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
36: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
37:
38: PROCEDURE Lock_Dmlift(
39: p_api_version IN NUMBER,

Line 36: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

32:
33: -- Hint: Primary key needs to be returned.
34: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
35: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
36: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
37:
38: PROCEDURE Lock_Dmlift(
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 74: FND_MSG_PUB.initialize;

70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

102: FETCH c_Dmlift INTO l_LIFT_ID;
103:
104: IF (c_Dmlift%NOTFOUND) THEN
105: CLOSE c_Dmlift;
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
107: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
108: FND_MSG_PUB.add;
109: END IF;
110: RAISE FND_API.g_exc_error;

Line 108: FND_MSG_PUB.add;

104: IF (c_Dmlift%NOTFOUND) THEN
105: CLOSE c_Dmlift;
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
107: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
108: FND_MSG_PUB.add;
109: END IF;
110: RAISE FND_API.g_exc_error;
111: END IF;
112:

Line 116: FND_MSG_PUB.count_and_get(

112:
113: CLOSE c_Dmlift;
114:
115: -------------------- finish --------------------------
116: FND_MSG_PUB.count_and_get(
117: p_encoded => FND_API.g_false,
118: p_count => x_msg_count,
119: p_data => x_msg_data);
120: IF (AMS_DEBUG_HIGH_ON) THEN

Line 128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

124: EXCEPTION
125:
126: WHEN AMS_Utility_PVT.resource_locked THEN
127: x_return_status := FND_API.g_ret_sts_error;
128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
129: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
130: FND_MSG_PUB.add;
131: END IF;
132:

Line 130: FND_MSG_PUB.add;

126: WHEN AMS_Utility_PVT.resource_locked THEN
127: x_return_status := FND_API.g_ret_sts_error;
128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
129: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
130: FND_MSG_PUB.add;
131: END IF;
132:
133: WHEN FND_API.G_EXC_ERROR THEN
134: ROLLBACK TO LOCK_Dmlift_PVT;

Line 137: FND_MSG_PUB.Count_And_Get (

133: WHEN FND_API.G_EXC_ERROR THEN
134: ROLLBACK TO LOCK_Dmlift_PVT;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: -- Standard call to get message count and if count=1, get the message
137: FND_MSG_PUB.Count_And_Get (
138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data
141: );

Line 147: FND_MSG_PUB.Count_And_Get (

143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: ROLLBACK TO LOCK_Dmlift_PVT;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: -- Standard call to get message count and if count=1, get the message
147: FND_MSG_PUB.Count_And_Get (
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,
150: p_data => x_msg_data
151: );

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

152:
153: WHEN OTHERS THEN
154: ROLLBACK TO LOCK_Dmlift_PVT;
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: THEN
158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
159: END IF;
160: -- Standard call to get message count and if count=1, get the message

Line 158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

154: ROLLBACK TO LOCK_Dmlift_PVT;
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: THEN
158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
159: END IF;
160: -- Standard call to get message count and if count=1, get the message
161: FND_MSG_PUB.Count_And_Get (
162: p_encoded => FND_API.G_FALSE,

Line 161: FND_MSG_PUB.Count_And_Get (

157: THEN
158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
159: END IF;
160: -- Standard call to get message count and if count=1, get the message
161: FND_MSG_PUB.Count_And_Get (
162: p_encoded => FND_API.G_FALSE,
163: p_count => x_msg_count,
164: p_data => x_msg_data
165: );

Line 219: FND_MSG_PUB.initialize;

215:
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list )
218: THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: IF (AMS_DEBUG_HIGH_ON) THEN

Line 324: FND_MSG_PUB.Count_And_Get

320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
321: END IF;
322:
323: -- Standard call to get message count and if count is 1, get message info.
324: FND_MSG_PUB.Count_And_Get
325: (p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328: EXCEPTION

Line 332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

328: EXCEPTION
329:
330: WHEN AMS_Utility_PVT.resource_locked THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
334: FND_MSG_PUB.add;
335: END IF;
336:

Line 334: FND_MSG_PUB.add;

330: WHEN AMS_Utility_PVT.resource_locked THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
334: FND_MSG_PUB.add;
335: END IF;
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO Create_Lift_PVT;

Line 341: FND_MSG_PUB.Count_And_Get (

337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO Create_Lift_PVT;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: -- Standard call to get message count and if count=1, get the message
341: FND_MSG_PUB.Count_And_Get (
342: p_encoded => FND_API.G_FALSE,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );

Line 351: FND_MSG_PUB.Count_And_Get (

347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: ROLLBACK TO Create_Lift_PVT;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: -- Standard call to get message count and if count=1, get the message
351: FND_MSG_PUB.Count_And_Get (
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_msg_count,
354: p_data => x_msg_data
355: );

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

356:
357: WHEN OTHERS THEN
358: ROLLBACK TO Create_Lift_PVT;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
363: END IF;
364: -- Standard call to get message count and if count=1, get the message

Line 362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

358: ROLLBACK TO Create_Lift_PVT;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
363: END IF;
364: -- Standard call to get message count and if count=1, get the message
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,

Line 365: FND_MSG_PUB.Count_And_Get (

361: THEN
362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
363: END IF;
364: -- Standard call to get message count and if count=1, get the message
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => x_msg_count,
368: p_data => x_msg_data
369: );

Line 418: FND_MSG_PUB.initialize;

414:
415: -- Initialize message list if p_init_msg_list is set to TRUE.
416: IF FND_API.to_Boolean( p_init_msg_list )
417: THEN
418: FND_MSG_PUB.initialize;
419: END IF;
420:
421: -- Debug Message
422: IF (AMS_DEBUG_HIGH_ON) THEN

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

438:
439: FETCH c_get_Dmlift INTO l_ref_Lift_rec ;
440:
441: If ( c_get_Dmlift%NOTFOUND) THEN
442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
445: FND_MESSAGE.Set_Token ('INFO', 'Dmlift', FALSE);
446: FND_MSG_PUB.Add;

Line 446: FND_MSG_PUB.Add;

442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
445: FND_MESSAGE.Set_Token ('INFO', 'Dmlift', FALSE);
446: FND_MSG_PUB.Add;
447: END IF;
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450: -- Debug Message

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

455: CLOSE c_get_Dmlift;
456:
457: -- Check Whether record has been changed by someone else
458: If (l_tar_Lift_rec.object_version_number <> l_ref_Lift_rec.object_version_number) Then
459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
462: FND_MESSAGE.Set_Token('INFO', 'Dmlift', FALSE);
463: FND_MSG_PUB.ADD;

Line 463: FND_MSG_PUB.ADD;

459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
462: FND_MESSAGE.Set_Token('INFO', 'Dmlift', FALSE);
463: FND_MSG_PUB.ADD;
464: END IF;
465: raise FND_API.G_EXC_ERROR;
466: End if;
467: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 495: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

491:
492: -- Debug Message
493: IF (AMS_DEBUG_HIGH_ON) THEN
494:
495: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
496: END IF;
497:
498: -- Invoke table handler(AMS_DM_LIFT_PKG.Update_Row)
499: BEGIN

Line 542: FND_MSG_PUB.Count_And_Get

538: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
539: END IF;
540:
541: -- Standard call to get message count and if count is 1, get message info.
542: FND_MSG_PUB.Count_And_Get
543: (p_count => x_msg_count,
544: p_data => x_msg_data
545: );
546: EXCEPTION

Line 550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

546: EXCEPTION
547:
548: WHEN AMS_Utility_PVT.resource_locked THEN
549: x_return_status := FND_API.g_ret_sts_error;
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
551: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
552: FND_MSG_PUB.add;
553: END IF;
554:

Line 552: FND_MSG_PUB.add;

548: WHEN AMS_Utility_PVT.resource_locked THEN
549: x_return_status := FND_API.g_ret_sts_error;
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
551: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
552: FND_MSG_PUB.add;
553: END IF;
554:
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Update_Lift_PVT;

Line 559: FND_MSG_PUB.Count_And_Get (

555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Update_Lift_PVT;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
563: );

Line 569: FND_MSG_PUB.Count_And_Get (

565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Update_Lift_PVT;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );

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

574:
575: WHEN OTHERS THEN
576: ROLLBACK TO Update_Lift_PVT;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message

Line 580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

576: ROLLBACK TO Update_Lift_PVT;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,

Line 583: FND_MSG_PUB.Count_And_Get (

579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data
587: );

Line 624: FND_MSG_PUB.initialize;

620:
621: -- Initialize message list if p_init_msg_list is set to TRUE.
622: IF FND_API.to_Boolean( p_init_msg_list )
623: THEN
624: FND_MSG_PUB.initialize;
625: END IF;
626:
627: -- Debug Message
628: IF (AMS_DEBUG_HIGH_ON) THEN

Line 673: FND_MSG_PUB.Count_And_Get

669: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
670: END IF;
671:
672: -- Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get
674: (p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677: EXCEPTION

Line 681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

677: EXCEPTION
678:
679: WHEN AMS_Utility_PVT.resource_locked THEN
680: x_return_status := FND_API.g_ret_sts_error;
681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
682: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
683: FND_MSG_PUB.add;
684: END IF;
685:

Line 683: FND_MSG_PUB.add;

679: WHEN AMS_Utility_PVT.resource_locked THEN
680: x_return_status := FND_API.g_ret_sts_error;
681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
682: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
683: FND_MSG_PUB.add;
684: END IF;
685:
686: WHEN FND_API.G_EXC_ERROR THEN
687: ROLLBACK TO Delete_Lift_PVT;

Line 690: FND_MSG_PUB.Count_And_Get (

686: WHEN FND_API.G_EXC_ERROR THEN
687: ROLLBACK TO Delete_Lift_PVT;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_msg_count,
693: p_data => x_msg_data
694: );

Line 700: FND_MSG_PUB.Count_And_Get (

696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO Delete_Lift_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data
704: );

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

705:
706: WHEN OTHERS THEN
707: ROLLBACK TO Delete_Lift_PVT;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
712: END IF;
713: -- Standard call to get message count and if count=1, get the message

Line 711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

707: ROLLBACK TO Delete_Lift_PVT;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
712: END IF;
713: -- Standard call to get message count and if count=1, get the message
714: FND_MSG_PUB.Count_And_Get (
715: p_encoded => FND_API.G_FALSE,

Line 714: FND_MSG_PUB.Count_And_Get (

710: THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
712: END IF;
713: -- Standard call to get message count and if count=1, get the message
714: FND_MSG_PUB.Count_And_Get (
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data
718: );

Line 745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

741: );
742: END IF;
743:
744: IF l_valid_flag = FND_API.g_false THEN
745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
746: THEN
747: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_ID_DUPLICATE');
748: FND_MSG_PUB.add;
749: END IF;

Line 748: FND_MSG_PUB.add;

744: IF l_valid_flag = FND_API.g_false THEN
745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
746: THEN
747: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_ID_DUPLICATE');
748: FND_MSG_PUB.add;
749: END IF;
750: x_return_status := FND_API.g_ret_sts_error;
751: RETURN;
752: END IF;

Line 767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

763: x_return_status := FND_API.g_ret_sts_success;
764:
765: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
766: IF p_Lift_rec.MODEL_ID = FND_API.g_miss_num OR p_Lift_rec.MODEL_ID IS NULL THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
768: THEN
769: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_MODEL_ID');
770: FND_MSG_PUB.add;
771: END IF;

Line 770: FND_MSG_PUB.add;

766: IF p_Lift_rec.MODEL_ID = FND_API.g_miss_num OR p_Lift_rec.MODEL_ID IS NULL THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
768: THEN
769: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_MODEL_ID');
770: FND_MSG_PUB.add;
771: END IF;
772: x_return_status := FND_API.g_ret_sts_error;
773: END IF;
774:

Line 777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

773: END IF;
774:
775:
776: IF p_Lift_rec.QUANTILE = FND_API.g_miss_num OR p_Lift_rec.QUANTILE IS NULL THEN
777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
778: THEN
779: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_QUANTILE');
780: FND_MSG_PUB.add;
781: END IF;

Line 780: FND_MSG_PUB.add;

776: IF p_Lift_rec.QUANTILE = FND_API.g_miss_num OR p_Lift_rec.QUANTILE IS NULL THEN
777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
778: THEN
779: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_QUANTILE');
780: FND_MSG_PUB.add;
781: END IF;
782: x_return_status := FND_API.g_ret_sts_error;
783: END IF;
784:

Line 787: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

783: END IF;
784:
785:
786: IF p_Lift_rec.LIFT = FND_API.g_miss_num OR p_Lift_rec.LIFT IS NULL THEN
787: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
788: THEN
789: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_LIFT');
790: FND_MSG_PUB.add;
791: END IF;

Line 790: FND_MSG_PUB.add;

786: IF p_Lift_rec.LIFT = FND_API.g_miss_num OR p_Lift_rec.LIFT IS NULL THEN
787: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
788: THEN
789: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_LIFT');
790: FND_MSG_PUB.add;
791: END IF;
792: x_return_status := FND_API.g_ret_sts_error;
793: END IF;
794: ELSE

Line 798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

794: ELSE
795:
796:
797: IF p_Lift_rec.LIFT_ID IS NULL THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
799: THEN
800: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_LIFT_ID');
801: FND_MSG_PUB.add;
802: END IF;

Line 801: FND_MSG_PUB.add;

797: IF p_Lift_rec.LIFT_ID IS NULL THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
799: THEN
800: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_LIFT_ID');
801: FND_MSG_PUB.add;
802: END IF;
803: x_return_status := FND_API.g_ret_sts_error;
804: END IF;
805:

Line 808: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

804: END IF;
805:
806:
807: IF p_Lift_rec.OBJECT_VERSION_NUMBER IS NULL THEN
808: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
809: THEN
810: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_OBJECT_VERSION');
811: FND_MSG_PUB.add;
812: END IF;

Line 811: FND_MSG_PUB.add;

807: IF p_Lift_rec.OBJECT_VERSION_NUMBER IS NULL THEN
808: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
809: THEN
810: FND_MESSAGE.set_name('AMS', 'AMS_LIFT_NO_OBJECT_VERSION');
811: FND_MSG_PUB.add;
812: END IF;
813: x_return_status := FND_API.g_ret_sts_error;
814: END IF;
815:

Line 818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

814: END IF;
815:
816:
817: IF p_Lift_rec.MODEL_ID IS NULL THEN
818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
819: THEN
820: FND_MESSAGE.set_name('AMS', 'AMS_Lift_NO_MODEL_ID');
821: FND_MSG_PUB.add;
822: END IF;

Line 821: FND_MSG_PUB.add;

817: IF p_Lift_rec.MODEL_ID IS NULL THEN
818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
819: THEN
820: FND_MESSAGE.set_name('AMS', 'AMS_Lift_NO_MODEL_ID');
821: FND_MSG_PUB.add;
822: END IF;
823: x_return_status := FND_API.g_ret_sts_error;
824: END IF;
825:

Line 828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

824: END IF;
825:
826:
827: IF p_Lift_rec.QUANTILE IS NULL THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
829: THEN
830: FND_MESSAGE.set_name('AMS', 'AMS_Lift_NO_QUANTILE');
831: FND_MSG_PUB.add;
832: END IF;

Line 831: FND_MSG_PUB.add;

827: IF p_Lift_rec.QUANTILE IS NULL THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
829: THEN
830: FND_MESSAGE.set_name('AMS', 'AMS_Lift_NO_QUANTILE');
831: FND_MSG_PUB.add;
832: END IF;
833: x_return_status := FND_API.g_ret_sts_error;
834: END IF;
835:

Line 838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

834: END IF;
835:
836:
837: IF p_Lift_rec.LIFT IS NULL THEN
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
839: THEN
840: FND_MESSAGE.set_name('AMS', 'AMS_Lift_NO_LIFT');
841: FND_MSG_PUB.add;
842: END IF;

Line 841: FND_MSG_PUB.add;

837: IF p_Lift_rec.LIFT IS NULL THEN
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
839: THEN
840: FND_MESSAGE.set_name('AMS', 'AMS_Lift_NO_LIFT');
841: FND_MSG_PUB.add;
842: END IF;
843: x_return_status := FND_API.g_ret_sts_error;
844: END IF;
845: END IF;

Line 976: FND_MSG_PUB.initialize;

972:
973: -- Initialize message list if p_init_msg_list is set to TRUE.
974: IF FND_API.to_Boolean( p_init_msg_list )
975: THEN
976: FND_MSG_PUB.initialize;
977: END IF;
978: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
979: Check_Lift_Items(
980: p_Lift_rec => p_Lift_rec,

Line 1032: FND_MSG_PUB.Count_And_Get

1028: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1029: END IF;
1030:
1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get
1033: (p_count => x_msg_count,
1034: p_data => x_msg_data
1035: );
1036: EXCEPTION

Line 1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1036: EXCEPTION
1037:
1038: WHEN AMS_Utility_PVT.resource_locked THEN
1039: x_return_status := FND_API.g_ret_sts_error;
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1041: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1042: FND_MSG_PUB.add;
1043: END IF;
1044:

Line 1042: FND_MSG_PUB.add;

1038: WHEN AMS_Utility_PVT.resource_locked THEN
1039: x_return_status := FND_API.g_ret_sts_error;
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1041: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1042: FND_MSG_PUB.add;
1043: END IF;
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1048: FND_MSG_PUB.Count_And_Get (

1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: -- Standard call to get message count and if count=1, get the message
1048: FND_MSG_PUB.Count_And_Get (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1052: );

Line 1057: FND_MSG_PUB.Count_And_Get (

1053:
1054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: -- Standard call to get message count and if count=1, get the message
1057: FND_MSG_PUB.Count_And_Get (
1058: p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );

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

1061: );
1062:
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message

Line 1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message
1070: FND_MSG_PUB.Count_And_Get (
1071: p_encoded => FND_API.G_FALSE,

Line 1070: FND_MSG_PUB.Count_And_Get (

1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message
1070: FND_MSG_PUB.Count_And_Get (
1071: p_encoded => FND_API.G_FALSE,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data
1074: );

Line 1091: FND_MSG_PUB.initialize;

1087: BEGIN
1088: -- Initialize message list if p_init_msg_list is set to TRUE.
1089: IF FND_API.to_Boolean( p_init_msg_list )
1090: THEN
1091: FND_MSG_PUB.initialize;
1092: END IF;
1093:
1094: -- Initialize API return status to SUCCESS
1095: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1108: FND_MSG_PUB.Count_And_Get

1104:
1105: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1106: END IF;
1107: -- Standard call to get message count and if count is 1, get message info.
1108: FND_MSG_PUB.Count_And_Get
1109: (p_count => x_msg_count,
1110: p_data => x_msg_data
1111: );
1112: END Validate_Lift_Rec;