DBA Data[Home] [Help]

APPS.PV_ENTYATTMAP_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) := 'pvrveamb.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_entyattmap(

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_entyattmap(
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_entyattmap(
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_entyattmap');

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_entyattmap');
91: END IF;
92:
93: -- Invoke validation procedures
94: Validate_entyattmap(

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

108:
109: -- Debug Message
110: IF (AS_DEBUG_HIGH_ON) THEN
111:
112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
113: END IF;
114:
115: -- Invoke table handler(PV_ENTITY_ATTR_MAPPINGS_PKG.Insert_Row)
116: PV_ENTITY_ATTR_MAPPINGS_PKG.Insert_Row(

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

166:
167: -- Debug Message
168: IF (AS_DEBUG_HIGH_ON) THEN
169:
170: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
171: END IF;
172:
173:
174: -- Standard call to get message count and if count is 1, get message info.

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 185: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

181: WHEN FND_API.G_EXC_ERROR THEN
182: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
183: P_API_NAME => L_API_NAME
184: ,P_PKG_NAME => G_PKG_NAME
185: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
186: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
187: ,X_MSG_COUNT => X_MSG_COUNT
188: ,X_MSG_DATA => X_MSG_DATA
189: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 195: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
193: P_API_NAME => L_API_NAME
194: ,P_PKG_NAME => G_PKG_NAME
195: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
196: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
197: ,X_MSG_COUNT => X_MSG_COUNT
198: ,X_MSG_DATA => X_MSG_DATA
199: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 259: FND_MSG_PUB.initialize;

255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.to_Boolean( p_init_msg_list )
258: THEN
259: FND_MSG_PUB.initialize;
260: END IF;
261:
262:
263: -- Debug Message

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

262:
263: -- Debug Message
264: IF (AS_DEBUG_HIGH_ON) THEN
265:
266: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
267: END IF;
268:
269:
270: -- Initialize API return status to SUCCESS

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

276:
277: -- Debug Message
278: IF (AS_DEBUG_HIGH_ON) THEN
279:
280: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
281: END IF;
282:
283: Open C_Get_entyattmap( l_tar_ENTYATTMAP_rec.MAPPING_ID);
284: Fetch C_Get_entyattmap into

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

284: Fetch C_Get_entyattmap into
285: l_ref_ENTYATTMAP_rec.object_version_number;
286:
287: If ( C_Get_entyattmap%NOTFOUND) Then
288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
289: THEN
290: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
291: FND_MESSAGE.Set_Token ('INFO', 'entyattmap', FALSE);
292: FND_MSG_PUB.Add;

Line 292: FND_MSG_PUB.Add;

288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
289: THEN
290: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
291: FND_MESSAGE.Set_Token ('INFO', 'entyattmap', FALSE);
292: FND_MSG_PUB.Add;
293: END IF;
294: Close C_Get_entyattmap;
295: raise FND_API.G_EXC_ERROR;
296: END IF;

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

296: END IF;
297: -- Debug Message
298: IF (AS_DEBUG_HIGH_ON) THEN
299:
300: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
301: END IF;
302: Close C_Get_entyattmap;
303:
304:

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

303:
304:
305: If (l_tar_ENTYATTMAP_rec.object_version_number is NULL or
306: l_tar_ENTYATTMAP_rec.object_version_number = FND_API.G_MISS_NUM ) Then
307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
308: THEN
309: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
310: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
311: FND_MSG_PUB.ADD;

Line 311: FND_MSG_PUB.ADD;

307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
308: THEN
309: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
310: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
311: FND_MSG_PUB.ADD;
312: END IF;
313: raise FND_API.G_EXC_ERROR;
314: End if;
315: -- Check Whether record has been changed by someone else

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

313: raise FND_API.G_EXC_ERROR;
314: End if;
315: -- Check Whether record has been changed by someone else
316: If (l_tar_ENTYATTMAP_rec.object_version_number <> l_ref_ENTYATTMAP_rec.object_version_number) Then
317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
318: THEN
319: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
320: FND_MESSAGE.Set_Token('INFO', 'entyattmap', FALSE);
321: FND_MSG_PUB.ADD;

Line 321: FND_MSG_PUB.ADD;

317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
318: THEN
319: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
320: FND_MESSAGE.Set_Token('INFO', 'entyattmap', FALSE);
321: FND_MSG_PUB.ADD;
322: END IF;
323: raise FND_API.G_EXC_ERROR;
324: End if;
325:

Line 329: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_entyattmap');

325:
326: -- Debug message
327: IF (AS_DEBUG_HIGH_ON) THEN
328:
329: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_entyattmap');
330: END IF;
331:
332: -- Invoke validation procedures
333: Validate_entyattmap(

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

347:
348: -- Debug Message
349: IF (AS_DEBUG_HIGH_ON) THEN
350:
351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352: END IF;
353:
354: -- Invoke table handler(PV_ENTITY_ATTR_MAPPINGS_PKG.Update_Row)
355: PV_ENTITY_ATTR_MAPPINGS_PKG.Update_Row(

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

399:
400: -- Debug Message
401: IF (AS_DEBUG_HIGH_ON) THEN
402:
403: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
404: END IF;
405:
406:
407: -- Standard call to get message count and if count is 1, get message info.

Line 408: FND_MSG_PUB.Count_And_Get

404: END IF;
405:
406:
407: -- Standard call to get message count and if count is 1, get message info.
408: FND_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count,
410: p_data => x_msg_data
411: );
412:

Line 418: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

414: WHEN FND_API.G_EXC_ERROR THEN
415: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
416: P_API_NAME => L_API_NAME
417: ,P_PKG_NAME => G_PKG_NAME
418: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
419: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
420: ,X_MSG_COUNT => X_MSG_COUNT
421: ,X_MSG_DATA => X_MSG_DATA
422: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
429: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
430: ,X_MSG_COUNT => X_MSG_COUNT
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 482: FND_MSG_PUB.initialize;

478:
479: -- Initialize message list if p_init_msg_list is set to TRUE.
480: IF FND_API.to_Boolean( p_init_msg_list )
481: THEN
482: FND_MSG_PUB.initialize;
483: END IF;
484:
485:
486: -- Debug Message

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

485:
486: -- Debug Message
487: IF (AS_DEBUG_HIGH_ON) THEN
488:
489: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
490: END IF;
491:
492:
493: -- Initialize API return status to SUCCESS

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

499:
500: -- Debug Message
501: IF (AS_DEBUG_HIGH_ON) THEN
502:
503: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
504: END IF;
505:
506: -- Invoke table handler(PV_ENTITY_ATTR_MAPPINGS_PKG.Delete_Row)
507: PV_ENTITY_ATTR_MAPPINGS_PKG.Delete_Row(

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

519:
520: -- Debug Message
521: IF (AS_DEBUG_HIGH_ON) THEN
522:
523: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
524: END IF;
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.

Line 528: FND_MSG_PUB.Count_And_Get

524: END IF;
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get
529: ( p_count => x_msg_count,
530: p_data => x_msg_data
531: );
532:

Line 538: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

534: WHEN FND_API.G_EXC_ERROR THEN
535: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
536: P_API_NAME => L_API_NAME
537: ,P_PKG_NAME => G_PKG_NAME
538: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
540: ,X_MSG_COUNT => X_MSG_COUNT
541: ,X_MSG_DATA => X_MSG_DATA
542: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
546: P_API_NAME => L_API_NAME
547: ,P_PKG_NAME => G_PKG_NAME
548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
549: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
550: ,X_MSG_COUNT => X_MSG_COUNT
551: ,X_MSG_DATA => X_MSG_DATA
552: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 589: FND_MSG_PUB.initialize;

585:
586: -- Initialize message list if p_init_msg_list is set to TRUE.
587: IF FND_API.to_Boolean( p_init_msg_list )
588: THEN
589: FND_MSG_PUB.initialize;
590: END IF;
591:
592:
593: -- Initialize API return status to SUCCESS

Line 602: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

598: IF (p_mapping_id IS NOT NULL) AND
599: (p_mapping_id <> FND_API.G_MISS_NUM)
600: THEN
601: AS_UTILITY_PVT.Set_Message(
602: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
603: p_msg_name => 'API_INVALID_ID',
604: p_token1 => 'MAPPING_ID',
605: p_token1_value => p_mapping_id);
606:

Line 617: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

613: IF (p_mapping_id IS NULL) OR
614: (p_mapping_id = FND_API.G_MISS_NUM)
615: THEN
616: AS_UTILITY_PVT.Set_Message(
617: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
618: p_msg_name => 'API_MISSING_LEAD_ID');
619:
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: ELSE

Line 628: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

624:
625: IF C_mapping_id_exists%NOTFOUND
626: THEN
627: AS_UTILITY_PVT.Set_Message(
628: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
629: p_msg_name => 'API_INVALID_ID',
630: p_token1 => 'MAPPING_ID',
631: p_token1_value => p_mapping_id );
632:

Line 641: FND_MSG_PUB.Count_And_Get

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

Line 664: FND_MSG_PUB.initialize;

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

Line 673: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

669:
670: if p_operator is NULL or p_operator = FND_API.G_MISS_CHAR then
671:
672: AS_UTILITY_PVT.Set_Message(
673: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
674: p_msg_name => 'API_MISSING_OPERATOR');
675:
676: x_return_status := FND_API.G_RET_STS_ERROR;
677:

Line 684: FND_MSG_PUB.ADD;

680: 'LESS_THAN_OR_EQUALS', 'GREATER_THAN_OR_EQUALS')
681: then
682: FND_MESSAGE.SET_NAME('PV', 'API_INVALID_MAPPING_OPERATOR');
683: FND_MESSAGE.SET_TOKEN('OPERATOR', p_operator);
684: FND_MSG_PUB.ADD;
685:
686: x_return_status := FND_API.G_RET_STS_ERROR;
687:
688: else

Line 707: FND_MSG_PUB.Count_And_Get

703:
704: end if;
705:
706: -- Standard call to get message count and if count is 1, get message info.
707: FND_MSG_PUB.Count_And_Get
708: ( p_count => x_msg_count,
709: p_data => x_msg_data
710: );
711:

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

727:
728: -- Debug Message
729: IF (AS_DEBUG_HIGH_ON) THEN
730:
731: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
732: END IF;
733:
734:
735: -- Initialize API return status to SUCCESS

Line 857: FND_MSG_PUB.Add;

853: P_ENTYATTMAP_Rec.TARGET_ATTR_ID IS NULL or
854: P_ENTYATTMAP_Rec.TARGET_ATTR_ID = FND_API.G_MISS_NUM) then
855:
856: FND_MESSAGE.Set_Name('PV', 'PV_INVALID_ENTITY_MAPPING');
857: FND_MSG_PUB.Add;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859:
860: END IF;
861: END IF;

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

875:
876: -- Debug Message
877: IF (AS_DEBUG_HIGH_ON) THEN
878:
879: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
880: END IF;
881:
882: END Validate_entyattmap;
883: