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_SELATTVAL_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) := 'pvrvsavb.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_selattval(

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

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

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_SELECTED_ATTR_VALUES_PKG.Insert_Row)
116: PV_SELECTED_ATTR_VALUES_PKG.Insert_Row(

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

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

Line 174: FND_MSG_PUB.Count_And_Get

170: END IF;
171:
172:
173: -- Standard call to get message count and if count is 1, get message info.
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178:

Line 184: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 194: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 258: FND_MSG_PUB.initialize;

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

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

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

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

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

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

283: Fetch C_Get_selattval into
284: l_ref_SELATTVAL_rec.OBJECT_VERSION_NUMBER;
285:
286: If ( C_Get_selattval%NOTFOUND) Then
287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
288: THEN
289: FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
290: FND_MESSAGE.Set_Token ('INFO', 'selattval', FALSE);
291: FND_MSG_PUB.Add;

Line 291: FND_MSG_PUB.Add;

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

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

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

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

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

Line 310: FND_MSG_PUB.ADD;

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

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

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

Line 320: FND_MSG_PUB.ADD;

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

Line 328: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_selattval');

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

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

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

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

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

Line 405: FND_MSG_PUB.Count_And_Get

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

Line 415: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 425: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 480: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

Line 526: FND_MSG_PUB.Count_And_Get

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

Line 536: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 587: FND_MSG_PUB.initialize;

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

Line 600: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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

Line 615: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

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

Line 626: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

622:
623: IF C_attr_value_id_exists%NOTFOUND
624: THEN
625: AS_UTILITY_PVT.Set_Message(
626: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
627: p_msg_name => 'API_INVALID_ID',
628: p_token1 => 'attr_value_id',
629: p_token1_value => p_attr_value_id );
630:

Line 640: FND_MSG_PUB.Count_And_Get

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

Line 669: FND_MSG_PUB.initialize;

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

Line 680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: -Violate NOT NULL constraint(selection_criteria_id)');

676: -- validate NOT NULL column
677: IF(p_selection_criteria_id is NULL)
678: THEN
679: IF (AS_DEBUG_HIGH_ON) THEN
680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: -Violate NOT NULL constraint(selection_criteria_id)');
681: END IF;
682:
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: END IF;

Line 692: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

688:
689: IF C_select_criteria_id_Exists%NOTFOUND
690: THEN
691: AS_UTILITY_PVT.Set_Message(
692: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
693: p_msg_name => 'API_INVALID_ID',
694: p_token1 => 'COLUMN',
695: p_token1_value => 'selection_criteria_id',
696: p_token2 => 'VALUE',

Line 704: FND_MSG_PUB.Count_And_Get

700: END IF;
701: CLOSE C_select_criteria_id_Exists;
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: FND_MSG_PUB.Count_And_Get
705: ( p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708:

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

740:
741: -- Debug Message
742: IF (AS_DEBUG_HIGH_ON) THEN
743:
744: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
745: END IF;
746:
747:
748: -- Initialize API return status to SUCCESS

Line 808: FND_MSG_PUB.Add;

804: close lc_criterion_dup_values_check;
805:
806: if l_attribute_value is not null then
807: FND_MESSAGE.Set_Name('PV', 'PV_DUPLICATE_CRITERIA');
808: FND_MSG_PUB.Add;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: raise FND_API.G_EXC_ERROR;
811: end if;
812: -- end if;

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

825:
826: -- Debug Message
827: IF (AS_DEBUG_HIGH_ON) THEN
828:
829: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
830: END IF;
831:
832: END Validate_selattval;
833: