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_PS_POSTING_PVT dependencies on FND_MSG_PUB

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

4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Ps_Posting_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvpstb.pls';
6:
7: -- Hint: Primary key needs to be returned.
8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
11:
12: PROCEDURE Create_Ps_Posting(

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

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvpstb.pls';
6:
7: -- Hint: Primary key needs to be returned.
8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
11:
12: PROCEDURE Create_Ps_Posting(
13: p_api_version_number IN NUMBER,

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

6:
7: -- Hint: Primary key needs to be returned.
8: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
9: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
10: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
11:
12: PROCEDURE Create_Ps_Posting(
13: p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 61: FND_MSG_PUB.initialize;

57:
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF FND_API.to_Boolean( p_init_msg_list )
60: THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Debug Message
65: IF (AMS_DEBUG_HIGH_ON) THEN

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

135: l_tempchar := null;
136: END;
137:
138: IF (l_tempchar = 'X') THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
140: THEN
141: FND_MESSAGE.set_name('AMS','AMS_POST_NAME_NOT_UNIQUE');
142: FND_MSG_PUB.add;
143: END IF;

Line 142: FND_MSG_PUB.add;

138: IF (l_tempchar = 'X') THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
140: THEN
141: FND_MESSAGE.set_name('AMS','AMS_POST_NAME_NOT_UNIQUE');
142: FND_MSG_PUB.add;
143: END IF;
144: RAISE FND_API.g_exc_error;
145: END IF;
146:

Line 203: FND_MSG_PUB.Count_And_Get

199: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
200: END IF;
201:
202: -- Standard call to get message count and if count is 1, get message info.
203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207: EXCEPTION

Line 217: FND_MSG_PUB.Count_And_Get (

213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO CREATE_Ps_Posting_PVT;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: -- Standard call to get message count and if count=1, get the message
217: FND_MSG_PUB.Count_And_Get (
218: p_encoded => FND_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data
221: );

Line 227: FND_MSG_PUB.Count_And_Get (

223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO CREATE_Ps_Posting_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );

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

232:
233: WHEN OTHERS THEN
234: ROLLBACK TO CREATE_Ps_Posting_PVT;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
239: END IF;
240: -- Standard call to get message count and if count=1, get the message

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

234: ROLLBACK TO CREATE_Ps_Posting_PVT;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
239: END IF;
240: -- Standard call to get message count and if count=1, get the message
241: FND_MSG_PUB.Count_And_Get (
242: p_encoded => FND_API.G_FALSE,

Line 241: FND_MSG_PUB.Count_And_Get (

237: THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
239: END IF;
240: -- Standard call to get message count and if count=1, get the message
241: FND_MSG_PUB.Count_And_Get (
242: p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data
245: );

Line 287: FND_MSG_PUB.initialize;

283:
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: IF FND_API.to_Boolean( p_init_msg_list )
286: THEN
287: FND_MSG_PUB.initialize;
288: END IF;
289:
290: -- Debug Message
291: IF (AMS_DEBUG_HIGH_ON) THEN

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

391: WHERE posting_id = p_ps_posting_rec.posting_id
392: AND object_version_number = p_ps_posting_rec.object_version_number;
393:
394: IF (SQL%NOTFOUND) THEN
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
396: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
397: FND_MSG_PUB.add;
398: END IF;
399: RAISE FND_API.g_exc_error;

Line 397: FND_MSG_PUB.add;

393:
394: IF (SQL%NOTFOUND) THEN
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
396: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
397: FND_MSG_PUB.add;
398: END IF;
399: RAISE FND_API.g_exc_error;
400: END IF;
401:

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

415: l_tempchar := null;
416: END;
417:
418: IF (l_tempchar = 'X') THEN
419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
420: THEN
421: FND_MESSAGE.set_name('AMS','AMS_POST_NAME_NOT_UNIQUE');
422: FND_MSG_PUB.add;
423: END IF;

Line 422: FND_MSG_PUB.add;

418: IF (l_tempchar = 'X') THEN
419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
420: THEN
421: FND_MESSAGE.set_name('AMS','AMS_POST_NAME_NOT_UNIQUE');
422: FND_MSG_PUB.add;
423: END IF;
424: RAISE FND_API.g_exc_error;
425: END IF;
426:

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

435: WHERE posting_id = p_ps_posting_rec.posting_id
436: AND USERENV('LANG') IN (language, source_lang);
437:
438: IF (SQL%NOTFOUND) THEN
439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
440: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
441: FND_MSG_PUB.add;
442: END IF;
443: RAISE FND_API.g_exc_error;

Line 441: FND_MSG_PUB.add;

437:
438: IF (SQL%NOTFOUND) THEN
439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
440: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
441: FND_MSG_PUB.add;
442: END IF;
443: RAISE FND_API.g_exc_error;
444: END IF;
445:

Line 462: FND_MSG_PUB.Count_And_Get

458: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
459: END IF;
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get
463: (p_count => x_msg_count,
464: p_data => x_msg_data);
465:
466: EXCEPTION

Line 476: FND_MSG_PUB.Count_And_Get (

472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO UPDATE_Ps_Posting_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );

Line 486: FND_MSG_PUB.Count_And_Get (

482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO UPDATE_Ps_Posting_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );

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

491:
492: WHEN OTHERS THEN
493: ROLLBACK TO UPDATE_Ps_Posting_PVT;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message

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

493: ROLLBACK TO UPDATE_Ps_Posting_PVT;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,

Line 500: FND_MSG_PUB.Count_And_Get (

496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data
504: );

Line 559: FND_MSG_PUB.initialize;

555:
556: -- Initialize message list if p_init_msg_list is set to TRUE.
557: IF FND_API.to_Boolean( p_init_msg_list )
558: THEN
559: FND_MSG_PUB.initialize;
560: END IF;
561:
562: -- Debug Message
563: IF (AMS_DEBUG_HIGH_ON) THEN

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

585: DELETE FROM AMS_IBA_PS_POSTINGS_B
586: WHERE posting_id = p_posting_id;
587:
588: IF (SQL%NOTFOUND) THEN
589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
590: FND_MESSAGE.set_name('AMS','AMS_API_RECORD_NOT_FOUND');
591: FND_MSG_PUB.add;
592: END IF;
593: RAISE FND_API.g_exc_error;

Line 591: FND_MSG_PUB.add;

587:
588: IF (SQL%NOTFOUND) THEN
589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
590: FND_MESSAGE.set_name('AMS','AMS_API_RECORD_NOT_FOUND');
591: FND_MSG_PUB.add;
592: END IF;
593: RAISE FND_API.g_exc_error;
594: END IF;
595:

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

620: DELETE FROM AMS_IBA_PS_RULEGRPS_B
621: WHERE posting_id = p_posting_id;
622:
623: ELSE -- VERSIONS DON'T MATCH
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS','AMS_API_VERS_DONT_MATCH');
626: FND_MSG_PUB.add;
627: END IF;
628: RAISE FND_API.g_exc_error;

Line 626: FND_MSG_PUB.add;

622:
623: ELSE -- VERSIONS DON'T MATCH
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS','AMS_API_VERS_DONT_MATCH');
626: FND_MSG_PUB.add;
627: END IF;
628: RAISE FND_API.g_exc_error;
629: END IF;
630: ELSE -- IS USED

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

627: END IF;
628: RAISE FND_API.g_exc_error;
629: END IF;
630: ELSE -- IS USED
631: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
632: FND_MESSAGE.set_name('AMS','AMS_POSTING_IN_USE');
633: FND_MSG_PUB.add;
634: END IF;
635: RAISE FND_API.g_exc_error;

Line 633: FND_MSG_PUB.add;

629: END IF;
630: ELSE -- IS USED
631: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
632: FND_MESSAGE.set_name('AMS','AMS_POSTING_IN_USE');
633: FND_MSG_PUB.add;
634: END IF;
635: RAISE FND_API.g_exc_error;
636: END IF;
637:

Line 655: FND_MSG_PUB.Count_And_Get

651: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
652: END IF;
653:
654: -- Standard call to get message count and if count is 1, get message info.
655: FND_MSG_PUB.Count_And_Get
656: (p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659: EXCEPTION

Line 669: FND_MSG_PUB.Count_And_Get (

665: WHEN FND_API.G_EXC_ERROR THEN
666: ROLLBACK TO DELETE_Ps_Posting_PVT;
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: -- Standard call to get message count and if count=1, get the message
669: FND_MSG_PUB.Count_And_Get (
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );

Line 679: FND_MSG_PUB.Count_And_Get (

675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ROLLBACK TO DELETE_Ps_Posting_PVT;
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678: -- Standard call to get message count and if count=1, get the message
679: FND_MSG_PUB.Count_And_Get (
680: p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count,
682: p_data => x_msg_data
683: );

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

684:
685: WHEN OTHERS THEN
686: ROLLBACK TO DELETE_Ps_Posting_PVT;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
691: END IF;
692: -- Standard call to get message count and if count=1, get the message

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

686: ROLLBACK TO DELETE_Ps_Posting_PVT;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
691: END IF;
692: -- Standard call to get message count and if count=1, get the message
693: FND_MSG_PUB.Count_And_Get (
694: p_encoded => FND_API.G_FALSE,

Line 693: FND_MSG_PUB.Count_And_Get (

689: THEN
690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
691: END IF;
692: -- Standard call to get message count and if count=1, get the message
693: FND_MSG_PUB.Count_And_Get (
694: p_encoded => FND_API.G_FALSE,
695: p_count => x_msg_count,
696: p_data => x_msg_data
697: );

Line 739: FND_MSG_PUB.initialize;

735:
736: -- Initialize message list if p_init_msg_list is set to TRUE.
737: IF FND_API.to_Boolean( p_init_msg_list )
738: THEN
739: FND_MSG_PUB.initialize;
740: END IF;
741:
742: -- Standard call to check for call compatibility.
743: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

763: FETCH c_Ps_Posting INTO l_POSTING_ID;
764:
765: IF (c_Ps_Posting%NOTFOUND) THEN
766: CLOSE c_Ps_Posting;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
768: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
769: FND_MSG_PUB.add;
770: END IF;
771: RAISE FND_API.g_exc_error;

Line 769: FND_MSG_PUB.add;

765: IF (c_Ps_Posting%NOTFOUND) THEN
766: CLOSE c_Ps_Posting;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
768: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
769: FND_MSG_PUB.add;
770: END IF;
771: RAISE FND_API.g_exc_error;
772: END IF;
773:

Line 777: FND_MSG_PUB.count_and_get(

773:
774: CLOSE c_Ps_Posting;
775:
776: -------------------- finish --------------------------
777: FND_MSG_PUB.count_and_get(
778: p_encoded => FND_API.g_false,
779: p_count => x_msg_count,
780: p_data => x_msg_data);
781: IF (AMS_DEBUG_HIGH_ON) THEN

Line 795: FND_MSG_PUB.Count_And_Get (

791: WHEN FND_API.G_EXC_ERROR THEN
792: ROLLBACK TO LOCK_Ps_Posting_PVT;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data
799: );

Line 805: FND_MSG_PUB.Count_And_Get (

801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO LOCK_Ps_Posting_PVT;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: -- Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data
809: );

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

810:
811: WHEN OTHERS THEN
812: ROLLBACK TO LOCK_Ps_Posting_PVT;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
817: END IF;
818: -- Standard call to get message count and if count=1, get the message

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

812: ROLLBACK TO LOCK_Ps_Posting_PVT;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
817: END IF;
818: -- Standard call to get message count and if count=1, get the message
819: FND_MSG_PUB.Count_And_Get (
820: p_encoded => FND_API.G_FALSE,

Line 819: FND_MSG_PUB.Count_And_Get (

815: THEN
816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
817: END IF;
818: -- Standard call to get message count and if count=1, get the message
819: FND_MSG_PUB.Count_And_Get (
820: p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => x_msg_data
823: );

Line 948: FND_MSG_PUB.initialize;

944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF FND_API.to_Boolean( p_init_msg_list )
947: THEN
948: FND_MSG_PUB.initialize;
949: END IF;
950:
951: ---------------------- validate ------------------------
952: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 972: FND_MSG_PUB.count_and_get

968: AMS_Utility_PVT.debug_message(L_API_NAME || ': validation done');
969: END IF;
970:
971: -------------------- finish --------------------------
972: FND_MSG_PUB.count_and_get
973: (
974: p_encoded => FND_API.g_false,
975: p_count => x_msg_count,
976: p_data => x_msg_data

Line 989: FND_MSG_PUB.Count_And_Get (

985: WHEN FND_API.G_EXC_ERROR THEN
986: ROLLBACK TO VALIDATE_Ps_Posting_;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: -- Standard call to get message count and if count=1, get the message
989: FND_MSG_PUB.Count_And_Get (
990: p_encoded => FND_API.G_FALSE,
991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );

Line 999: FND_MSG_PUB.Count_And_Get (

995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO VALIDATE_Ps_Posting_;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: -- Standard call to get message count and if count=1, get the message
999: FND_MSG_PUB.Count_And_Get (
1000: p_encoded => FND_API.G_FALSE,
1001: p_count => x_msg_count,
1002: p_data => x_msg_data
1003: );

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

1004:
1005: WHEN OTHERS THEN
1006: ROLLBACK TO VALIDATE_Ps_Posting_;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1011: END IF;
1012: -- Standard call to get message count and if count=1, get the message

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

1006: ROLLBACK TO VALIDATE_Ps_Posting_;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1009: THEN
1010: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1011: END IF;
1012: -- Standard call to get message count and if count=1, get the message
1013: FND_MSG_PUB.Count_And_Get (
1014: p_encoded => FND_API.G_FALSE,

Line 1013: FND_MSG_PUB.Count_And_Get (

1009: THEN
1010: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1011: END IF;
1012: -- Standard call to get message count and if count=1, get the message
1013: FND_MSG_PUB.Count_And_Get (
1014: p_encoded => FND_API.G_FALSE,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );

Line 1033: FND_MSG_PUB.initialize;

1029: BEGIN
1030: -- Initialize message list if p_init_msg_list is set to TRUE.
1031: IF FND_API.to_Boolean( p_init_msg_list )
1032: THEN
1033: FND_MSG_PUB.initialize;
1034: END IF;
1035:
1036: -- Initialize API return status to SUCCESS
1037: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1050: FND_MSG_PUB.Count_And_Get

1046:
1047: AMS_UTILITY_PVT.debug_message('Private API: Validate_ps_Posting_rec');
1048: END IF;
1049: -- Standard call to get message count and if count is 1, get message info.
1050: FND_MSG_PUB.Count_And_Get
1051: (p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );
1054: END Validate_ps_posting_Rec;