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_API

Line 22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_Identity_Resource_Id IN NUMBER,
26: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type

Line 23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

19:
20: PROCEDURE Create_selattval(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_Identity_Resource_Id IN NUMBER,
26: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type
27: := PV_RULE_RECTYPE_PUB.G_MISS_SELATTVAL_REC,

Line 24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

20: PROCEDURE Create_selattval(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_Identity_Resource_Id IN NUMBER,
26: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type
27: := PV_RULE_RECTYPE_PUB.G_MISS_SELATTVAL_REC,
28: X_ATTR_VALUE_ID OUT NOCOPY NUMBER,

Line 44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

40: -- Standard Start of API savepoint
41: SAVEPOINT CREATE_SELATTVAL_PVT;
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
48: THEN

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 54: IF FND_API.to_Boolean( p_init_msg_list )

50: END IF;
51:
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:

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: END IF;
65:
66:
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: --
71: -- API body
72: --

Line 84: RAISE FND_API.G_EXC_ERROR;

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:
87: -- Debug message
88: IF (AS_DEBUG_HIGH_ON) THEN

Line 95: p_init_msg_list => FND_API.G_FALSE,

91: END IF;
92:
93: -- Invoke validation procedures
94: Validate_selattval(
95: p_init_msg_list => FND_API.G_FALSE,
96: p_validation_level => p_validation_level,
97: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
98: P_SELATTVAL_Rec => P_SELATTVAL_Rec,
99: x_return_status => x_return_status,

Line 103: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

99: x_return_status => x_return_status,
100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data);
102:
103: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:
107: -- Hint: Add corresponding Master-Detail business logic here if necessary.

Line 104: RAISE FND_API.G_EXC_ERROR;

100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data);
102:
103: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:
107: -- Hint: Add corresponding Master-Detail business logic here if necessary.
108:

Line 151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

147: ,p_SCORE => p_SELATTVAL_rec.SCORE);
148: -- Hint: Primary key should be returned.
149: -- x_ATTR_VALUE_ID := px_ATTR_VALUE_ID;
150:
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155: --

Line 152: RAISE FND_API.G_EXC_ERROR;

148: -- Hint: Primary key should be returned.
149: -- x_ATTR_VALUE_ID := px_ATTR_VALUE_ID;
150:
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155: --
156: -- End of API body

Line 160: IF FND_API.to_Boolean( p_commit )

156: -- End of API body
157: --
158:
159: -- Standard check for p_commit
160: IF FND_API.to_Boolean( p_commit )
161: THEN
162: COMMIT WORK;
163: END IF;
164:

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176: p_data => x_msg_data
177: );
178:
179: EXCEPTION
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

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: ,X_MSG_COUNT => X_MSG_COUNT
187: ,X_MSG_DATA => X_MSG_DATA
188: ,X_RETURN_STATUS => X_RETURN_STATUS);
189:
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

Line 217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

213:
214: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
215: PROCEDURE Update_selattval(
216: P_Api_Version_Number IN NUMBER,
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_Identity_Resource_Id IN NUMBER,
221: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,

Line 218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

214: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
215: PROCEDURE Update_selattval(
216: P_Api_Version_Number IN NUMBER,
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_Identity_Resource_Id IN NUMBER,
221: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
222: X_Return_Status OUT NOCOPY VARCHAR2,

Line 219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

215: PROCEDURE Update_selattval(
216: P_Api_Version_Number IN NUMBER,
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_Identity_Resource_Id IN NUMBER,
221: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
222: X_Return_Status OUT NOCOPY VARCHAR2,
223: X_Msg_Count OUT NOCOPY NUMBER,

Line 246: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

242: -- Standard Start of API savepoint
243: SAVEPOINT UPDATE_SELATTVAL_PVT;
244:
245: -- Standard call to check for call compatibility.
246: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
247: p_api_version_number,
248: l_api_name,
249: G_PKG_NAME)
250: THEN

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

247: p_api_version_number,
248: l_api_name,
249: G_PKG_NAME)
250: THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:
254:
255: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 256: IF FND_API.to_Boolean( p_init_msg_list )

252: END IF;
253:
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:

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: END IF;
267:
268:
269: -- Initialize API return status to SUCCESS
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: --
273: -- Api body
274: --

Line 294: raise FND_API.G_EXC_ERROR;

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;
296: -- Debug Message
297: IF (AS_DEBUG_HIGH_ON) THEN
298:

Line 305: l_tar_SELATTVAL_rec.object_version_number = FND_API.G_MISS_NUM ) Then

301: Close C_Get_selattval;
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);

Line 312: raise FND_API.G_EXC_ERROR;

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
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)

Line 322: raise FND_API.G_EXC_ERROR;

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:
325: -- Debug message
326: IF (AS_DEBUG_HIGH_ON) THEN

Line 333: p_init_msg_list => FND_API.G_FALSE,

329: END IF;
330:
331: -- Invoke validation procedures
332: Validate_selattval(
333: p_init_msg_list => FND_API.G_FALSE,
334: p_validation_level => p_validation_level,
335: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
336: P_SELATTVAL_Rec => P_SELATTVAL_Rec,
337: x_return_status => x_return_status,

Line 341: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

337: x_return_status => x_return_status,
338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data);
340:
341: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: -- Hint: Add corresponding Master-Detail business logic here if necessary.

Line 342: RAISE FND_API.G_EXC_ERROR;

338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data);
340:
341: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: -- Hint: Add corresponding Master-Detail business logic here if necessary.
346:

Line 358: ,p_CREATION_DATE => FND_API.G_MISS_DATE

354: PV_SELECTED_ATTR_VALUES_PKG.Update_Row(
355: p_ATTR_VALUE_ID => p_SELATTVAL_rec.ATTR_VALUE_ID
356: ,p_LAST_UPDATE_DATE => SYSDATE
357: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
358: ,p_CREATION_DATE => FND_API.G_MISS_DATE
359: ,p_CREATED_BY => FND_API.G_MISS_NUM
360: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
361: ,p_OBJECT_VERSION_NUMBER => p_SELATTVAL_rec.OBJECT_VERSION_NUMBER
362: ,p_REQUEST_ID => p_SELATTVAL_rec.REQUEST_ID

Line 359: ,p_CREATED_BY => FND_API.G_MISS_NUM

355: p_ATTR_VALUE_ID => p_SELATTVAL_rec.ATTR_VALUE_ID
356: ,p_LAST_UPDATE_DATE => SYSDATE
357: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
358: ,p_CREATION_DATE => FND_API.G_MISS_DATE
359: ,p_CREATED_BY => FND_API.G_MISS_NUM
360: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
361: ,p_OBJECT_VERSION_NUMBER => p_SELATTVAL_rec.OBJECT_VERSION_NUMBER
362: ,p_REQUEST_ID => p_SELATTVAL_rec.REQUEST_ID
363: ,p_PROGRAM_APPLICATION_ID => p_SELATTVAL_rec.PROGRAM_APPLICATION_ID

Line 391: IF FND_API.to_Boolean( p_commit )

387: -- End of API body.
388: --
389:
390: -- Standard check for p_commit
391: IF FND_API.to_Boolean( p_commit )
392: THEN
393: COMMIT WORK;
394: END IF;
395:

Line 411: WHEN FND_API.G_EXC_ERROR THEN

407: p_data => x_msg_data
408: );
409:
410: EXCEPTION
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

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: ,X_MSG_COUNT => X_MSG_COUNT
418: ,X_MSG_DATA => X_MSG_DATA
419: ,X_RETURN_STATUS => X_RETURN_STATUS);
420:
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

Line 449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

445: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
446: -- The Master delete procedure may not be needed depends on different business requirements.
447: PROCEDURE Delete_selattval(
448: P_Api_Version_Number IN NUMBER,
449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
450: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
452: P_Identity_Resource_Id IN NUMBER,
453: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,

Line 450: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

446: -- The Master delete procedure may not be needed depends on different business requirements.
447: PROCEDURE Delete_selattval(
448: P_Api_Version_Number IN NUMBER,
449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
450: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
452: P_Identity_Resource_Id IN NUMBER,
453: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
454: X_Return_Status OUT NOCOPY VARCHAR2,

Line 451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

447: PROCEDURE Delete_selattval(
448: P_Api_Version_Number IN NUMBER,
449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
450: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
451: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
452: P_Identity_Resource_Id IN NUMBER,
453: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
454: X_Return_Status OUT NOCOPY VARCHAR2,
455: X_Msg_Count OUT NOCOPY NUMBER,

Line 468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

464: -- Standard Start of API savepoint
465: SAVEPOINT DELETE_SELATTVAL_PVT;
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
472: THEN

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
472: THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 478: IF FND_API.to_Boolean( p_init_msg_list )

474: END IF;
475:
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:

Line 492: x_return_status := FND_API.G_RET_STS_SUCCESS;

488: END IF;
489:
490:
491: -- Initialize API return status to SUCCESS
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493:
494: --
495: -- Api body
496: --

Line 512: IF FND_API.to_Boolean( p_commit )

508: -- End of API body
509: --
510:
511: -- Standard check for p_commit
512: IF FND_API.to_Boolean( p_commit )
513: THEN
514: COMMIT WORK;
515: END IF;
516:

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: p_data => x_msg_data
529: );
530:
531: EXCEPTION
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

Line 542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

538: ,X_MSG_COUNT => X_MSG_COUNT
539: ,X_MSG_DATA => X_MSG_DATA
540: ,X_RETURN_STATUS => X_RETURN_STATUS);
541:
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

Line 568: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

564:
565:
566: -- Item-level validation procedures
567: PROCEDURE Validate_ATTR_VALUE_ID (
568: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
569: P_Validation_mode IN VARCHAR2,
570: P_ATTR_VALUE_ID IN NUMBER,
571: X_Return_Status OUT NOCOPY VARCHAR2,
572: X_Msg_Count OUT NOCOPY NUMBER,

Line 585: IF FND_API.to_Boolean( p_init_msg_list )

581: l_val VARCHAR2(1);
582: BEGIN
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:

Line 592: x_return_status := FND_API.G_RET_STS_SUCCESS;

588: END IF;
589:
590:
591: -- Initialize API return status to SUCCESS
592: x_return_status := FND_API.G_RET_STS_SUCCESS;
593:
594: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
595: THEN
596: IF (p_attr_value_id IS NOT NULL) AND

Line 597: (p_attr_value_id <> FND_API.G_MISS_NUM)

593:
594: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
595: THEN
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',

Line 605: x_return_status := FND_API.G_RET_STS_ERROR;

601: p_msg_name => 'API_INVALID_ID',
602: p_token1 => 'attr_value_id',
603: p_token1_value => p_attr_value_id);
604:
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: END IF;
607:
608: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
609: THEN

Line 612: (p_attr_value_id = FND_API.G_MISS_NUM)

608: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
609: THEN
610: -- validate NOT NULL column
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');

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

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
620: OPEN C_attr_value_id_exists (p_attr_value_id);
621: FETCH C_attr_value_id_exists into l_val;
622:

Line 631: x_return_status := FND_API.G_RET_STS_ERROR;

627: p_msg_name => 'API_INVALID_ID',
628: p_token1 => 'attr_value_id',
629: p_token1_value => p_attr_value_id );
630:
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: END IF;
633:
634: CLOSE C_attr_value_id_exists;
635: END IF;

Line 649: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

645: END Validate_ATTR_VALUE_ID;
646:
647:
648: PROCEDURE Validate_SELECTION_CRITERIA_ID (
649: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
650: P_Validation_mode IN VARCHAR2,
651: P_SELECTION_CRITERIA_ID IN NUMBER,
652: X_Return_Status OUT NOCOPY VARCHAR2,
653: X_Msg_Count OUT NOCOPY NUMBER,

Line 667: IF FND_API.to_Boolean( p_init_msg_list )

663:
664: BEGIN
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:

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: END IF;
671:
672:
673: -- Initialize API return status to SUCCESS
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675:
676: -- validate NOT NULL column
677: IF(p_selection_criteria_id is NULL)
678: THEN

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

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;
685:
686: OPEN C_select_criteria_id_Exists (p_selection_criteria_id);
687: FETCH C_select_criteria_id_Exists into l_val;

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: p_token1_value => 'selection_criteria_id',
696: p_token2 => 'VALUE',
697: p_token2_value => p_selection_criteria_id );
698:
699: x_return_status := FND_API.G_RET_STS_ERROR;
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.

Line 713: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

709: END Validate_SELECTION_CRITERIA_ID;
710:
711:
712: PROCEDURE Validate_selattval(
713: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
714: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
715: P_Validation_mode IN VARCHAR2,
716: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
717: X_Return_Status OUT NOCOPY VARCHAR2,

Line 714: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

710:
711:
712: PROCEDURE Validate_selattval(
713: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
714: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
715: P_Validation_mode IN VARCHAR2,
716: P_SELATTVAL_Rec IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
717: X_Return_Status OUT NOCOPY VARCHAR2,
718: X_Msg_Count OUT NOCOPY NUMBER,

Line 749: x_return_status := FND_API.G_RET_STS_SUCCESS;

745: END IF;
746:
747:
748: -- Initialize API return status to SUCCESS
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
752:
753: Validate_ATTR_VALUE_ID(

Line 754: p_init_msg_list => FND_API.G_FALSE,

750:
751: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
752:
753: Validate_ATTR_VALUE_ID(
754: p_init_msg_list => FND_API.G_FALSE,
755: p_validation_mode => p_validation_mode,
756: p_ATTR_VALUE_ID => P_SELATTVAL_Rec.ATTR_VALUE_ID,
757: x_return_status => x_return_status,
758: x_msg_count => x_msg_count,

Line 761: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

757: x_return_status => x_return_status,
758: x_msg_count => x_msg_count,
759: x_msg_data => x_msg_data);
760:
761: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
762: raise FND_API.G_EXC_ERROR;
763: END IF;
764:
765: pv_common_checks_pvt.Validate_OBJECT_VERSION_NUMBER(

Line 762: raise FND_API.G_EXC_ERROR;

758: x_msg_count => x_msg_count,
759: x_msg_data => x_msg_data);
760:
761: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
762: raise FND_API.G_EXC_ERROR;
763: END IF;
764:
765: pv_common_checks_pvt.Validate_OBJECT_VERSION_NUMBER(
766: p_init_msg_list => FND_API.G_FALSE,

Line 766: p_init_msg_list => FND_API.G_FALSE,

762: raise FND_API.G_EXC_ERROR;
763: END IF;
764:
765: pv_common_checks_pvt.Validate_OBJECT_VERSION_NUMBER(
766: p_init_msg_list => FND_API.G_FALSE,
767: p_validation_mode => p_validation_mode,
768: p_OBJECT_VERSION_NUMBER => P_SELATTVAL_Rec.OBJECT_VERSION_NUMBER,
769: x_return_status => x_return_status,
770: x_msg_count => x_msg_count,

Line 773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

769: x_return_status => x_return_status,
770: x_msg_count => x_msg_count,
771: x_msg_data => x_msg_data);
772:
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: raise FND_API.G_EXC_ERROR;
775: END IF;
776:
777: Validate_SELECTION_CRITERIA_ID(

Line 774: raise FND_API.G_EXC_ERROR;

770: x_msg_count => x_msg_count,
771: x_msg_data => x_msg_data);
772:
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: raise FND_API.G_EXC_ERROR;
775: END IF;
776:
777: Validate_SELECTION_CRITERIA_ID(
778: p_init_msg_list => FND_API.G_FALSE,

Line 778: p_init_msg_list => FND_API.G_FALSE,

774: raise FND_API.G_EXC_ERROR;
775: END IF;
776:
777: Validate_SELECTION_CRITERIA_ID(
778: p_init_msg_list => FND_API.G_FALSE,
779: p_validation_mode => p_validation_mode,
780: p_SELECTION_CRITERIA_ID => P_SELATTVAL_Rec.SELECTION_CRITERIA_ID,
781: x_return_status => x_return_status,
782: x_msg_count => x_msg_count,

Line 785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

781: x_return_status => x_return_status,
782: x_msg_count => x_msg_count,
783: x_msg_data => x_msg_data);
784:
785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
786: raise FND_API.G_EXC_ERROR;
787: END IF;
788:
789: END IF;

Line 786: raise FND_API.G_EXC_ERROR;

782: x_msg_count => x_msg_count,
783: x_msg_data => x_msg_data);
784:
785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
786: raise FND_API.G_EXC_ERROR;
787: END IF;
788:
789: END IF;
790:

Line 809: x_return_status := FND_API.G_RET_STS_ERROR;

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;
813: END IF;

Line 810: raise FND_API.G_EXC_ERROR;

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;
813: END IF;
814: