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