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.AML_TIMEFRAME_PVT dependencies on FND_MSG_PUB

Line 16: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amlvtfrb.pls';
13:
14:
15: -- Hint: Primary key needs to be returned.
16: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
20:

Line 17: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

13:
14:
15: -- Hint: Primary key needs to be returned.
16: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
20:
21: PROCEDURE Create_timeframe(

Line 18: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

14:
15: -- Hint: Primary key needs to be returned.
16: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
20:
21: PROCEDURE Create_timeframe(
22: P_Api_Version_Number IN NUMBER,

Line 19: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

15: -- Hint: Primary key needs to be returned.
16: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
20:
21: PROCEDURE Create_timeframe(
22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 71: FND_MSG_PUB.initialize;

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

Line 78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

74:
75: -- Debug Message
76: IF (AS_DEBUG_LOW_ON) THEN
77:
78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
79: END IF;
80:
81:
82: -- Initialize API return status to SUCCESS

Line 103: FND_MSG_PUB.Add;

99: CLOSE c1;
100: --dbms_output.put_line('duplicate found ');
101: FND_MESSAGE.SET_NAME('AS', 'AS_DUPE_TIMEFRAME');
102: -- Add message to API message list
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106: CLOSE c1;
107:

Line 116: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

112:
113: -- Debug message
114: IF (AS_DEBUG_LOW_ON) THEN
115:
116: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
117: 'Pvt API: ' || l_timeframe_rec.DECISION_TIMEFRAME_CODE);
118: END IF;
119:
120:

Line 153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

149:
150: -- Debug Message
151: IF (AS_DEBUG_LOW_ON) THEN
152:
153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
154: 'Private API: Calling create table handler');
155: END IF;
156:
157: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row)

Line 193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

189:
190: -- Debug Message
191: IF (AS_DEBUG_LOW_ON) THEN
192:
193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
194: END IF;
195:
196:
197: -- Standard call to get message count and if count is 1, get message info.

Line 198: FND_MSG_PUB.Count_And_Get

194: END IF;
195:
196:
197: -- Standard call to get message count and if count is 1, get message info.
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:

Line 208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

204: WHEN FND_API.G_EXC_ERROR THEN
205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
209: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
210: ,X_MSG_COUNT => X_MSG_COUNT
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 299: FND_MSG_PUB.initialize;

295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean( p_init_msg_list )
298: THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302:
303: -- Debug Message

Line 306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

302:
303: -- Debug Message
304: IF (AS_DEBUG_LOW_ON) THEN
305:
306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
307: END IF;
308:
309:
310:

Line 322: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

318:
319: -- Debug Message
320: IF (AS_DEBUG_LOW_ON) THEN
321:
322: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
323: 'Private API: - Open Cursor to Select');
324: END IF;
325:
326:

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

325:
326:
327: If (l_tar_timeframe_rec.last_update_date is NULL or
328: l_tar_timeframe_rec.last_update_date = FND_API.G_MISS_Date ) Then
329: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
330: THEN
331: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
332: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
333: FND_MSG_PUB.ADD;

Line 333: FND_MSG_PUB.ADD;

329: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
330: THEN
331: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
332: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
333: FND_MSG_PUB.ADD;
334: END IF;
335: raise FND_API.G_EXC_ERROR;
336: End if;
337: -- Check Whether record has been changed by someone else

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

335: raise FND_API.G_EXC_ERROR;
336: End if;
337: -- Check Whether record has been changed by someone else
338: If (l_tar_timeframe_rec.last_update_date <> l_ref_timeframe_rec.last_update_date) Then
339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
340: THEN
341: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
342: FND_MESSAGE.Set_Token('INFO', 'timeframe', FALSE);
343: FND_MSG_PUB.ADD;

Line 343: FND_MSG_PUB.ADD;

339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
340: THEN
341: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
342: FND_MESSAGE.Set_Token('INFO', 'timeframe', FALSE);
343: FND_MSG_PUB.ADD;
344: END IF;
345: raise FND_API.G_EXC_ERROR;
346: End if;
347:

Line 351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

347:
348: -- Debug message
349: IF (AS_DEBUG_LOW_ON) THEN
350:
351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
352: 'Private API: Validate_timeframe');
353: END IF;
354:
355: -- Invoke validation procedures

Line 368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

364: IF (AS_DEBUG_LOW_ON) THEN
365:
366:
367:
368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
369: 'Private API: Validate_timeframe');
370:
371: END IF;
372:

Line 413: FND_MSG_PUB.Add;

409: CLOSE c1;
410: --dbms_output.put_line('duplicate found ');
411: FND_MESSAGE.SET_NAME('AS', 'AS_DUPE_TIMEFRAME');
412: -- Add message to API message list
413: FND_MSG_PUB.Add;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: CLOSE c1;
417:

Line 426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

422:
423: -- Debug Message
424: IF (AS_DEBUG_LOW_ON) THEN
425:
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
427: 'Private API: Calling update table handler');
428: END IF;
429:
430: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row)

Line 458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

454:
455: -- Debug Message
456: IF (AS_DEBUG_LOW_ON) THEN
457:
458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
459: END IF;
460:
461:
462: -- Standard call to get message count and if count is 1, get message info.

Line 463: FND_MSG_PUB.Count_And_Get

459: END IF;
460:
461:
462: -- Standard call to get message count and if count is 1, get message info.
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467:

Line 473: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

469: WHEN FND_API.G_EXC_ERROR THEN
470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
474: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
475: ,X_MSG_COUNT => X_MSG_COUNT
476: ,X_MSG_DATA => X_MSG_DATA
477: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
481: P_API_NAME => L_API_NAME
482: ,P_PKG_NAME => G_PKG_NAME
483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
484: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
485: ,X_MSG_COUNT => X_MSG_COUNT
486: ,X_MSG_DATA => X_MSG_DATA
487: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 542: FND_MSG_PUB.initialize;

538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.
540: IF FND_API.to_Boolean( p_init_msg_list )
541: THEN
542: FND_MSG_PUB.initialize;
543: END IF;
544:
545:
546: -- Debug Message

Line 549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

545:
546: -- Debug Message
547: IF (AS_DEBUG_LOW_ON) THEN
548:
549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
550: END IF;
551:
552:
553: -- Initialize API return status to SUCCESS

Line 565: FND_MSG_PUB.Add;

561:
562: if (p_timeframe_rec.TIMEFRAME_ID < 10000) then
563: FND_MESSAGE.SET_NAME('AS', 'AS_SEEDED_TIMEFRAME_NO_DELETE');
564: -- Add message to API message list
565: FND_MSG_PUB.Add;
566: RAISE FND_API.G_EXC_ERROR;
567:
568: end if;
569:

Line 575: FND_MSG_PUB.Add;

571:
572: if (p_timeframe_rec.ENABLED_FLAG = 'Y') then
573: FND_MESSAGE.SET_NAME('AS', 'AS_ENABLED_TIMEFRAME_NO_DELETE');
574: -- Add message to API message list
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR;
577:
578: end if;
579:

Line 584: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

580:
581: -- Debug Message
582: IF (AS_DEBUG_LOW_ON) THEN
583:
584: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row)

Line 605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

601:
602: -- Debug Message
603: IF (AS_DEBUG_LOW_ON) THEN
604:
605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
606: END IF;
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.

Line 610: FND_MSG_PUB.Count_And_Get

606: END IF;
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: ( p_count => x_msg_count,
612: p_data => x_msg_data
613: );
614:

Line 620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

616: WHEN FND_API.G_EXC_ERROR THEN
617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
631: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MSG_DATA
634: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 666: FND_MSG_PUB.initialize;

662:
663: -- Initialize message list if p_init_msg_list is set to TRUE.
664: IF FND_API.to_Boolean( p_init_msg_list )
665: THEN
666: FND_MSG_PUB.initialize;
667: END IF;
668:
669:
670: -- Initialize API return status to SUCCESS

Line 690: FND_MSG_PUB.Count_And_Get

686: NULL;
687: END IF;
688:
689: -- Standard call to get message count and if count is 1, get message info.
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => x_msg_count,
692: p_data => x_msg_data
693: );
694:

Line 723: FND_MSG_PUB.initialize;

719:
720: -- Initialize message list if p_init_msg_list is set to TRUE.
721: IF FND_API.to_Boolean( p_init_msg_list )
722: THEN
723: FND_MSG_PUB.initialize;
724: END IF;
725:
726:
727: -- Initialize API return status to SUCCESS

Line 739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

735:
736: IF C_Lookup_Exists%NOTFOUND
737: THEN
738: AS_UTILITY_PVT.Set_Message(
739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: p_msg_name => 'API_INVALID_ID',
741: p_token1 => 'COLUMN',
742: p_token1_value => 'DECISION TIMEFRAME_CODE',
743: p_token2 => 'VALUE',

Line 755: FND_MSG_PUB.Count_And_Get

751:
752:
753:
754: -- Standard call to get message count and if count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data
758: );
759:

Line 778: FND_MSG_PUB.initialize;

774:
775: -- Initialize message list if p_init_msg_list is set to TRUE.
776: IF FND_API.to_Boolean( p_init_msg_list )
777: THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:
781:
782: -- Initialize API return status to SUCCESS

Line 789: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

785: IF (p_timeframe_days is NOT NULL
786: AND p_timeframe_days < 0 ) THEN
787:
788: AS_UTILITY_PVT.Set_Message(
789: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
790: p_msg_name => 'API_INVALID_ID',
791: p_token1 => 'COLUMN',
792: p_token1_value => 'TIMEFRAME_DAYS',
793: p_token2 => 'VALUE',

Line 800: FND_MSG_PUB.Count_And_Get

796: x_return_status := FND_API.G_RET_STS_ERROR;
797: END IF;
798:
799: -- Standard call to get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804: