[Home] [Help]
16: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
17:
18: PROCEDURE Create_repossession(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
24: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
17:
18: PROCEDURE Create_repossession(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
24: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
25: P_Admin_Group_Id IN NUMBER,
18: PROCEDURE Create_repossession(
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
24: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
25: P_Admin_Group_Id IN NUMBER,
26: P_Identity_Salesforce_Id IN NUMBER,
19: P_Api_Version_Number IN NUMBER,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
24: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
25: P_Admin_Group_Id IN NUMBER,
26: P_Identity_Salesforce_Id IN NUMBER,
27: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
20: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
21: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
22: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
23: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
24: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
25: P_Admin_Group_Id IN NUMBER,
26: P_Identity_Salesforce_Id IN NUMBER,
27: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
28: P_RPS_Rec IN RPS_Rec_Type := G_MISS_RPS_REC,
43: -- Standard Start of API savepoint
44: SAVEPOINT CREATE_REPOSSESSION_PVT;
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
48: p_api_version_number,
49: l_api_name,
50: G_PKG_NAME)
51: THEN
48: p_api_version_number,
49: l_api_name,
50: G_PKG_NAME)
51: THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE.
53: END IF;
54:
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE.
57: IF FND_API.to_Boolean( p_init_msg_list )
58: THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
61:
62:
63:
64: -- Initialize API return status to SUCCESS
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: --
68: -- API body
69: --
77: FND_MESSAGE.Set_Name('IEX', 'UT_CANNOT_GET_PROFILE_VALUE');
78: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
79: FND_MSG_PUB.ADD;
80: END IF;
81: RAISE FND_API.G_EXC_ERROR;
82: END IF;
83:
84:
85: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
81: RAISE FND_API.G_EXC_ERROR;
82: END IF;
83:
84:
85: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
86: THEN
87: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
88: p_api_version_number => 2.0
89: ,p_init_msg_list => p_init_msg_list
94: ,x_msg_data => x_msg_data
95: ,x_sales_member_rec => l_identity_sales_member_rec);
96:
97:
98: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: END IF;
95: ,x_sales_member_rec => l_identity_sales_member_rec);
96:
97:
98: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: END IF;
103:
103:
104:
105: -- Invoke validation procedures
106: Validate_repossession(
107: p_init_msg_list => FND_API.G_FALSE,
108: p_validation_level => p_validation_level,
109: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
110: P_RPS_Rec => P_RPS_Rec,
111: x_return_status => x_return_status,
111: x_return_status => x_return_status,
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data);
114:
115: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119:
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data);
114:
115: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119:
120: IF p_check_access_flag = 'Y'
138: -- ,x_access_flag => l_access_flag);
139:
140:
141:
142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: END IF;
139:
140:
141:
142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: END IF;
147: -- Hint: Add corresponding Master-Detail business logic here if necessary.
198: );
199: -- Hint: Primary key should be returned.
200: -- x_REPOSSESSION_ID := px_REPOSSESSION_ID;
201:
202: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:
206: --
199: -- Hint: Primary key should be returned.
200: -- x_REPOSSESSION_ID := px_REPOSSESSION_ID;
201:
202: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205:
206: --
207: -- End of API body
207: -- End of API body
208: --
209:
210: -- Standard check for p_commit
211: IF FND_API.to_Boolean( p_commit )
212: THEN
213: COMMIT WORK;
214: END IF;
215:
221: p_data => x_msg_data
222: );
223:
224: EXCEPTION
225: WHEN FND_API.G_EXC_ERROR THEN
226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
258:
259: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
260: PROCEDURE Update_repossession(
261: P_Api_Version_Number IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
266: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
259: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
260: PROCEDURE Update_repossession(
261: P_Api_Version_Number IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
266: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
267: P_Admin_Group_Id IN NUMBER,
260: PROCEDURE Update_repossession(
261: P_Api_Version_Number IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
266: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
267: P_Admin_Group_Id IN NUMBER,
268: P_Identity_Salesforce_Id IN NUMBER,
261: P_Api_Version_Number IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
266: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
267: P_Admin_Group_Id IN NUMBER,
268: P_Identity_Salesforce_Id IN NUMBER,
269: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
262: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
266: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
267: P_Admin_Group_Id IN NUMBER,
268: P_Identity_Salesforce_Id IN NUMBER,
269: --P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
270: P_RPS_Rec IN RPS_Rec_Type,
333: -- Standard Start of API savepoint
334: SAVEPOINT UPDATE_REPOSSESSION_PVT;
335:
336: -- Standard call to check for call compatibility.
337: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
338: p_api_version_number,
339: l_api_name,
340: G_PKG_NAME)
341: THEN
338: p_api_version_number,
339: l_api_name,
340: G_PKG_NAME)
341: THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;
344:
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
343: END IF;
344:
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )
348: THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
351:
352:
353:
354: -- Initialize API return status to SUCCESS
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356:
357: --
358: -- Api body
359: --
357: --
358: -- Api body
359: --
360:
361: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
362: THEN
363: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
364: p_api_version_number => 2.0
365: ,p_init_msg_list => p_init_msg_list
370: ,x_msg_data => x_msg_data
371: ,x_sales_member_rec => l_identity_sales_member_rec);
372:
373:
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: END IF;
371: ,x_sales_member_rec => l_identity_sales_member_rec);
372:
373:
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: END IF;
379:
431: FND_MESSAGE.Set_Token ('INFO', 'repossession', FALSE);
432: FND_MSG_PUB.Add;
433: END IF;
434: Close C_Get_repossession;
435: raise FND_API.G_EXC_ERROR;
436: END IF;
437: Close C_Get_repossession;
438: */
439:
438: */
439:
440:
441: If (l_tar_RPS_rec.last_update_date is NULL or
442: l_tar_RPS_rec.last_update_date = FND_API.G_MISS_Date ) Then
443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
444: THEN
445: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
446: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
445: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
446: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
447: FND_MSG_PUB.ADD;
448: END IF;
449: raise FND_API.G_EXC_ERROR;
450: End if;
451: -- Check Whether record has been changed by someone else
452: /*
453: If (l_tar_RPS_rec.last_update_date <> l_ref_RPS_rec.last_update_date) Then
456: FND_MESSAGE.Set_Name('IEX', 'API_RECORD_CHANGED');
457: FND_MESSAGE.Set_Token('INFO', 'repossession', FALSE);
458: FND_MSG_PUB.ADD;
459: END IF;
460: raise FND_API.G_EXC_ERROR;
461: End if;
462: */
463:
464: -- Invoke validation procedures
462: */
463:
464: -- Invoke validation procedures
465: Validate_repossession(
466: p_init_msg_list => FND_API.G_FALSE,
467: p_validation_level => p_validation_level,
468: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
469: P_RPS_Rec => P_RPS_Rec,
470: x_return_status => x_return_status,
470: x_return_status => x_return_status,
471: x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);
473:
474: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478:
471: x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);
473:
474: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478:
479: IF p_check_access_flag = 'Y'
498:
499: -- END IF;
500:
501:
502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: END IF;
499: -- END IF;
500:
501:
502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: END IF;
507: -- Hint: Add corresponding Master-Detail business logic here if necessary.
538: ,p_ATTRIBUTE12 => p_RPS_rec.ATTRIBUTE12
539: ,p_ATTRIBUTE13 => p_RPS_rec.ATTRIBUTE13
540: ,p_ATTRIBUTE14 => p_RPS_rec.ATTRIBUTE14
541: ,p_ATTRIBUTE15 => p_RPS_rec.ATTRIBUTE15
542: ,p_CREATED_BY => FND_API.G_MISS_NUM
543: ,p_CREATION_DATE => FND_API.G_MISS_DATE
544: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
545: ,p_LAST_UPDATE_DATE => SYSDATE
546: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
539: ,p_ATTRIBUTE13 => p_RPS_rec.ATTRIBUTE13
540: ,p_ATTRIBUTE14 => p_RPS_rec.ATTRIBUTE14
541: ,p_ATTRIBUTE15 => p_RPS_rec.ATTRIBUTE15
542: ,p_CREATED_BY => FND_API.G_MISS_NUM
543: ,p_CREATION_DATE => FND_API.G_MISS_DATE
544: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
545: ,p_LAST_UPDATE_DATE => SYSDATE
546: --,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID --commented for bug 10034220 gnramasa 24th Sep 10
547: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
560: -- End of API body.
561: --
562:
563: -- Standard check for p_commit
564: IF FND_API.to_Boolean( p_commit )
565: THEN
566: COMMIT WORK;
567: END IF;
568:
574: p_data => x_msg_data
575: );
576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME
581: ,P_PKG_NAME => G_PKG_NAME
582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
584: ,X_MSG_COUNT => X_MSG_COUNT
585: ,X_MSG_DATA => X_MSG_DATA
586: ,X_RETURN_STATUS => X_RETURN_STATUS);
587:
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
612: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
613: -- The Master delete procedure may not be needed depends on different business requirements.
614: PROCEDURE Delete_repossession(
615: P_Api_Version_Number IN NUMBER,
616: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
620: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
613: -- The Master delete procedure may not be needed depends on different business requirements.
614: PROCEDURE Delete_repossession(
615: P_Api_Version_Number IN NUMBER,
616: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
620: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
621: P_Admin_Group_Id IN NUMBER,
614: PROCEDURE Delete_repossession(
615: P_Api_Version_Number IN NUMBER,
616: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
620: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
621: P_Admin_Group_Id IN NUMBER,
622: P_Identity_Salesforce_Id IN NUMBER,
615: P_Api_Version_Number IN NUMBER,
616: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
620: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
621: P_Admin_Group_Id IN NUMBER,
622: P_Identity_Salesforce_Id IN NUMBER,
623: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
616: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
617: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
618: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
619: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
620: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
621: P_Admin_Group_Id IN NUMBER,
622: P_Identity_Salesforce_Id IN NUMBER,
623: P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
624: P_RPS_Rec IN RPS_Rec_Type,
635: -- Standard Start of API savepoint
636: SAVEPOINT DELETE_REPOSSESSION_PVT;
637:
638: -- Standard call to check for call compatibility.
639: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
640: p_api_version_number,
641: l_api_name,
642: G_PKG_NAME)
643: THEN
640: p_api_version_number,
641: l_api_name,
642: G_PKG_NAME)
643: THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: END IF;
646:
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
645: END IF;
646:
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list )
650: THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653:
654:
655:
656:
657: -- Initialize API return status to SUCCESS
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659:
660: --
661: -- Api body
662: --
660: --
661: -- Api body
662: --
663:
664: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
665: THEN
666: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
667: p_api_version_number => 2.0
668: ,p_init_msg_list => p_init_msg_list
673: ,x_msg_data => x_msg_data
674: ,x_sales_member_rec => l_identity_sales_member_rec);
675:
676:
677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: END IF;
674: ,x_sales_member_rec => l_identity_sales_member_rec);
675:
676:
677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: END IF;
682:
700: -- ,x_msg_data => x_msg_data
701: -- ,x_access_flag => l_access_flag);
702:
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: END IF;
701: -- ,x_access_flag => l_access_flag);
702:
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: END IF;
709:
714: -- End of API body
715: --
716:
717: -- Standard check for p_commit
718: IF FND_API.to_Boolean( p_commit )
719: THEN
720: COMMIT WORK;
721: END IF;
722:
728: p_data => x_msg_data
729: );
730:
731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
734: P_API_NAME => L_API_NAME
735: ,P_PKG_NAME => G_PKG_NAME
736: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
738: ,X_MSG_COUNT => X_MSG_COUNT
739: ,X_MSG_DATA => X_MSG_DATA
740: ,X_RETURN_STATUS => X_RETURN_STATUS);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
744: P_API_NAME => L_API_NAME
745: ,P_PKG_NAME => G_PKG_NAME
746: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
880:
881:
882: AS_UTILITY_PVT.Translate_OrderBy(
883: p_api_version_number => 1.0
884: ,p_init_msg_list => FND_API.G_FALSE
885: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
886: ,p_order_by_tbl => l_util_order_by_tbl
887: ,x_order_by_clause => l_order_by_cl
888: ,x_return_status => x_return_status
881:
882: AS_UTILITY_PVT.Translate_OrderBy(
883: p_api_version_number => 1.0
884: ,p_init_msg_list => FND_API.G_FALSE
885: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
886: ,p_order_by_tbl => l_util_order_by_tbl
887: ,x_order_by_clause => l_order_by_cl
888: ,x_return_status => x_return_status
889: ,x_msg_count => x_msg_count
909: -- Only those that are not NULL
910:
911: -- The following example applies to all columns,
912: -- developers can copy and paste them.
913: IF( (P_RPS_Rec.REPOSSESSION_ID IS NOT NULL) AND (P_RPS_Rec.REPOSSESSION_ID <> FND_API.G_MISS_NUM) )
914: THEN
915: DBMS_SQL.BIND_VARIABLE(p_cur_get_RPS, ':p_REPOSSESSION_ID', P_RPS_Rec.REPOSSESSION_ID);
916: END IF;
917:
998: -- NUMBER, DATE, VARCHAR2.
999: -- Developer can copy and paste the following codes for your own record.
1000:
1001: -- example for NUMBER datatype
1002: IF( (P_RPS_Rec.REPOSSESSION_ID IS NOT NULL) AND (P_RPS_Rec.REPOSSESSION_ID <> FND_API.G_MISS_NUM) )
1003: THEN
1004: IF(x_RPS_where IS NULL) THEN
1005: x_RPS_where := 'Where';
1006: ELSE
1009: x_RPS_where := x_RPS_where || 'P_RPS_Rec.REPOSSESSION_ID = :p_REPOSSESSION_ID';
1010: END IF;
1011:
1012: -- example for DATE datatype
1013: IF( (P_RPS_Rec.REPOSSESSION_DATE IS NOT NULL) AND (P_RPS_Rec.REPOSSESSION_DATE <> FND_API.G_MISS_DATE) )
1014: THEN
1015: -- check if item value contains '%' wildcard
1016: OPEN c_chk_str1(P_RPS_Rec.REPOSSESSION_DATE);
1017: FETCH c_chk_str1 INTO str_csr1;
1042: x_RPS_where := x_RPS_where || 'P_RPS_Rec.REPOSSESSION_DATE ' || l_operator || ' :p_REPOSSESSION_DATE';
1043: END IF;
1044:
1045: -- example for VARCHAR2 datatype
1046: IF( (P_RPS_Rec.UNPAID_REASON_CODE IS NOT NULL) AND (P_RPS_Rec.UNPAID_REASON_CODE <> FND_API.G_MISS_CHAR) )
1047: THEN
1048: -- check if item value contains '%' wildcard
1049: OPEN c_chk_str1(P_RPS_Rec.UNPAID_REASON_CODE);
1050: FETCH c_chk_str1 INTO str_csr1;
1081: END Gen_RPS_Where;
1082:
1083: PROCEDURE Get_repossession(
1084: P_Api_Version_Number IN NUMBER,
1085: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1086: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1087: P_Admin_Group_id IN NUMBER,
1088: P_identity_salesforce_id IN NUMBER := NULL,
1089: P_RPS_Rec IN RPS_Rec_Type, --IEX_repossession_PUB.RPS_Rec_Type,
1082:
1083: PROCEDURE Get_repossession(
1084: P_Api_Version_Number IN NUMBER,
1085: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1086: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1087: P_Admin_Group_id IN NUMBER,
1088: P_identity_salesforce_id IN NUMBER := NULL,
1089: P_RPS_Rec IN RPS_Rec_Type, --IEX_repossession_PUB.RPS_Rec_Type,
1090: -- Hint: Add list of bind variables here
1089: P_RPS_Rec IN RPS_Rec_Type, --IEX_repossession_PUB.RPS_Rec_Type,
1090: -- Hint: Add list of bind variables here
1091: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
1092: p_start_rec_prt IN NUMBER := 1,
1093: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
1094: -- Hint: user defined record type
1095: p_order_by_rec IN RPS_sort_Rec_Type,--IEX_repossession_PUB.RPS_sort_rec_type,
1096: x_return_status OUT NOCOPY VARCHAR2,
1097: x_msg_count OUT NOCOPY NUMBER,
1142: -- Standard Start of API savepoint
1143: SAVEPOINT GET_REPOSSESSION_PVT;
1144:
1145: -- Standard call to check for call compatibility.
1146: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1147: p_api_version_number,
1148: l_api_name,
1149: G_PKG_NAME)
1150: THEN
1147: p_api_version_number,
1148: l_api_name,
1149: G_PKG_NAME)
1150: THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:
1154:
1155: -- Initialize message list if p_init_msg_list is set to TRUE.
1152: END IF;
1153:
1154:
1155: -- Initialize message list if p_init_msg_list is set to TRUE.
1156: IF FND_API.to_Boolean( p_init_msg_list )
1157: THEN
1158: FND_MSG_PUB.initialize;
1159: END IF;
1160:
1161:
1162:
1163:
1164: -- Initialize API return status to SUCCESS
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166:
1167: --
1168: -- Api body
1169: --
1167: --
1168: -- Api body
1169: --
1170:
1171: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
1172: THEN
1173: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1174: p_api_version_number => 2.0
1175: ,p_init_msg_list => p_init_msg_list
1180: ,x_msg_data => x_msg_data
1181: ,x_sales_member_rec => l_identity_sales_member_rec);
1182:
1183:
1184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187:
1188: END IF;
1181: ,x_sales_member_rec => l_identity_sales_member_rec);
1182:
1183:
1184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187:
1188: END IF;
1189: -- *************************************************
1266: LOOP
1267: -- 1. There are more rows in the cursor.
1268: -- 2. User does not care about total records, and we need to return more.
1269: -- 3. Or user cares about total number of records.
1270: IF((dbms_sql.fetch_rows(l_cur_get_RPS)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1271: OR (l_returned_rec_count
1273:
1274: -- Hint: Developer need to implement this part
1267: -- 1. There are more rows in the cursor.
1268: -- 2. User does not care about total records, and we need to return more.
1269: -- 3. Or user cares about total number of records.
1270: IF((dbms_sql.fetch_rows(l_cur_get_RPS)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1271: OR (l_returned_rec_count
1273:
1274: -- Hint: Developer need to implement this part
1275: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1308: p_data => x_msg_data
1309: );
1310:
1311: EXCEPTION
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1314: P_API_NAME => L_API_NAME
1315: ,P_PKG_NAME => G_PKG_NAME
1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1318: ,X_MSG_COUNT => X_MSG_COUNT
1319: ,X_MSG_DATA => X_MSG_DATA
1320: ,X_RETURN_STATUS => X_RETURN_STATUS);
1321:
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1324: P_API_NAME => L_API_NAME
1325: ,P_PKG_NAME => G_PKG_NAME
1326: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1344:
1345:
1346: -- Item-level validation procedures
1347: PROCEDURE Validate_REPOSSESSION_ID (
1348: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1349: P_Validation_mode IN VARCHAR2,
1350: P_REPOSSESSION_ID IN NUMBER,
1351: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1352: X_Return_Status OUT NOCOPY VARCHAR2,
1356: IS
1357: BEGIN
1358:
1359: -- Initialize message list if p_init_msg_list is set to TRUE.
1360: IF FND_API.to_Boolean( p_init_msg_list )
1361: THEN
1362: FND_MSG_PUB.initialize;
1363: END IF;
1364:
1363: END IF;
1364:
1365:
1366: -- Initialize API return status to SUCCESS
1367: x_return_status := FND_API.G_RET_STS_SUCCESS;
1368:
1369: -- validate NOT NULL column
1370: IF(p_REPOSSESSION_ID is NULL)
1371: THEN
1368:
1369: -- validate NOT NULL column
1370: IF(p_REPOSSESSION_ID is NULL)
1371: THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: END IF;
1374:
1375: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1376: THEN
1376: THEN
1377: -- Hint: Validate data
1378: -- IF p_REPOSSESSION_ID is not NULL and p_REPOSSESSION_ID <> G_MISS_CHAR
1379: -- verify if data is valid
1380: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1381: NULL;
1382: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1383: THEN
1384: -- Hint: Validate data
1383: THEN
1384: -- Hint: Validate data
1385: -- IF p_REPOSSESSION_ID <> G_MISS_CHAR
1386: -- verify if data is valid
1387: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1388: NULL;
1389: END IF;
1390:
1391: -- Standard call to get message count and if count is 1, get message info.
1397: END Validate_REPOSSESSION_ID;
1398:
1399:
1400: PROCEDURE Validate_DELINQUENCY_ID (
1401: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1402: P_Validation_mode IN VARCHAR2,
1403: P_DELINQUENCY_ID IN NUMBER,
1404: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1405: X_Return_Status OUT NOCOPY VARCHAR2,
1409: IS
1410: BEGIN
1411:
1412: -- Initialize message list if p_init_msg_list is set to TRUE.
1413: IF FND_API.to_Boolean( p_init_msg_list )
1414: THEN
1415: FND_MSG_PUB.initialize;
1416: END IF;
1417:
1416: END IF;
1417:
1418:
1419: -- Initialize API return status to SUCCESS
1420: x_return_status := FND_API.G_RET_STS_SUCCESS;
1421:
1422: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1423: THEN
1424: -- Hint: Validate data
1423: THEN
1424: -- Hint: Validate data
1425: -- IF p_DELINQUENCY_ID is not NULL and p_DELINQUENCY_ID <> G_MISS_CHAR
1426: -- verify if data is valid
1427: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1428: NULL;
1429: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1430: THEN
1431: -- Hint: Validate data
1430: THEN
1431: -- Hint: Validate data
1432: -- IF p_DELINQUENCY_ID <> G_MISS_CHAR
1433: -- verify if data is valid
1434: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1435: NULL;
1436: END IF;
1437:
1438: -- Standard call to get message count and if count is 1, get message info.
1444: END Validate_DELINQUENCY_ID;
1445:
1446:
1447: PROCEDURE Validate_PARTY_ID (
1448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1449: P_Validation_mode IN VARCHAR2,
1450: P_PARTY_ID IN NUMBER,
1451: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1452: X_Return_Status OUT NOCOPY VARCHAR2,
1456: IS
1457: BEGIN
1458:
1459: -- Initialize message list if p_init_msg_list is set to TRUE.
1460: IF FND_API.to_Boolean( p_init_msg_list )
1461: THEN
1462: FND_MSG_PUB.initialize;
1463: END IF;
1464:
1463: END IF;
1464:
1465:
1466: -- Initialize API return status to SUCCESS
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1470: THEN
1471: -- Hint: Validate data
1470: THEN
1471: -- Hint: Validate data
1472: -- IF p_PARTY_ID is not NULL and p_PARTY_ID <> G_MISS_CHAR
1473: -- verify if data is valid
1474: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1475: NULL;
1476: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1477: THEN
1478: -- Hint: Validate data
1477: THEN
1478: -- Hint: Validate data
1479: -- IF p_PARTY_ID <> G_MISS_CHAR
1480: -- verify if data is valid
1481: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1482: NULL;
1483: END IF;
1484:
1485: -- Standard call to get message count and if count is 1, get message info.
1491: END Validate_PARTY_ID;
1492:
1493:
1494: PROCEDURE Validate_CUST_ACCOUNT_ID (
1495: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1496: P_Validation_mode IN VARCHAR2,
1497: P_CUST_ACCOUNT_ID IN NUMBER,
1498: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1499: X_Return_Status OUT NOCOPY VARCHAR2,
1503: IS
1504: BEGIN
1505:
1506: -- Initialize message list if p_init_msg_list is set to TRUE.
1507: IF FND_API.to_Boolean( p_init_msg_list )
1508: THEN
1509: FND_MSG_PUB.initialize;
1510: END IF;
1511:
1510: END IF;
1511:
1512:
1513: -- Initialize API return status to SUCCESS
1514: x_return_status := FND_API.G_RET_STS_SUCCESS;
1515:
1516: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1517: THEN
1518: -- Hint: Validate data
1517: THEN
1518: -- Hint: Validate data
1519: -- IF p_CUST_ACCOUNT_ID is not NULL and p_CUST_ACCOUNT_ID <> G_MISS_CHAR
1520: -- verify if data is valid
1521: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1522: NULL;
1523: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1524: THEN
1525: -- Hint: Validate data
1524: THEN
1525: -- Hint: Validate data
1526: -- IF p_CUST_ACCOUNT_ID <> G_MISS_CHAR
1527: -- verify if data is valid
1528: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1529: NULL;
1530: END IF;
1531:
1532: -- Standard call to get message count and if count is 1, get message info.
1538: END Validate_CUST_ACCOUNT_ID;
1539:
1540:
1541: PROCEDURE Validate_UNPAID_REASON_CODE (
1542: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1543: P_Validation_mode IN VARCHAR2,
1544: P_UNPAID_REASON_CODE IN VARCHAR2,
1545: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1546: X_Return_Status OUT NOCOPY VARCHAR2,
1550: IS
1551: BEGIN
1552:
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF FND_API.to_Boolean( p_init_msg_list )
1555: THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558:
1557: END IF;
1558:
1559:
1560: -- Initialize API return status to SUCCESS
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;
1562:
1563: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1564: THEN
1565: -- Hint: Validate data
1564: THEN
1565: -- Hint: Validate data
1566: -- IF p_UNPAID_REASON_CODE is not NULL and p_UNPAID_REASON_CODE <> G_MISS_CHAR
1567: -- verify if data is valid
1568: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1569: NULL;
1570: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1571: THEN
1572: -- Hint: Validate data
1571: THEN
1572: -- Hint: Validate data
1573: -- IF p_UNPAID_REASON_CODE <> G_MISS_CHAR
1574: -- verify if data is valid
1575: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1576: NULL;
1577: END IF;
1578:
1579: -- Standard call to get message count and if count is 1, get message info.
1585: END Validate_UNPAID_REASON_CODE;
1586:
1587:
1588: PROCEDURE Validate_REMARKET_FLAG (
1589: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1590: P_Validation_mode IN VARCHAR2,
1591: P_REMARKET_FLAG IN VARCHAR2,
1592: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1593: X_Return_Status OUT NOCOPY VARCHAR2,
1597: IS
1598: BEGIN
1599:
1600: -- Initialize message list if p_init_msg_list is set to TRUE.
1601: IF FND_API.to_Boolean( p_init_msg_list )
1602: THEN
1603: FND_MSG_PUB.initialize;
1604: END IF;
1605:
1604: END IF;
1605:
1606:
1607: -- Initialize API return status to SUCCESS
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1611: THEN
1612: -- Hint: Validate data
1611: THEN
1612: -- Hint: Validate data
1613: -- IF p_REMARKET_FLAG is not NULL and p_REMARKET_FLAG <> G_MISS_CHAR
1614: -- verify if data is valid
1615: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1616: NULL;
1617: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1618: THEN
1619: -- Hint: Validate data
1618: THEN
1619: -- Hint: Validate data
1620: -- IF p_REMARKET_FLAG <> G_MISS_CHAR
1621: -- verify if data is valid
1622: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1623: NULL;
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1632: END Validate_REMARKET_FLAG;
1633:
1634:
1635: PROCEDURE Validate_REPOSSESSION_DATE (
1636: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1637: P_Validation_mode IN VARCHAR2,
1638: P_REPOSSESSION_DATE IN DATE,
1639: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1640: X_Return_Status OUT NOCOPY VARCHAR2,
1644: IS
1645: BEGIN
1646:
1647: -- Initialize message list if p_init_msg_list is set to TRUE.
1648: IF FND_API.to_Boolean( p_init_msg_list )
1649: THEN
1650: FND_MSG_PUB.initialize;
1651: END IF;
1652:
1651: END IF;
1652:
1653:
1654: -- Initialize API return status to SUCCESS
1655: x_return_status := FND_API.G_RET_STS_SUCCESS;
1656:
1657: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1658: THEN
1659: -- Hint: Validate data
1658: THEN
1659: -- Hint: Validate data
1660: -- IF p_REPOSSESSION_DATE is not NULL and p_REPOSSESSION_DATE <> G_MISS_CHAR
1661: -- verify if data is valid
1662: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1663: NULL;
1664: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1665: THEN
1666: -- Hint: Validate data
1665: THEN
1666: -- Hint: Validate data
1667: -- IF p_REPOSSESSION_DATE <> G_MISS_CHAR
1668: -- verify if data is valid
1669: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1670: NULL;
1671: END IF;
1672:
1673: -- Standard call to get message count and if count is 1, get message info.
1679: END Validate_REPOSSESSION_DATE;
1680:
1681:
1682: PROCEDURE Validate_ASSET_ID (
1683: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1684: P_Validation_mode IN VARCHAR2,
1685: P_ASSET_ID IN NUMBER,
1686: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1687: X_Return_Status OUT NOCOPY VARCHAR2,
1691: IS
1692: BEGIN
1693:
1694: -- Initialize message list if p_init_msg_list is set to TRUE.
1695: IF FND_API.to_Boolean( p_init_msg_list )
1696: THEN
1697: FND_MSG_PUB.initialize;
1698: END IF;
1699:
1698: END IF;
1699:
1700:
1701: -- Initialize API return status to SUCCESS
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;
1703:
1704: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1705: THEN
1706: -- Hint: Validate data
1705: THEN
1706: -- Hint: Validate data
1707: -- IF p_ASSET_ID is not NULL and p_ASSET_ID <> G_MISS_CHAR
1708: -- verify if data is valid
1709: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1710: NULL;
1711: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1712: THEN
1713: -- Hint: Validate data
1712: THEN
1713: -- Hint: Validate data
1714: -- IF p_ASSET_ID <> G_MISS_CHAR
1715: -- verify if data is valid
1716: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1717: NULL;
1718: END IF;
1719:
1720: -- Standard call to get message count and if count is 1, get message info.
1726: END Validate_ASSET_ID;
1727:
1728:
1729: PROCEDURE Validate_ASSET_VALUE (
1730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1731: P_Validation_mode IN VARCHAR2,
1732: P_ASSET_VALUE IN NUMBER,
1733: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1734: X_Return_Status OUT NOCOPY VARCHAR2,
1738: IS
1739: BEGIN
1740:
1741: -- Initialize message list if p_init_msg_list is set to TRUE.
1742: IF FND_API.to_Boolean( p_init_msg_list )
1743: THEN
1744: FND_MSG_PUB.initialize;
1745: END IF;
1746:
1745: END IF;
1746:
1747:
1748: -- Initialize API return status to SUCCESS
1749: x_return_status := FND_API.G_RET_STS_SUCCESS;
1750:
1751: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1752: THEN
1753: -- Hint: Validate data
1752: THEN
1753: -- Hint: Validate data
1754: -- IF p_ASSET_VALUE is not NULL and p_ASSET_VALUE <> G_MISS_CHAR
1755: -- verify if data is valid
1756: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1757: NULL;
1758: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1759: THEN
1760: -- Hint: Validate data
1759: THEN
1760: -- Hint: Validate data
1761: -- IF p_ASSET_VALUE <> G_MISS_CHAR
1762: -- verify if data is valid
1763: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1764: NULL;
1765: END IF;
1766:
1767: -- Standard call to get message count and if count is 1, get message info.
1773: END Validate_ASSET_VALUE;
1774:
1775:
1776: PROCEDURE Validate_ASSET_NUMBER (
1777: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1778: P_Validation_mode IN VARCHAR2,
1779: P_ASSET_NUMBER IN NUMBER,
1780: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1781: X_Return_Status OUT NOCOPY VARCHAR2,
1785: IS
1786: BEGIN
1787:
1788: -- Initialize message list if p_init_msg_list is set to TRUE.
1789: IF FND_API.to_Boolean( p_init_msg_list )
1790: THEN
1791: FND_MSG_PUB.initialize;
1792: END IF;
1793:
1792: END IF;
1793:
1794:
1795: -- Initialize API return status to SUCCESS
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;
1797:
1798: -- validate NOT NULL column
1799: IF(p_ASSET_NUMBER is NULL)
1800: THEN
1797:
1798: -- validate NOT NULL column
1799: IF(p_ASSET_NUMBER is NULL)
1800: THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: END IF;
1803:
1804: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1805: THEN
1805: THEN
1806: -- Hint: Validate data
1807: -- IF p_ASSET_NUMBER is not NULL and p_ASSET_NUMBER <> G_MISS_CHAR
1808: -- verify if data is valid
1809: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1810: NULL;
1811: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1812: THEN
1813: -- Hint: Validate data
1812: THEN
1813: -- Hint: Validate data
1814: -- IF p_ASSET_NUMBER <> G_MISS_CHAR
1815: -- verify if data is valid
1816: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1817: NULL;
1818: END IF;
1819:
1820: -- Standard call to get message count and if count is 1, get message info.
1826: END Validate_ASSET_NUMBER;
1827:
1828:
1829: PROCEDURE v_CREDIT_HOLD_REQUEST_FLAG (
1830: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1831: P_Validation_mode IN VARCHAR2,
1832: P_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2,
1833: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1834: X_Return_Status OUT NOCOPY VARCHAR2,
1838: IS
1839: BEGIN
1840:
1841: -- Initialize message list if p_init_msg_list is set to TRUE.
1842: IF FND_API.to_Boolean( p_init_msg_list )
1843: THEN
1844: FND_MSG_PUB.initialize;
1845: END IF;
1846:
1845: END IF;
1846:
1847:
1848: -- Initialize API return status to SUCCESS
1849: x_return_status := FND_API.G_RET_STS_SUCCESS;
1850:
1851: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1852: THEN
1853: -- Hint: Validate data
1852: THEN
1853: -- Hint: Validate data
1854: -- IF p_CREDIT_HOLD_REQUEST_FLAG is not NULL and p_CREDIT_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1855: -- verify if data is valid
1856: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1857: NULL;
1858: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1859: THEN
1860: -- Hint: Validate data
1859: THEN
1860: -- Hint: Validate data
1861: -- IF p_CREDIT_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1862: -- verify if data is valid
1863: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1864: NULL;
1865: END IF;
1866:
1867: -- Standard call to get message count and if count is 1, get message info.
1873: END v_CREDIT_HOLD_REQUEST_FLAG;
1874:
1875:
1876: PROCEDURE v_CREDIT_HOLD_APPROVED_FLAG (
1877: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1878: P_Validation_mode IN VARCHAR2,
1879: P_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2,
1880: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1881: X_Return_Status OUT NOCOPY VARCHAR2,
1885: IS
1886: BEGIN
1887:
1888: -- Initialize message list if p_init_msg_list is set to TRUE.
1889: IF FND_API.to_Boolean( p_init_msg_list )
1890: THEN
1891: FND_MSG_PUB.initialize;
1892: END IF;
1893:
1892: END IF;
1893:
1894:
1895: -- Initialize API return status to SUCCESS
1896: x_return_status := FND_API.G_RET_STS_SUCCESS;
1897:
1898: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1899: THEN
1900: -- Hint: Validate data
1899: THEN
1900: -- Hint: Validate data
1901: -- IF p_CREDIT_HOLD_APPROVED_FLAG is not NULL and p_CREDIT_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1902: -- verify if data is valid
1903: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1904: NULL;
1905: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1906: THEN
1907: -- Hint: Validate data
1906: THEN
1907: -- Hint: Validate data
1908: -- IF p_CREDIT_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1909: -- verify if data is valid
1910: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1911: NULL;
1912: END IF;
1913:
1914: -- Standard call to get message count and if count is 1, get message info.
1920: END v_CREDIT_HOLD_APPROVED_FLAG;
1921:
1922:
1923: PROCEDURE v_SERVICE_HOLD_REQUEST_FLAG (
1924: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1925: P_Validation_mode IN VARCHAR2,
1926: P_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2,
1927: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1928: X_Return_Status OUT NOCOPY VARCHAR2,
1932: IS
1933: BEGIN
1934:
1935: -- Initialize message list if p_init_msg_list is set to TRUE.
1936: IF FND_API.to_Boolean( p_init_msg_list )
1937: THEN
1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1939: END IF;
1940:
1941:
1942: -- Initialize API return status to SUCCESS
1943: x_return_status := FND_API.G_RET_STS_SUCCESS;
1944:
1945: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1946: THEN
1947: -- Hint: Validate data
1946: THEN
1947: -- Hint: Validate data
1948: -- IF p_SERVICE_HOLD_REQUEST_FLAG is not NULL and p_SERVICE_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1949: -- verify if data is valid
1950: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1951: NULL;
1952: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1953: THEN
1954: -- Hint: Validate data
1953: THEN
1954: -- Hint: Validate data
1955: -- IF p_SERVICE_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1956: -- verify if data is valid
1957: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1958: NULL;
1959: END IF;
1960:
1961: -- Standard call to get message count and if count is 1, get message info.
1967: END v_SERVICE_HOLD_REQUEST_FLAG;
1968:
1969:
1970: PROCEDURE v_SERVICE_HOLD_APPROVED_FLAG (
1971: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1972: P_Validation_mode IN VARCHAR2,
1973: P_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2,
1974: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1975: X_Return_Status OUT NOCOPY VARCHAR2,
1979: IS
1980: BEGIN
1981:
1982: -- Initialize message list if p_init_msg_list is set to TRUE.
1983: IF FND_API.to_Boolean( p_init_msg_list )
1984: THEN
1985: FND_MSG_PUB.initialize;
1986: END IF;
1987:
1986: END IF;
1987:
1988:
1989: -- Initialize API return status to SUCCESS
1990: x_return_status := FND_API.G_RET_STS_SUCCESS;
1991:
1992: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1993: THEN
1994: -- Hint: Validate data
1993: THEN
1994: -- Hint: Validate data
1995: -- IF p_SERVICE_HOLD_APPROVED_FLAG is not NULL and p_SERVICE_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1996: -- verify if data is valid
1997: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1998: NULL;
1999: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2000: THEN
2001: -- Hint: Validate data
2000: THEN
2001: -- Hint: Validate data
2002: -- IF p_SERVICE_HOLD_APPROVED_FLAG <> G_MISS_CHAR
2003: -- verify if data is valid
2004: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2005: NULL;
2006: END IF;
2007:
2008: -- Standard call to get message count and if count is 1, get message info.
2014: END v_SERVICE_HOLD_APPROVED_FLAG;
2015:
2016:
2017: PROCEDURE v_SUGGESTION_APPROVED_FLAG (
2018: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2019: P_Validation_mode IN VARCHAR2,
2020: P_SUGGESTION_APPROVED_FLAG IN VARCHAR2,
2021: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2022: X_Return_Status OUT NOCOPY VARCHAR2,
2026: IS
2027: BEGIN
2028:
2029: -- Initialize message list if p_init_msg_list is set to TRUE.
2030: IF FND_API.to_Boolean( p_init_msg_list )
2031: THEN
2032: FND_MSG_PUB.initialize;
2033: END IF;
2034:
2033: END IF;
2034:
2035:
2036: -- Initialize API return status to SUCCESS
2037: x_return_status := FND_API.G_RET_STS_SUCCESS;
2038:
2039: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
2040: THEN
2041: -- Hint: Validate data
2040: THEN
2041: -- Hint: Validate data
2042: -- IF p_SUGGESTION_APPROVED_FLAG is not NULL and p_SUGGESTION_APPROVED_FLAG <> G_MISS_CHAR
2043: -- verify if data is valid
2044: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2045: NULL;
2046: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2047: THEN
2048: -- Hint: Validate data
2047: THEN
2048: -- Hint: Validate data
2049: -- IF p_SUGGESTION_APPROVED_FLAG <> G_MISS_CHAR
2050: -- verify if data is valid
2051: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2052: NULL;
2053: END IF;
2054:
2055: -- Standard call to get message count and if count is 1, get message info.
2065: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
2066: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
2067: -- stored in database table.
2068: PROCEDURE Validate_RPS_rec(
2069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2070: P_Validation_mode IN VARCHAR2,
2071: P_RPS_Rec IN RPS_Rec_Type,
2072: X_Return_Status OUT NOCOPY VARCHAR2,
2073: X_Msg_Count OUT NOCOPY NUMBER,
2076: IS
2077: BEGIN
2078:
2079: -- Initialize message list if p_init_msg_list is set to TRUE.
2080: IF FND_API.to_Boolean( p_init_msg_list )
2081: THEN
2082: FND_MSG_PUB.initialize;
2083: END IF;
2084:
2083: END IF;
2084:
2085:
2086: -- Initialize API return status to SUCCESS
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088:
2089: -- Hint: Validate data
2090: -- If data not valid
2091: -- THEN
2088:
2089: -- Hint: Validate data
2090: -- If data not valid
2091: -- THEN
2092: -- x_return_status := FND_API.G_RET_STS_ERROR;
2093:
2094:
2095: -- Standard call to get message count and if count is 1, get message info.
2096: FND_MSG_PUB.Count_And_Get
2100:
2101: END Validate_RPS_Rec;
2102:
2103: PROCEDURE Validate_repossession(
2104: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2105: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2106: P_Validation_mode IN VARCHAR2,
2107: P_RPS_Rec IN RPS_Rec_Type,
2108: X_Return_Status OUT NOCOPY VARCHAR2,
2101: END Validate_RPS_Rec;
2102:
2103: PROCEDURE Validate_repossession(
2104: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2105: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2106: P_Validation_mode IN VARCHAR2,
2107: P_RPS_Rec IN RPS_Rec_Type,
2108: X_Return_Status OUT NOCOPY VARCHAR2,
2109: X_Msg_Count OUT NOCOPY NUMBER,
2114: BEGIN
2115:
2116:
2117: -- Initialize API return status to SUCCESS
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
2121: -- Hint: We provide validation procedure for every column. Developer should delete
2122: -- unnecessary validation procedures.
2120: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
2121: -- Hint: We provide validation procedure for every column. Developer should delete
2122: -- unnecessary validation procedures.
2123: Validate_REPOSSESSION_ID(
2124: p_init_msg_list => FND_API.G_FALSE,
2125: p_validation_mode => p_validation_mode,
2126: p_REPOSSESSION_ID => P_RPS_Rec.REPOSSESSION_ID,
2127: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2128: x_return_status => x_return_status,
2129: x_msg_count => x_msg_count,
2130: x_msg_data => x_msg_data);
2131:
2132: Validate_DELINQUENCY_ID(
2133: p_init_msg_list => FND_API.G_FALSE,
2134: p_validation_mode => p_validation_mode,
2135: p_DELINQUENCY_ID => P_RPS_Rec.DELINQUENCY_ID,
2136: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2137: x_return_status => x_return_status,
2138: x_msg_count => x_msg_count,
2139: x_msg_data => x_msg_data);
2140:
2141: Validate_PARTY_ID(
2142: p_init_msg_list => FND_API.G_FALSE,
2143: p_validation_mode => p_validation_mode,
2144: p_PARTY_ID => P_RPS_Rec.PARTY_ID,
2145: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2146: x_return_status => x_return_status,
2147: x_msg_count => x_msg_count,
2148: x_msg_data => x_msg_data);
2149:
2150: Validate_CUST_ACCOUNT_ID(
2151: p_init_msg_list => FND_API.G_FALSE,
2152: p_validation_mode => p_validation_mode,
2153: p_CUST_ACCOUNT_ID => P_RPS_Rec.CUST_ACCOUNT_ID,
2154: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2155: x_return_status => x_return_status,
2156: x_msg_count => x_msg_count,
2157: x_msg_data => x_msg_data);
2158:
2159: Validate_UNPAID_REASON_CODE(
2160: p_init_msg_list => FND_API.G_FALSE,
2161: p_validation_mode => p_validation_mode,
2162: p_UNPAID_REASON_CODE => P_RPS_Rec.UNPAID_REASON_CODE,
2163: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2164: x_return_status => x_return_status,
2165: x_msg_count => x_msg_count,
2166: x_msg_data => x_msg_data);
2167:
2168: Validate_REMARKET_FLAG(
2169: p_init_msg_list => FND_API.G_FALSE,
2170: p_validation_mode => p_validation_mode,
2171: p_REMARKET_FLAG => P_RPS_Rec.REMARKET_FLAG,
2172: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2173: x_return_status => x_return_status,
2174: x_msg_count => x_msg_count,
2175: x_msg_data => x_msg_data);
2176:
2177: Validate_REPOSSESSION_DATE(
2178: p_init_msg_list => FND_API.G_FALSE,
2179: p_validation_mode => p_validation_mode,
2180: p_REPOSSESSION_DATE => P_RPS_Rec.REPOSSESSION_DATE,
2181: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2182: x_return_status => x_return_status,
2183: x_msg_count => x_msg_count,
2184: x_msg_data => x_msg_data);
2185:
2186: Validate_ASSET_ID(
2187: p_init_msg_list => FND_API.G_FALSE,
2188: p_validation_mode => p_validation_mode,
2189: p_ASSET_ID => P_RPS_Rec.ASSET_ID,
2190: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2191: x_return_status => x_return_status,
2192: x_msg_count => x_msg_count,
2193: x_msg_data => x_msg_data);
2194:
2195: Validate_ASSET_VALUE(
2196: p_init_msg_list => FND_API.G_FALSE,
2197: p_validation_mode => p_validation_mode,
2198: p_ASSET_VALUE => P_RPS_Rec.ASSET_VALUE,
2199: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2200: x_return_status => x_return_status,
2201: x_msg_count => x_msg_count,
2202: x_msg_data => x_msg_data);
2203:
2204: Validate_ASSET_NUMBER(
2205: p_init_msg_list => FND_API.G_FALSE,
2206: p_validation_mode => p_validation_mode,
2207: p_ASSET_NUMBER => P_RPS_Rec.ASSET_NUMBER,
2208: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2209: x_return_status => x_return_status,
2210: x_msg_count => x_msg_count,
2211: x_msg_data => x_msg_data);
2212:
2213: v_CREDIT_HOLD_REQUEST_FLAG(
2214: p_init_msg_list => FND_API.G_FALSE,
2215: p_validation_mode => p_validation_mode,
2216: p_CREDIT_HOLD_REQUEST_FLAG => P_RPS_Rec.CREDIT_HOLD_REQUEST_FLAG,
2217: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2218: x_return_status => x_return_status,
2219: x_msg_count => x_msg_count,
2220: x_msg_data => x_msg_data);
2221:
2222: v_CREDIT_HOLD_APPROVED_FLAG(
2223: p_init_msg_list => FND_API.G_FALSE,
2224: p_validation_mode => p_validation_mode,
2225: p_CREDIT_HOLD_APPROVED_FLAG => P_RPS_Rec.CREDIT_HOLD_APPROVED_FLAG,
2226: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2227: x_return_status => x_return_status,
2228: x_msg_count => x_msg_count,
2229: x_msg_data => x_msg_data);
2230:
2231: v_SERVICE_HOLD_REQUEST_FLAG(
2232: p_init_msg_list => FND_API.G_FALSE,
2233: p_validation_mode => p_validation_mode,
2234: p_SERVICE_HOLD_REQUEST_FLAG => P_RPS_Rec.SERVICE_HOLD_REQUEST_FLAG,
2235: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2236: x_return_status => x_return_status,
2237: x_msg_count => x_msg_count,
2238: x_msg_data => x_msg_data);
2239:
2240: v_SERVICE_HOLD_APPROVED_FLAG(
2241: p_init_msg_list => FND_API.G_FALSE,
2242: p_validation_mode => p_validation_mode,
2243: p_SERVICE_HOLD_APPROVED_FLAG => P_RPS_Rec.SERVICE_HOLD_APPROVED_FLAG,
2244: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2245: x_return_status => x_return_status,
2246: x_msg_count => x_msg_count,
2247: x_msg_data => x_msg_data);
2248:
2249: v_SUGGESTION_APPROVED_FLAG(
2250: p_init_msg_list => FND_API.G_FALSE,
2251: p_validation_mode => p_validation_mode,
2252: p_SUGGESTION_APPROVED_FLAG => P_RPS_Rec.SUGGESTION_APPROVED_FLAG,
2253: -- Hint: You may add x_item_property_rec as one of your OUT NOCOPY parameter if you'd like to pass back item property.
2254: x_return_status => x_return_status,
2260: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
2261: -- Hint: Inter-field level validation can be added here
2262: -- invoke record level validation procedures
2263: Validate_RPS_Rec(
2264: p_init_msg_list => FND_API.G_FALSE,
2265: p_validation_mode => p_validation_mode,
2266: P_RPS_Rec => P_RPS_Rec,
2267: x_return_status => x_return_status,
2268: x_msg_count => x_msg_count,
2267: x_return_status => x_return_status,
2268: x_msg_count => x_msg_count,
2269: x_msg_data => x_msg_data);
2270:
2271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272: raise FND_API.G_EXC_ERROR;
2273: END IF;
2274: END IF;
2275:
2268: x_msg_count => x_msg_count,
2269: x_msg_data => x_msg_data);
2270:
2271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272: raise FND_API.G_EXC_ERROR;
2273: END IF;
2274: END IF;
2275:
2276: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_INTER_RECORD) THEN