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.PV_SELCRIT_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) := 'pvrvescb.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:
20: PROCEDURE Create_selcrit(

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:
20: PROCEDURE Create_selcrit(
21: P_Api_Version_Number IN NUMBER,

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:
20: PROCEDURE Create_selcrit(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 56: FND_MSG_PUB.initialize;

52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )
55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59:
60: -- Debug Message

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

59:
60: -- Debug Message
61: IF (AS_DEBUG_HIGH_ON) THEN
62:
63: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
64: END IF;
65:
66:
67: -- Initialize API return status to SUCCESS

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

74: -- Validate Environment
75: -- ******************************************************************
76: IF FND_GLOBAL.User_Id IS NULL
77: THEN
78: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
79: THEN
80: FND_MESSAGE.Set_Name('PV', 'UT_CANNOT_GET_PROFILE_VALUE');
81: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
82: FND_MSG_PUB.ADD;

Line 82: FND_MSG_PUB.ADD;

78: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
79: THEN
80: FND_MESSAGE.Set_Name('PV', 'UT_CANNOT_GET_PROFILE_VALUE');
81: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
82: FND_MSG_PUB.ADD;
83: END IF;
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86:

Line 90: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');

86:
87: -- Debug message
88: IF (AS_DEBUG_HIGH_ON) THEN
89:
90: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');
91: END IF;
92:
93: -- Invoke validation procedures
94: Validate_selcrit(

Line 128: FND_MSG_PUB.Add;

124: END LOOP;
125:
126: IF (l_previous_status = 'ACTIVE') THEN
127: FND_MESSAGE.Set_Name('PV', 'PV_MONITOR_RULE_ACTIVE');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131: END IF;
132:

Line 136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

132:
133: -- Debug Message
134: IF (AS_DEBUG_HIGH_ON) THEN
135:
136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137: END IF;
138:
139: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row)
140: PV_ENTY_SELECT_CRITERIA_PKG.Insert_Row(

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

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

Line 199: FND_MSG_PUB.Count_And_Get

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

Line 209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 284: FND_MSG_PUB.initialize;

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

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

287:
288: -- Debug Message
289: IF (AS_DEBUG_HIGH_ON) THEN
290:
291: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
292: END IF;
293:
294:
295: -- Initialize API return status to SUCCESS

Line 305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

301:
302: -- Debug Message
303: IF (AS_DEBUG_HIGH_ON) THEN
304:
305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
306: END IF;
307:
308: Open C_Get_selcrit( l_tar_SELCRIT_rec.SELECTION_CRITERIA_ID);
309: Fetch C_Get_selcrit into

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

309: Fetch C_Get_selcrit into
310: l_ref_SELCRIT_rec.object_version_number;
311:
312: If ( C_Get_selcrit%NOTFOUND) Then
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
314: THEN
315: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
316: FND_MESSAGE.Set_Token ('INFO', 'selcrit', FALSE);
317: FND_MSG_PUB.Add;

Line 317: FND_MSG_PUB.Add;

313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
314: THEN
315: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
316: FND_MESSAGE.Set_Token ('INFO', 'selcrit', FALSE);
317: FND_MSG_PUB.Add;
318: END IF;
319: Close C_Get_selcrit;
320: raise FND_API.G_EXC_ERROR;
321: END IF;

Line 325: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

321: END IF;
322: -- Debug Message
323: IF (AS_DEBUG_HIGH_ON) THEN
324:
325: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
326: END IF;
327: Close C_Get_selcrit;
328:
329: If (l_tar_SELCRIT_rec.object_version_number is NULL or

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

327: Close C_Get_selcrit;
328:
329: If (l_tar_SELCRIT_rec.object_version_number is NULL or
330: l_tar_SELCRIT_rec.object_version_number = FND_API.G_MISS_NUM ) Then
331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
332: THEN
333: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
334: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
335: FND_MSG_PUB.ADD;

Line 335: FND_MSG_PUB.ADD;

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

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

337: raise FND_API.G_EXC_ERROR;
338: End if;
339: -- Check Whether record has been changed by someone else
340: If (l_tar_SELCRIT_rec.object_version_number <> l_ref_SELCRIT_rec.object_version_number) Then
341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
342: THEN
343: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
344: FND_MESSAGE.Set_Token('INFO', 'selcrit', FALSE);
345: FND_MSG_PUB.ADD;

Line 345: FND_MSG_PUB.ADD;

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

Line 353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');

349:
350: -- Debug message
351: IF (AS_DEBUG_HIGH_ON) THEN
352:
353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selcrit');
354: END IF;
355:
356: -- Invoke validation procedures
357: Validate_selcrit(

Line 391: FND_MSG_PUB.Add;

387: END LOOP;
388:
389: IF (l_previous_status = 'ACTIVE') THEN
390: FND_MESSAGE.Set_Name('PV', 'PV_MONITOR_RULE_ACTIVE');
391: FND_MSG_PUB.Add;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394: END IF;
395:

Line 401: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

397:
398: -- Debug Message
399: IF (AS_DEBUG_HIGH_ON) THEN
400:
401: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
402: END IF;
403:
404: -- Invoke table handler(PV_ENTY_SELECT_CRITERIA_PKG.Update_Row)
405: PV_ENTY_SELECT_CRITERIA_PKG.Update_Row(

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

448:
449: -- Debug Message
450: IF (AS_DEBUG_HIGH_ON) THEN
451:
452: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
453: END IF;
454:
455:
456: -- Standard call to get message count and if count is 1, get message info.

Line 457: FND_MSG_PUB.Count_And_Get

453: END IF;
454:
455:
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get
458: ( p_count => x_msg_count,
459: p_data => x_msg_data
460: );
461:

Line 467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

463: WHEN FND_API.G_EXC_ERROR THEN
464: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
465: P_API_NAME => L_API_NAME
466: ,P_PKG_NAME => G_PKG_NAME
467: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
468: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
469: ,X_MSG_COUNT => X_MSG_COUNT
470: ,X_MSG_DATA => X_MSG_DATA
471: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
475: P_API_NAME => L_API_NAME
476: ,P_PKG_NAME => G_PKG_NAME
477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
478: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
479: ,X_MSG_COUNT => X_MSG_COUNT
480: ,X_MSG_DATA => X_MSG_DATA
481: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 540: FND_MSG_PUB.initialize;

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

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

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

Line 599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

595:
596: -- Debug Message
597: IF (AS_DEBUG_HIGH_ON) THEN
598:
599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
600: 'Private API: Calling PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row');
601: END IF;
602:
603: PV_ENTY_SELECT_CRITERIA_PKG.Delete_Row(

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

615:
616: -- Debug Message
617: IF (AS_DEBUG_HIGH_ON) THEN
618:
619: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
620: END IF;
621:
622:
623: -- Standard call to get message count and if count is 1, get message info.

Line 624: FND_MSG_PUB.Count_And_Get

620: END IF;
621:
622:
623: -- Standard call to get message count and if count is 1, get message info.
624: FND_MSG_PUB.Count_And_Get
625: ( p_count => x_msg_count,
626: p_data => x_msg_data
627: );
628:

Line 634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

630: WHEN FND_API.G_EXC_ERROR THEN
631: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
632: P_API_NAME => L_API_NAME
633: ,P_PKG_NAME => G_PKG_NAME
634: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
635: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
636: ,X_MSG_COUNT => X_MSG_COUNT
637: ,X_MSG_DATA => X_MSG_DATA
638: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 644: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
642: P_API_NAME => L_API_NAME
643: ,P_PKG_NAME => G_PKG_NAME
644: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
645: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
646: ,X_MSG_COUNT => X_MSG_COUNT
647: ,X_MSG_DATA => X_MSG_DATA
648: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 685: FND_MSG_PUB.initialize;

681:
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: IF FND_API.to_Boolean( p_init_msg_list )
684: THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688:
689: -- Initialize API return status to SUCCESS

Line 698: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

694: IF (p_selection_criteria_id IS NOT NULL) AND
695: (p_selection_criteria_id <> FND_API.G_MISS_NUM)
696: THEN
697: AS_UTILITY_PVT.Set_Message(
698: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
699: p_msg_name => 'API_INVALID_ID',
700: p_token1 => 'selection_criteria_id',
701: p_token1_value => p_selection_criteria_id);
702:

Line 713: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

709: IF (p_selection_criteria_id IS NULL) OR
710: (p_selection_criteria_id = FND_API.G_MISS_NUM)
711: THEN
712: AS_UTILITY_PVT.Set_Message(
713: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
714: p_msg_name => 'API_MISSING_LEAD_ID');
715:
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: ELSE

Line 724: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

720:
721: IF C_selection_criteria_id_exists%NOTFOUND
722: THEN
723: AS_UTILITY_PVT.Set_Message(
724: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
725: p_msg_name => 'API_INVALID_ID',
726: p_token1 => 'selection_criteria_id',
727: p_token1_value => p_selection_criteria_id );
728:

Line 738: FND_MSG_PUB.Count_And_Get

734: END IF;
735:
736:
737: -- Standard call to get message count and if count is 1, get message info.
738: FND_MSG_PUB.Count_And_Get
739: ( p_count => x_msg_count,
740: p_data => x_msg_data
741: );
742:

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

784:
785: -- Debug Message
786: IF (AS_DEBUG_HIGH_ON) THEN
787:
788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
789: END IF;
790:
791:
792: -- Initialize API return status to SUCCESS

Line 856: FND_MSG_PUB.Add;

852: begin
853:
854: if p_SELCRIT_REC.rank is null then
855: FND_MESSAGE.Set_Name('PV', 'PV_NULLCHECK_TIEBR_RANK');
856: FND_MSG_PUB.Add;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: raise FND_API.G_EXC_ERROR;
859: end if;
860:

Line 867: FND_MSG_PUB.Add;

863: rank = p_SELCRIT_REC.rank;
864:
865: if l_rank is not null then
866: FND_MESSAGE.Set_Name('PV', 'PV_DUPLICATE_TIEBR_RANK');
867: FND_MSG_PUB.Add;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: raise FND_API.G_EXC_ERROR;
870: end if;
871: exception

Line 888: FND_MSG_PUB.Add;

884: attribute_id = p_SELCRIT_REC.attribute_id;
885:
886: if (l_attribute_id is not null and p_validation_mode = AS_UTILITY_PVT.G_CREATE) then
887: FND_MESSAGE.Set_Name('PV', 'PV_DUPLICATE_TIEBR_ATTRIBUTE');
888: FND_MSG_PUB.Add;
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: raise FND_API.G_EXC_ERROR;
891: end if;
892: exception

Line 908: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

904:
905: if l_operator is NULL then
906:
907: pv_common_checks_pvt.Set_Message(
908: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
909: p_msg_name => 'API_INVALID_CODE',
910: p_token1 => 'TABLE_NAME',
911: p_token1_value => 'PV_ENTY_SELECT_CRITERIA',
912: p_token2 => 'COLUMN_NAME',

Line 968: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

964:
965: if l_attribute_name is not null then
966:
967: pv_common_checks_pvt.Set_Message(
968: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
969: p_msg_name => 'PV_DUPLICATE_INPUT_FILTER',
970: p_token1 => 'RULE_NAME',
971: p_token1_value => l_rule_name,
972: p_token2 => 'ATTRIBUTE_NAME',

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

988:
989: -- Debug Message
990: IF (AS_DEBUG_HIGH_ON) THEN
991:
992: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
993: END IF;
994:
995: END Validate_selcrit;
996: