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_ENTYRLS_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_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type

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

19:
20: PROCEDURE Create_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type
27: := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC,

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

20: PROCEDURE Create_entyrls(
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_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type
27: := PV_RULE_RECTYPE_PUB.G_MISS_ENTYRLS_REC,
28: X_ENTITY_RULE_APPLIED_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_ENTYRLS_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_entyrls(
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_ENTYRLS_Rec => P_ENTYRLS_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 157: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

153: ,p_PROCESS_STATUS => p_ENTYRLS_rec.PROCESS_STATUS);
154: -- Hint: Primary key should be returned.
155: -- x_ENTITY_RULE_APPLIED_ID := px_ENTITY_RULE_APPLIED_ID;
156:
157: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161: --

Line 158: RAISE FND_API.G_EXC_ERROR;

154: -- Hint: Primary key should be returned.
155: -- x_ENTITY_RULE_APPLIED_ID := px_ENTITY_RULE_APPLIED_ID;
156:
157: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160:
161: --
162: -- End of API body

Line 166: IF FND_API.to_Boolean( p_commit )

162: -- End of API body
163: --
164:
165: -- Standard check for p_commit
166: IF FND_API.to_Boolean( p_commit )
167: THEN
168: COMMIT WORK;
169: END IF;
170:

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: p_data => x_msg_data
183: );
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

219:
220: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
221: PROCEDURE Update_entyrls(
222: P_Api_Version_Number IN NUMBER,
223: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
224: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: P_Identity_Resource_Id IN NUMBER,
227: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,

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

220: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
221: PROCEDURE Update_entyrls(
222: P_Api_Version_Number IN NUMBER,
223: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
224: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: P_Identity_Resource_Id IN NUMBER,
227: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
228: X_Return_Status OUT NOCOPY VARCHAR2,

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

221: PROCEDURE Update_entyrls(
222: P_Api_Version_Number IN NUMBER,
223: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
224: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: P_Identity_Resource_Id IN NUMBER,
227: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
228: X_Return_Status OUT NOCOPY VARCHAR2,
229: X_Msg_Count OUT NOCOPY NUMBER,

Line 251: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

247: -- Standard Start of API savepoint
248: SAVEPOINT UPDATE_ENTYRLS_PVT;
249:
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
252: p_api_version_number,
253: l_api_name,
254: G_PKG_NAME)
255: THEN

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: p_api_version_number,
253: l_api_name,
254: G_PKG_NAME)
255: THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259:
260: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 261: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271: END IF;
272:
273:
274: -- Initialize API return status to SUCCESS
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276:
277: --
278: -- Api body
279: --

Line 300: raise FND_API.G_EXC_ERROR;

296: FND_MESSAGE.Set_Token ('INFO', 'entyrls', FALSE);
297: FND_MSG_PUB.Add;
298: END IF;
299: Close C_Get_entyrls;
300: raise FND_API.G_EXC_ERROR;
301: END IF;
302: -- Debug Message
303: IF (AS_DEBUG_HIGH_ON) THEN
304:

Line 311: l_tar_ENTYRLS_rec.object_version_number = FND_API.G_MISS_NUM ) Then

307: Close C_Get_entyrls;
308:
309:
310: If (l_tar_ENTYRLS_rec.object_version_number is NULL or
311: l_tar_ENTYRLS_rec.object_version_number = FND_API.G_MISS_NUM ) Then
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
313: THEN
314: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
315: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);

Line 318: raise FND_API.G_EXC_ERROR;

314: FND_MESSAGE.Set_Name('PV', 'API_MISSING_ID');
315: FND_MESSAGE.Set_Token('COLUMN', 'object_version_number', FALSE);
316: FND_MSG_PUB.ADD;
317: END IF;
318: raise FND_API.G_EXC_ERROR;
319: End if;
320: -- Check Whether record has been changed by someone else
321: If (l_tar_ENTYRLS_rec.object_version_number <> l_ref_ENTYRLS_rec.object_version_number) Then
322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 328: raise FND_API.G_EXC_ERROR;

324: FND_MESSAGE.Set_Name('PV', 'API_RECORD_CHANGED');
325: FND_MESSAGE.Set_Token('INFO', 'entyrls', FALSE);
326: FND_MSG_PUB.ADD;
327: END IF;
328: raise FND_API.G_EXC_ERROR;
329: End if;
330:
331: -- Debug message
332: IF (AS_DEBUG_HIGH_ON) THEN

Line 339: p_init_msg_list => FND_API.G_FALSE,

335: END IF;
336:
337: -- Invoke validation procedures
338: Validate_entyrls(
339: p_init_msg_list => FND_API.G_FALSE,
340: p_validation_level => p_validation_level,
341: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
342: P_ENTYRLS_Rec => P_ENTYRLS_Rec,
343: x_return_status => x_return_status,

Line 347: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

343: x_return_status => x_return_status,
344: x_msg_count => x_msg_count,
345: x_msg_data => x_msg_data);
346:
347: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351: -- Hint: Add corresponding Master-Detail business logic here if necessary.

Line 348: RAISE FND_API.G_EXC_ERROR;

344: x_msg_count => x_msg_count,
345: x_msg_data => x_msg_data);
346:
347: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351: -- Hint: Add corresponding Master-Detail business logic here if necessary.
352:

Line 364: ,p_CREATION_DATE => FND_API.G_MISS_DATE

360: PV_ENTITY_RULES_APPLIED_PKG.Update_Row(
361: p_ENTITY_RULE_APPLIED_ID => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID
362: ,p_LAST_UPDATE_DATE => SYSDATE
363: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
364: ,p_CREATION_DATE => FND_API.G_MISS_DATE
365: ,p_CREATED_BY => FND_API.G_MISS_NUM
366: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
367: ,p_OBJECT_VERSION_NUMBER => p_ENTYRLS_rec.OBJECT_VERSION_NUMBER
368: ,p_REQUEST_ID => p_ENTYRLS_rec.REQUEST_ID

Line 365: ,p_CREATED_BY => FND_API.G_MISS_NUM

361: p_ENTITY_RULE_APPLIED_ID => p_ENTYRLS_rec.ENTITY_RULE_APPLIED_ID
362: ,p_LAST_UPDATE_DATE => SYSDATE
363: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
364: ,p_CREATION_DATE => FND_API.G_MISS_DATE
365: ,p_CREATED_BY => FND_API.G_MISS_NUM
366: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
367: ,p_OBJECT_VERSION_NUMBER => p_ENTYRLS_rec.OBJECT_VERSION_NUMBER
368: ,p_REQUEST_ID => p_ENTYRLS_rec.REQUEST_ID
369: ,p_PROGRAM_APPLICATION_ID => p_ENTYRLS_rec.PROGRAM_APPLICATION_ID

Line 403: IF FND_API.to_Boolean( p_commit )

399: -- End of API body.
400: --
401:
402: -- Standard check for p_commit
403: IF FND_API.to_Boolean( p_commit )
404: THEN
405: COMMIT WORK;
406: END IF;
407:

Line 423: WHEN FND_API.G_EXC_ERROR THEN

419: p_data => x_msg_data
420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
425: P_API_NAME => L_API_NAME
426: ,P_PKG_NAME => G_PKG_NAME
427: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

429: ,X_MSG_COUNT => X_MSG_COUNT
430: ,X_MSG_DATA => X_MSG_DATA
431: ,X_RETURN_STATUS => X_RETURN_STATUS);
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
435: P_API_NAME => L_API_NAME
436: ,P_PKG_NAME => G_PKG_NAME
437: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

457: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
458: -- The Master delete procedure may not be needed depends on different business requirements.
459: PROCEDURE Delete_entyrls(
460: P_Api_Version_Number IN NUMBER,
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_Identity_Resource_Id IN NUMBER,
465: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,

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

458: -- The Master delete procedure may not be needed depends on different business requirements.
459: PROCEDURE Delete_entyrls(
460: P_Api_Version_Number IN NUMBER,
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_Identity_Resource_Id IN NUMBER,
465: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
466: X_Return_Status OUT NOCOPY VARCHAR2,

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

459: PROCEDURE Delete_entyrls(
460: P_Api_Version_Number IN NUMBER,
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_Identity_Resource_Id IN NUMBER,
465: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
466: X_Return_Status OUT NOCOPY VARCHAR2,
467: X_Msg_Count OUT NOCOPY NUMBER,

Line 479: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

475: -- Standard Start of API savepoint
476: SAVEPOINT DELETE_ENTYRLS_PVT;
477:
478: -- Standard call to check for call compatibility.
479: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
480: p_api_version_number,
481: l_api_name,
482: G_PKG_NAME)
483: THEN

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480: p_api_version_number,
481: l_api_name,
482: G_PKG_NAME)
483: THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487:
488: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 489: IF FND_API.to_Boolean( p_init_msg_list )

485: END IF;
486:
487:
488: -- Initialize message list if p_init_msg_list is set to TRUE.
489: IF FND_API.to_Boolean( p_init_msg_list )
490: THEN
491: FND_MSG_PUB.initialize;
492: END IF;
493:

Line 503: x_return_status := FND_API.G_RET_STS_SUCCESS;

499: END IF;
500:
501:
502: -- Initialize API return status to SUCCESS
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: --
506: -- Api body
507: --

Line 523: IF FND_API.to_Boolean( p_commit )

519: -- End of API body
520: --
521:
522: -- Standard check for p_commit
523: IF FND_API.to_Boolean( p_commit )
524: THEN
525: COMMIT WORK;
526: END IF;
527:

Line 543: WHEN FND_API.G_EXC_ERROR THEN

539: p_data => x_msg_data
540: );
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: ,X_MSG_COUNT => X_MSG_COUNT
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

575:
576:
577: -- Item-level validation procedures
578: PROCEDURE Validate_ENTY_RULE_APPLIED_ID (
579: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
580: P_Validation_mode IN VARCHAR2,
581: P_ENTITY_RULE_APPLIED_ID IN NUMBER,
582: X_Return_Status OUT NOCOPY VARCHAR2,
583: X_Msg_Count OUT NOCOPY NUMBER,

Line 596: IF FND_API.to_Boolean( p_init_msg_list )

592: l_val VARCHAR2(1);
593: BEGIN
594:
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean( p_init_msg_list )
597: THEN
598: FND_MSG_PUB.initialize;
599: END IF;
600:

Line 603: x_return_status := FND_API.G_RET_STS_SUCCESS;

599: END IF;
600:
601:
602: -- Initialize API return status to SUCCESS
603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604:
605: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
606: THEN
607: IF (p_entity_rule_applied_id IS NOT NULL) AND

Line 608: (p_entity_rule_applied_id <> FND_API.G_MISS_NUM)

604:
605: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
606: THEN
607: IF (p_entity_rule_applied_id IS NOT NULL) AND
608: (p_entity_rule_applied_id <> FND_API.G_MISS_NUM)
609: THEN
610: AS_UTILITY_PVT.Set_Message(
611: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
612: p_msg_name => 'API_INVALID_ID',

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612: p_msg_name => 'API_INVALID_ID',
613: p_token1 => 'ENTITY_RULE_APPLIED_ID',
614: p_token1_value => p_entity_rule_applied_id);
615:
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: END IF;
618:
619: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
620: THEN

Line 623: (p_entity_rule_applied_id = FND_API.G_MISS_NUM)

619: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
620: THEN
621: -- validate NOT NULL column
622: IF (p_entity_rule_applied_id IS NULL) OR
623: (p_entity_rule_applied_id = FND_API.G_MISS_NUM)
624: THEN
625: AS_UTILITY_PVT.Set_Message(
626: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
627: p_msg_name => 'API_MISSING_LEAD_ID');

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: AS_UTILITY_PVT.Set_Message(
626: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
627: p_msg_name => 'API_MISSING_LEAD_ID');
628:
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: ELSE
631: OPEN C_entity_rule_applied_exists (p_entity_rule_applied_id);
632: FETCH C_entity_rule_applied_exists into l_val;
633:

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: p_msg_name => 'API_INVALID_ID',
639: p_token1 => 'ENTITY_RULE_APPLIED_ID',
640: p_token1_value => p_entity_rule_applied_id );
641:
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: END IF;
644:
645: CLOSE C_entity_rule_applied_exists;
646: END IF;

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

656: END Validate_ENTY_RULE_APPLIED_ID;
657:
658:
659: PROCEDURE Validate_entyrls(
660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
661: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
662: P_Validation_mode IN VARCHAR2,
663: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
664: X_Return_Status OUT NOCOPY VARCHAR2,

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

657:
658:
659: PROCEDURE Validate_entyrls(
660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
661: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
662: P_Validation_mode IN VARCHAR2,
663: P_ENTYRLS_Rec IN PV_RULE_RECTYPE_PUB.ENTYRLS_Rec_Type,
664: X_Return_Status OUT NOCOPY VARCHAR2,
665: X_Msg_Count OUT NOCOPY NUMBER,

Line 680: x_return_status := FND_API.G_RET_STS_SUCCESS;

676: END IF;
677:
678:
679: -- Initialize API return status to SUCCESS
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
683:
684: Validate_ENTY_RULE_APPLIED_ID(

Line 685: p_init_msg_list => FND_API.G_FALSE,

681:
682: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
683:
684: Validate_ENTY_RULE_APPLIED_ID(
685: p_init_msg_list => FND_API.G_FALSE,
686: p_validation_mode => p_validation_mode,
687: p_ENTITY_RULE_APPLIED_ID => P_ENTYRLS_Rec.ENTITY_RULE_APPLIED_ID,
688: x_return_status => x_return_status,
689: x_msg_count => x_msg_count,

Line 692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

688: x_return_status => x_return_status,
689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data);
691:
692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
693: raise FND_API.G_EXC_ERROR;
694: END IF;
695:
696: pv_common_checks_pvt.Validate_OBJECT_VERSION_NUMBER(

Line 693: raise FND_API.G_EXC_ERROR;

689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data);
691:
692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
693: raise FND_API.G_EXC_ERROR;
694: END IF;
695:
696: pv_common_checks_pvt.Validate_OBJECT_VERSION_NUMBER(
697: p_init_msg_list => FND_API.G_FALSE,

Line 697: p_init_msg_list => FND_API.G_FALSE,

693: raise FND_API.G_EXC_ERROR;
694: END IF;
695:
696: pv_common_checks_pvt.Validate_OBJECT_VERSION_NUMBER(
697: p_init_msg_list => FND_API.G_FALSE,
698: p_validation_mode => p_validation_mode,
699: p_OBJECT_VERSION_NUMBER => P_ENTYRLS_Rec.OBJECT_VERSION_NUMBER,
700: x_return_status => x_return_status,
701: x_msg_count => x_msg_count,

Line 704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

700: x_return_status => x_return_status,
701: x_msg_count => x_msg_count,
702: x_msg_data => x_msg_data);
703:
704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
705: raise FND_API.G_EXC_ERROR;
706: END IF;
707:
708: pv_common_checks_pvt.Validate_Lookup(

Line 705: raise FND_API.G_EXC_ERROR;

701: x_msg_count => x_msg_count,
702: x_msg_data => x_msg_data);
703:
704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
705: raise FND_API.G_EXC_ERROR;
706: END IF;
707:
708: pv_common_checks_pvt.Validate_Lookup(
709: p_init_msg_list => FND_API.G_FALSE,

Line 709: p_init_msg_list => FND_API.G_FALSE,

705: raise FND_API.G_EXC_ERROR;
706: END IF;
707:
708: pv_common_checks_pvt.Validate_Lookup(
709: p_init_msg_list => FND_API.G_FALSE,
710: p_validation_mode => p_validation_mode,
711: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',
712: p_COLUMN_NAME => 'ENTITY',
713: p_lookup_type => 'PV_RULE_APPLIED_ENTITY_TYPE',

Line 719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

715: x_return_status => x_return_status,
716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data);
718:
719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
720: raise FND_API.G_EXC_ERROR;
721: END IF;
722:
723: pv_common_checks_pvt.Validate_PROCESS_RULE_ID(

Line 720: raise FND_API.G_EXC_ERROR;

716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data);
718:
719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
720: raise FND_API.G_EXC_ERROR;
721: END IF;
722:
723: pv_common_checks_pvt.Validate_PROCESS_RULE_ID(
724: p_init_msg_list => FND_API.G_FALSE,

Line 724: p_init_msg_list => FND_API.G_FALSE,

720: raise FND_API.G_EXC_ERROR;
721: END IF;
722:
723: pv_common_checks_pvt.Validate_PROCESS_RULE_ID(
724: p_init_msg_list => FND_API.G_FALSE,
725: p_validation_mode => p_validation_mode,
726: p_PROCESS_RULE_ID => P_ENTYRLS_Rec.PROCESS_RULE_ID,
727: x_return_status => x_return_status,
728: x_msg_count => x_msg_count,

Line 731: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

727: x_return_status => x_return_status,
728: x_msg_count => x_msg_count,
729: x_msg_data => x_msg_data);
730:
731: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
732: raise FND_API.G_EXC_ERROR;
733: END IF;
734:
735: pv_common_checks_pvt.Validate_PROCESS_RULE_ID(

Line 732: raise FND_API.G_EXC_ERROR;

728: x_msg_count => x_msg_count,
729: x_msg_data => x_msg_data);
730:
731: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
732: raise FND_API.G_EXC_ERROR;
733: END IF;
734:
735: pv_common_checks_pvt.Validate_PROCESS_RULE_ID(
736: p_init_msg_list => FND_API.G_FALSE,

Line 736: p_init_msg_list => FND_API.G_FALSE,

732: raise FND_API.G_EXC_ERROR;
733: END IF;
734:
735: pv_common_checks_pvt.Validate_PROCESS_RULE_ID(
736: p_init_msg_list => FND_API.G_FALSE,
737: p_validation_mode => p_validation_mode,
738: p_PROCESS_RULE_ID => P_ENTYRLS_Rec.PARENT_PROCESS_RULE_ID,
739: x_return_status => x_return_status,
740: x_msg_count => x_msg_count,

Line 743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

739: x_return_status => x_return_status,
740: x_msg_count => x_msg_count,
741: x_msg_data => x_msg_data);
742:
743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: raise FND_API.G_EXC_ERROR;
745: END IF;
746:
747: pv_common_checks_pvt.Validate_Lookup(

Line 744: raise FND_API.G_EXC_ERROR;

740: x_msg_count => x_msg_count,
741: x_msg_data => x_msg_data);
742:
743: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: raise FND_API.G_EXC_ERROR;
745: END IF;
746:
747: pv_common_checks_pvt.Validate_Lookup(
748: p_init_msg_list => FND_API.G_FALSE,

Line 748: p_init_msg_list => FND_API.G_FALSE,

744: raise FND_API.G_EXC_ERROR;
745: END IF;
746:
747: pv_common_checks_pvt.Validate_Lookup(
748: p_init_msg_list => FND_API.G_FALSE,
749: p_validation_mode => p_validation_mode,
750: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',
751: p_COLUMN_NAME => 'PROCESS_TYPE',
752: p_lookup_type => 'PV_PROCESS_TYPE',

Line 758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

754: x_return_status => x_return_status,
755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data);
757:
758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: raise FND_API.G_EXC_ERROR;
760: END IF;
761:
762: pv_common_checks_pvt.Validate_FLAG(

Line 759: raise FND_API.G_EXC_ERROR;

755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data);
757:
758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: raise FND_API.G_EXC_ERROR;
760: END IF;
761:
762: pv_common_checks_pvt.Validate_FLAG(
763: p_init_msg_list => FND_API.G_FALSE,

Line 763: p_init_msg_list => FND_API.G_FALSE,

759: raise FND_API.G_EXC_ERROR;
760: END IF;
761:
762: pv_common_checks_pvt.Validate_FLAG(
763: p_init_msg_list => FND_API.G_FALSE,
764: p_validation_mode => p_validation_mode,
765: p_FLAG => P_ENTYRLS_Rec.WINNING_RULE_FLAG,
766: x_return_status => x_return_status,
767: x_msg_count => x_msg_count,

Line 770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

766: x_return_status => x_return_status,
767: x_msg_count => x_msg_count,
768: x_msg_data => x_msg_data);
769:
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
771: raise FND_API.G_EXC_ERROR;
772: END IF;
773:
774: pv_common_checks_pvt.Validate_FLAG(

Line 771: raise FND_API.G_EXC_ERROR;

767: x_msg_count => x_msg_count,
768: x_msg_data => x_msg_data);
769:
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
771: raise FND_API.G_EXC_ERROR;
772: END IF;
773:
774: pv_common_checks_pvt.Validate_FLAG(
775: p_init_msg_list => FND_API.G_FALSE,

Line 775: p_init_msg_list => FND_API.G_FALSE,

771: raise FND_API.G_EXC_ERROR;
772: END IF;
773:
774: pv_common_checks_pvt.Validate_FLAG(
775: p_init_msg_list => FND_API.G_FALSE,
776: p_validation_mode => p_validation_mode,
777: p_FLAG => P_ENTYRLS_Rec.LATEST_FLAG,
778: x_return_status => x_return_status,
779: x_msg_count => x_msg_count,

Line 782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

778: x_return_status => x_return_status,
779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data);
781:
782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
783: raise FND_API.G_EXC_ERROR;
784: END IF;
785:
786: pv_common_checks_pvt.Validate_Lookup(

Line 783: raise FND_API.G_EXC_ERROR;

779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data);
781:
782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
783: raise FND_API.G_EXC_ERROR;
784: END IF;
785:
786: pv_common_checks_pvt.Validate_Lookup(
787: p_init_msg_list => FND_API.G_FALSE,

Line 787: p_init_msg_list => FND_API.G_FALSE,

783: raise FND_API.G_EXC_ERROR;
784: END IF;
785:
786: pv_common_checks_pvt.Validate_Lookup(
787: p_init_msg_list => FND_API.G_FALSE,
788: p_validation_mode => p_validation_mode,
789: p_TABLE_NAME => 'PV_ENTITY_RULES_APPLIED',
790: p_COLUMN_NAME => 'PROCESS_STATUS',
791: p_lookup_type => 'PV_RULES_APPLIED_STATUS',

Line 797: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

793: x_return_status => x_return_status,
794: x_msg_count => x_msg_count,
795: x_msg_data => x_msg_data);
796:
797: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
798: raise FND_API.G_EXC_ERROR;
799: END IF;
800:
801: END IF;

Line 798: raise FND_API.G_EXC_ERROR;

794: x_msg_count => x_msg_count,
795: x_msg_data => x_msg_data);
796:
797: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
798: raise FND_API.G_EXC_ERROR;
799: END IF;
800:
801: END IF;
802: