[Home] [Help]
18:
19: -- Hint: Primary key needs to be returned.
20: PROCEDURE Create_repair_history(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
26: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
19: -- Hint: Primary key needs to be returned.
20: PROCEDURE Create_repair_history(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
26: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
27: X_REPAIR_HISTORY_ID OUT NOCOPY NUMBER,
20: PROCEDURE Create_repair_history(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
26: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
27: X_REPAIR_HISTORY_ID OUT NOCOPY NUMBER,
28: X_Return_Status OUT NOCOPY VARCHAR2,
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_REPAIR_HISTORY_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
47: THEN
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
47: THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50:
51:
52: -- Initialize message list if p_init_msg_list is set to TRUE.
49: END IF;
50:
51:
52: -- Initialize message list if p_init_msg_list is set to TRUE.
53: IF FND_API.to_Boolean( p_init_msg_list )
54: THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
60: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
61:
62:
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: --
67: -- API body
68: --
73: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
74: THEN
75: AS_CALLOUT_PKG.Create_repair_history_BC(
76: p_api_version_number => 2.0,
77: p_init_msg_list => FND_API.G_FALSE,
78: p_commit => FND_API.G_FALSE,
79: p_validation_level => p_validation_level,
80: P_REPH_Rec => P_REPH_Rec,
81: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
74: THEN
75: AS_CALLOUT_PKG.Create_repair_history_BC(
76: p_api_version_number => 2.0,
77: p_init_msg_list => FND_API.G_FALSE,
78: p_commit => FND_API.G_FALSE,
79: p_validation_level => p_validation_level,
80: P_REPH_Rec => P_REPH_Rec,
81: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
82: x_return_status => x_return_status,
94: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
95: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
96: FND_MSG_PUB.ADD;
97: END IF;
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101: /*
102: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
106: ,x_msg_count => x_msg_count
107: ,x_msg_data => x_msg_data
108: ,x_sales_member_rec => l_identity_sales_member_rec);
109:
110: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113: */
114:
107: ,x_msg_data => x_msg_data
108: ,x_sales_member_rec => l_identity_sales_member_rec);
109:
110: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113: */
114:
115: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113: */
114:
115: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
116: THEN
117: -- Debug message
118: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
119:
123: END IF;
124:
125:
126: Validate_repair_history(
127: p_init_msg_list => FND_API.G_FALSE,
128: p_validation_level => p_validation_level,
129: p_validation_mode => JTF_PLSQL_API.G_CREATE,
130: P_REPH_Rec => P_REPH_Rec,
131: x_return_status => x_return_status,
138:
139:
140: END IF;
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: -- Hint: Add corresponding Master-Detail business logic here if necessary.
139:
140: END IF;
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: -- Hint: Add corresponding Master-Detail business logic here if necessary.
147:
225: END IF;
226:
227:
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233: --
226:
227:
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233: --
234: -- End of API body
234: -- End of API body
235: --
236:
237: -- Standard check for p_commit
238: IF FND_API.to_Boolean( p_commit )
239: THEN
240: COMMIT WORK;
241: END IF;
242:
257: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
258: THEN
259: AS_CALLOUT_PKG.Create_repair_history_AC(
260: p_api_version_number => 2.0,
261: p_init_msg_list => FND_API.G_FALSE,
262: p_commit => FND_API.G_FALSE,
263: p_validation_level => p_validation_level,
264: P_REPH_Rec => P_REPH_Rec,
265: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
258: THEN
259: AS_CALLOUT_PKG.Create_repair_history_AC(
260: p_api_version_number => 2.0,
261: p_init_msg_list => FND_API.G_FALSE,
262: p_commit => FND_API.G_FALSE,
263: p_validation_level => p_validation_level,
264: P_REPH_Rec => P_REPH_Rec,
265: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
266: x_return_status => x_return_status,
268: x_msg_data => x_msg_data);
269: END IF;
270: */
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
279: ,X_MSG_DATA => X_MSG_DATA
280: ,X_RETURN_STATUS => X_RETURN_STATUS);
281: -- RAISE;
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
285: P_API_NAME => L_API_NAME
286: ,P_PKG_NAME => G_PKG_NAME
287: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
306:
307: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
308: PROCEDURE Update_repair_history(
309: P_Api_Version_Number IN NUMBER,
310: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
311: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: P_REPH_Rec IN REPH_Rec_Type,
314: X_Return_Status OUT NOCOPY VARCHAR2,
307: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
308: PROCEDURE Update_repair_history(
309: P_Api_Version_Number IN NUMBER,
310: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
311: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: P_REPH_Rec IN REPH_Rec_Type,
314: X_Return_Status OUT NOCOPY VARCHAR2,
315: X_Msg_Count OUT NOCOPY NUMBER,
308: PROCEDURE Update_repair_history(
309: P_Api_Version_Number IN NUMBER,
310: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
311: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: P_REPH_Rec IN REPH_Rec_Type,
314: X_Return_Status OUT NOCOPY VARCHAR2,
315: X_Msg_Count OUT NOCOPY NUMBER,
316: X_Msg_Data OUT NOCOPY VARCHAR2
400: -- Standard Start of API savepoint
401: SAVEPOINT UPDATE_REPAIR_HISTORY_PVT;
402:
403: -- Standard call to check for call compatibility.
404: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
405: p_api_version_number,
406: l_api_name,
407: G_PKG_NAME)
408: THEN
405: p_api_version_number,
406: l_api_name,
407: G_PKG_NAME)
408: THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411:
412:
413: -- Initialize message list if p_init_msg_list is set to TRUE.
410: END IF;
411:
412:
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list )
415: THEN
416: FND_MSG_PUB.initialize;
417: END IF;
418:
421: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
422:
423:
424: -- Initialize API return status to SUCCESS
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: --
428: -- Api body
429: --
433: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
434: THEN
435: AS_CALLOUT_PKG.Update_repair_history_BU(
436: p_api_version_number => 2.0,
437: p_init_msg_list => FND_API.G_FALSE,
438: p_commit => FND_API.G_FALSE,
439: p_validation_level => p_validation_level,
440: p_identity_salesforce_id => p_identity_salesforce_id,
441: P_REPH_Rec => P_REPH_Rec,
434: THEN
435: AS_CALLOUT_PKG.Update_repair_history_BU(
436: p_api_version_number => 2.0,
437: p_init_msg_list => FND_API.G_FALSE,
438: p_commit => FND_API.G_FALSE,
439: p_validation_level => p_validation_level,
440: p_identity_salesforce_id => p_identity_salesforce_id,
441: P_REPH_Rec => P_REPH_Rec,
442: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
453: ,x_msg_count => x_msg_count
454: ,x_msg_data => x_msg_data
455: ,x_sales_member_rec => l_identity_sales_member_rec);
456:
457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;
460: */
461: -- Debug Message
454: ,x_msg_data => x_msg_data
455: ,x_sales_member_rec => l_identity_sales_member_rec);
456:
457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;
460: */
461: -- Debug Message
462: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Open Cursor to Select');
534: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
535: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
536: FND_MSG_PUB.Add;
537: END IF;
538: raise FND_API.G_EXC_ERROR;
539: END IF;
540: -- Debug Message
541: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Close Cursor');
542: Close C_Get_repair_history;
543: */
544:
545:
546: If (l_tar_REPH_rec.last_update_date is NULL or
547: l_tar_REPH_rec.last_update_date = FND_API.G_MISS_Date ) Then
548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
549: THEN
550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
552: FND_MSG_PUB.ADD;
553: END IF;
554: raise FND_API.G_EXC_ERROR;
555: End if;
556: -- Check Whether record has been changed by someone else
557: If (l_tar_REPH_rec.last_update_date <> l_ref_REPH_rec.last_update_date) Then
558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
560: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
561: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
562: FND_MSG_PUB.ADD;
563: END IF;
564: raise FND_API.G_EXC_ERROR;
565: End if;
566:
567: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
568: THEN
563: END IF;
564: raise FND_API.G_EXC_ERROR;
565: End if;
566:
567: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
568: THEN
569: -- Debug message
570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
571:
570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
571:
572: -- Invoke validation procedures
573: Validate_repair_history(
574: p_init_msg_list => FND_API.G_FALSE,
575: p_validation_level => p_validation_level,
576: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
577: P_REPH_Rec => P_REPH_Rec,
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,
580: x_msg_data => x_msg_data);
581: END IF;
582:
583: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: -- Hint: Add corresponding Master-Detail business logic here if necessary.
580: x_msg_data => x_msg_data);
581: END IF;
582:
583: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: -- Hint: Add corresponding Master-Detail business logic here if necessary.
588:
600: p_PROGRAM_ID => p_REPH_rec.PROGRAM_ID,
601: p_PROGRAM_APPLICATION_ID => p_REPH_rec.PROGRAM_APPLICATION_ID,
602: p_PROGRAM_UPDATE_DATE => p_REPH_rec.PROGRAM_UPDATE_DATE,
603: --bug#12697494, yvchen: does not allow updating of CREATED_BY
604: p_CREATED_BY => FND_API.G_MISS_NUM, --p_CREATED_BY => G_USER_ID,
605: p_CREATION_DATE => SYSDATE,
606: --bug#12697494, yvchen
607: p_LAST_UPDATED_BY => p_REPH_rec.LAST_UPDATED_BY, --p_LAST_UPDATED_BY => G_USER_ID,
608: p_LAST_UPDATE_DATE => SYSDATE,
661: -- End of API body.
662: --
663:
664: -- Standard check for p_commit
665: IF FND_API.to_Boolean( p_commit )
666: THEN
667: COMMIT WORK;
668: END IF;
669:
684: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
685: THEN
686: AS_CALLOUT_PKG.Update_repair_history_AU(
687: p_api_version_number => 2.0,
688: p_init_msg_list => FND_API.G_FALSE,
689: p_commit => FND_API.G_FALSE,
690: p_validation_level => p_validation_level,
691: p_identity_salesforce_id => p_identity_salesforce_id,
692: P_REPH_Rec => P_REPH_Rec,
685: THEN
686: AS_CALLOUT_PKG.Update_repair_history_AU(
687: p_api_version_number => 2.0,
688: p_init_msg_list => FND_API.G_FALSE,
689: p_commit => FND_API.G_FALSE,
690: p_validation_level => p_validation_level,
691: p_identity_salesforce_id => p_identity_salesforce_id,
692: P_REPH_Rec => P_REPH_Rec,
693: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
696: x_msg_data => x_msg_data);
697: END IF;
698: */
699: EXCEPTION
700: WHEN FND_API.G_EXC_ERROR THEN
701: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
702: P_API_NAME => L_API_NAME
703: ,P_PKG_NAME => G_PKG_NAME
704: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
707: ,X_MSG_DATA => X_MSG_DATA
708: ,X_RETURN_STATUS => X_RETURN_STATUS);
709: -- RAISE;
710:
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
713: P_API_NAME => L_API_NAME
714: ,P_PKG_NAME => G_PKG_NAME
715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
735: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
736: -- The Master delete procedure may not be needed depends on different business requirements.
737: PROCEDURE Delete_repair_history(
738: P_Api_Version_Number IN NUMBER,
739: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
740: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: P_REPH_Rec IN REPH_Rec_Type,
743: X_Return_Status OUT NOCOPY VARCHAR2,
736: -- The Master delete procedure may not be needed depends on different business requirements.
737: PROCEDURE Delete_repair_history(
738: P_Api_Version_Number IN NUMBER,
739: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
740: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: P_REPH_Rec IN REPH_Rec_Type,
743: X_Return_Status OUT NOCOPY VARCHAR2,
744: X_Msg_Count OUT NOCOPY NUMBER,
737: PROCEDURE Delete_repair_history(
738: P_Api_Version_Number IN NUMBER,
739: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
740: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
741: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742: P_REPH_Rec IN REPH_Rec_Type,
743: X_Return_Status OUT NOCOPY VARCHAR2,
744: X_Msg_Count OUT NOCOPY NUMBER,
745: X_Msg_Data OUT NOCOPY VARCHAR2
753: -- Standard Start of API savepoint
754: SAVEPOINT DELETE_REPAIR_HISTORY_PVT;
755:
756: -- Standard call to check for call compatibility.
757: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
758: p_api_version_number,
759: l_api_name,
760: G_PKG_NAME)
761: THEN
758: p_api_version_number,
759: l_api_name,
760: G_PKG_NAME)
761: THEN
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF;
764:
765:
766: -- Initialize message list if p_init_msg_list is set to TRUE.
763: END IF;
764:
765:
766: -- Initialize message list if p_init_msg_list is set to TRUE.
767: IF FND_API.to_Boolean( p_init_msg_list )
768: THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:
774: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
775:
776:
777: -- Initialize API return status to SUCCESS
778: x_return_status := FND_API.G_RET_STS_SUCCESS;
779:
780: --
781: -- Api body
782: --
786: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
787: THEN
788: AS_CALLOUT_PKG.Delete_repair_history_BD(
789: p_api_version_number => 2.0,
790: p_init_msg_list => FND_API.G_FALSE,
791: p_commit => FND_API.G_FALSE,
792: p_validation_level => p_validation_level,
793: p_identity_salesforce_id => p_identity_salesforce_id,
794: P_REPH_Rec => P_REPH_Rec,
787: THEN
788: AS_CALLOUT_PKG.Delete_repair_history_BD(
789: p_api_version_number => 2.0,
790: p_init_msg_list => FND_API.G_FALSE,
791: p_commit => FND_API.G_FALSE,
792: p_validation_level => p_validation_level,
793: p_identity_salesforce_id => p_identity_salesforce_id,
794: P_REPH_Rec => P_REPH_Rec,
795: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
806: ,x_msg_count => x_msg_count
807: ,x_msg_data => x_msg_data
808: ,x_sales_member_rec => l_identity_sales_member_rec);
809:
810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;
813: */
814:
807: ,x_msg_data => x_msg_data
808: ,x_sales_member_rec => l_identity_sales_member_rec);
809:
810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;
813: */
814:
815: -- Debug Message
823: -- End of API body
824: --
825:
826: -- Standard check for p_commit
827: IF FND_API.to_Boolean( p_commit )
828: THEN
829: COMMIT WORK;
830: END IF;
831:
846: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
847: THEN
848: AS_CALLOUT_PKG.Delete_repair_history_AD(
849: p_api_version_number => 2.0,
850: p_init_msg_list => FND_API.G_FALSE,
851: p_commit => FND_API.G_FALSE,
852: p_validation_level => p_validation_level,
853: p_identity_salesforce_id => p_identity_salesforce_id,
854: P_REPH_Rec => P_REPH_Rec,
847: THEN
848: AS_CALLOUT_PKG.Delete_repair_history_AD(
849: p_api_version_number => 2.0,
850: p_init_msg_list => FND_API.G_FALSE,
851: p_commit => FND_API.G_FALSE,
852: p_validation_level => p_validation_level,
853: p_identity_salesforce_id => p_identity_salesforce_id,
854: P_REPH_Rec => P_REPH_Rec,
855: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
858: x_msg_data => x_msg_data);
859: END IF;
860: */
861: EXCEPTION
862: WHEN FND_API.G_EXC_ERROR THEN
863: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
864: P_API_NAME => L_API_NAME
865: ,P_PKG_NAME => G_PKG_NAME
866: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
869: ,X_MSG_DATA => X_MSG_DATA
870: ,X_RETURN_STATUS => X_RETURN_STATUS);
871: -- RAISE;
872:
873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
874: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
875: P_API_NAME => L_API_NAME
876: ,P_PKG_NAME => G_PKG_NAME
877: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1057: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
1058:
1059: JTF_PLSQL_API.Translate_OrderBy(
1060: p_api_version_number => 1.0
1061: ,p_init_msg_list => FND_API.G_FALSE
1062: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1063: ,p_order_by_tbl => l_util_order_by_tbl
1064: ,x_order_by_clause => l_order_by_cl
1065: ,x_return_status => x_return_status
1058:
1059: JTF_PLSQL_API.Translate_OrderBy(
1060: p_api_version_number => 1.0
1061: ,p_init_msg_list => FND_API.G_FALSE
1062: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1063: ,p_order_by_tbl => l_util_order_by_tbl
1064: ,x_order_by_clause => l_order_by_cl
1065: ,x_return_status => x_return_status
1066: ,x_msg_count => x_msg_count
1090: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Begins');
1091:
1092: -- The following example applies to all columns,
1093: -- developers can copy and paste them.
1094: IF( (P_REPH_Rec.REPAIR_HISTORY_ID IS NOT NULL) AND (P_REPH_Rec.REPAIR_HISTORY_ID <> FND_API.G_MISS_NUM) )
1095: THEN
1096: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPH, ':p_REPAIR_HISTORY_ID', P_REPH_Rec.REPAIR_HISTORY_ID);
1097: END IF;
1098:
1203: -- NUMBER, DATE, VARCHAR2.
1204: -- Developer can copy and paste the following codes for your own record.
1205:
1206: -- example for NUMBER datatype
1207: IF( (P_REPH_Rec.REPAIR_HISTORY_ID IS NOT NULL) AND (P_REPH_Rec.REPAIR_HISTORY_ID <> FND_API.G_MISS_NUM) )
1208: THEN
1209: IF(x_REPH_where IS NULL) THEN
1210: x_REPH_where := 'Where';
1211: ELSE
1214: x_REPH_where := x_REPH_where || 'P_REPH_Rec.REPAIR_HISTORY_ID = :p_REPAIR_HISTORY_ID';
1215: END IF;
1216:
1217: -- example for DATE datatype
1218: IF( (P_REPH_Rec.PROGRAM_UPDATE_DATE IS NOT NULL) AND (P_REPH_Rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE) )
1219: THEN
1220: -- check if item value contains '%' wildcard
1221: OPEN c_chk_str1(P_REPH_Rec.PROGRAM_UPDATE_DATE);
1222: FETCH c_chk_str1 INTO str_csr1;
1247: x_REPH_where := x_REPH_where || 'P_REPH_Rec.PROGRAM_UPDATE_DATE ' || l_operator || ' :p_PROGRAM_UPDATE_DATE';
1248: END IF;
1249:
1250: -- example for VARCHAR2 datatype
1251: IF( (P_REPH_Rec.EVENT_CODE IS NOT NULL) AND (P_REPH_Rec.EVENT_CODE <> FND_API.G_MISS_CHAR) )
1252: THEN
1253: -- check if item value contains '%' wildcard
1254: OPEN c_chk_str1(P_REPH_Rec.EVENT_CODE);
1255: FETCH c_chk_str1 INTO str_csr1;
1288: END Gen_REPH_Where;
1289:
1290: PROCEDURE Get_repair_history(
1291: P_Api_Version_Number IN NUMBER,
1292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1294: P_identity_salesforce_id IN NUMBER := NULL,
1295: P_REPH_Rec IN REPH_Rec_Type,
1296: -- Hint: Add list of bind variables here
1289:
1290: PROCEDURE Get_repair_history(
1291: P_Api_Version_Number IN NUMBER,
1292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1294: P_identity_salesforce_id IN NUMBER := NULL,
1295: P_REPH_Rec IN REPH_Rec_Type,
1296: -- Hint: Add list of bind variables here
1297: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
1295: P_REPH_Rec IN REPH_Rec_Type,
1296: -- Hint: Add list of bind variables here
1297: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
1298: p_start_rec_prt IN NUMBER := 1,
1299: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
1300: -- Hint: user defined record type
1301: p_order_by_rec IN REPH_sort_rec_type,
1302: x_return_status OUT NOCOPY VARCHAR2,
1303: x_msg_count OUT NOCOPY NUMBER,
1348: -- Standard Start of API savepoint
1349: SAVEPOINT GET_REPAIR_HISTORY_PVT;
1350:
1351: -- Standard call to check for call compatibility.
1352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1353: p_api_version_number,
1354: l_api_name,
1355: G_PKG_NAME)
1356: THEN
1353: p_api_version_number,
1354: l_api_name,
1355: G_PKG_NAME)
1356: THEN
1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1358: END IF;
1359:
1360:
1361: -- Initialize message list if p_init_msg_list is set to TRUE.
1358: END IF;
1359:
1360:
1361: -- Initialize message list if p_init_msg_list is set to TRUE.
1362: IF FND_API.to_Boolean( p_init_msg_list )
1363: THEN
1364: FND_MSG_PUB.initialize;
1365: END IF;
1366:
1369: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1370:
1371:
1372: -- Initialize API return status to SUCCESS
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;
1374:
1375: --
1376: -- Api body
1377: --
1383: ,x_msg_count => x_msg_count
1384: ,x_msg_data => x_msg_data
1385: ,x_sales_member_rec => l_identity_sales_member_rec);
1386: */
1387: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: END IF;
1390:
1391: -- *************************************************
1384: ,x_msg_data => x_msg_data
1385: ,x_sales_member_rec => l_identity_sales_member_rec);
1386: */
1387: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: END IF;
1390:
1391: -- *************************************************
1392: -- Generate Dynamic SQL based on criteria passed in.
1476: LOOP
1477: -- 1. There are more rows in the cursor.
1478: -- 2. User does not care about total records, and we need to return more.
1479: -- 3. Or user cares about total number of records.
1480: IF((dbms_sql.fetch_rows(l_cur_get_REPH)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1481: OR (l_returned_rec_count
1483: -- Debug Message
1484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1477: -- 1. There are more rows in the cursor.
1478: -- 2. User does not care about total records, and we need to return more.
1479: -- 3. Or user cares about total number of records.
1480: IF((dbms_sql.fetch_rows(l_cur_get_REPH)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1481: OR (l_returned_rec_count
1483: -- Debug Message
1484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1485:
1522: p_data => x_msg_data
1523: );
1524:
1525: EXCEPTION
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1528: P_API_NAME => L_API_NAME
1529: ,P_PKG_NAME => G_PKG_NAME
1530: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1533: ,X_MSG_DATA => X_MSG_DATA
1534: ,X_RETURN_STATUS => X_RETURN_STATUS);
1535: -- RAISE;
1536:
1537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1538: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1539: P_API_NAME => L_API_NAME
1540: ,P_PKG_NAME => G_PKG_NAME
1541: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1559:
1560:
1561: -- Item-level validation procedures
1562: PROCEDURE Validate_REPAIR_HISTORY_ID (
1563: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1564: P_Validation_mode IN VARCHAR2,
1565: P_REPAIR_HISTORY_ID IN NUMBER,
1566: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1567: X_Return_Status OUT NOCOPY VARCHAR2,
1571: IS
1572: BEGIN
1573:
1574: -- Initialize message list if p_init_msg_list is set to TRUE.
1575: IF FND_API.to_Boolean( p_init_msg_list )
1576: THEN
1577: FND_MSG_PUB.initialize;
1578: END IF;
1579:
1578: END IF;
1579:
1580:
1581: -- Initialize API return status to SUCCESS
1582: x_return_status := FND_API.G_RET_STS_SUCCESS;
1583:
1584: -- validate NOT NULL column
1585: IF(p_REPAIR_HISTORY_ID is NULL)
1586: THEN
1584: -- validate NOT NULL column
1585: IF(p_REPAIR_HISTORY_ID is NULL)
1586: THEN
1587: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(REPAIR_HISTORY_ID)');
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END IF;
1590:
1591: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1592: THEN
1592: THEN
1593: -- Hint: Validate data
1594: -- IF p_REPAIR_HISTORY_ID is not NULL and p_REPAIR_HISTORY_ID <> G_MISS_CHAR
1595: -- verify if data is valid
1596: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1597: NULL;
1598: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1599: THEN
1600: -- Hint: Validate data
1599: THEN
1600: -- Hint: Validate data
1601: -- IF p_REPAIR_HISTORY_ID <> G_MISS_CHAR
1602: -- verify if data is valid
1603: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1604: NULL;
1605: END IF;
1606:
1607: -- Standard call to get message count and if count is 1, get message info.
1613: END Validate_REPAIR_HISTORY_ID;
1614:
1615:
1616: PROCEDURE Validate_REQUEST_ID (
1617: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1618: P_Validation_mode IN VARCHAR2,
1619: P_REQUEST_ID IN NUMBER,
1620: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1621: X_Return_Status OUT NOCOPY VARCHAR2,
1625: IS
1626: BEGIN
1627:
1628: -- Initialize message list if p_init_msg_list is set to TRUE.
1629: IF FND_API.to_Boolean( p_init_msg_list )
1630: THEN
1631: FND_MSG_PUB.initialize;
1632: END IF;
1633:
1632: END IF;
1633:
1634:
1635: -- Initialize API return status to SUCCESS
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;
1637:
1638: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1639: THEN
1640: -- Hint: Validate data
1639: THEN
1640: -- Hint: Validate data
1641: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
1642: -- verify if data is valid
1643: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1644: NULL;
1645: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1646: THEN
1647: -- Hint: Validate data
1646: THEN
1647: -- Hint: Validate data
1648: -- IF p_REQUEST_ID <> G_MISS_CHAR
1649: -- verify if data is valid
1650: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1651: NULL;
1652: END IF;
1653:
1654: -- Standard call to get message count and if count is 1, get message info.
1660: END Validate_REQUEST_ID;
1661:
1662:
1663: PROCEDURE Validate_REPAIR_LINE_ID (
1664: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1665: P_Validation_mode IN VARCHAR2,
1666: P_REPAIR_LINE_ID IN NUMBER,
1667: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1668: X_Return_Status OUT NOCOPY VARCHAR2,
1672: IS
1673: BEGIN
1674:
1675: -- Initialize message list if p_init_msg_list is set to TRUE.
1676: IF FND_API.to_Boolean( p_init_msg_list )
1677: THEN
1678: FND_MSG_PUB.initialize;
1679: END IF;
1680:
1679: END IF;
1680:
1681:
1682: -- Initialize API return status to SUCCESS
1683: x_return_status := FND_API.G_RET_STS_SUCCESS;
1684:
1685: -- validate NOT NULL column
1686: IF(p_REPAIR_LINE_ID is NULL)
1687: THEN
1685: -- validate NOT NULL column
1686: IF(p_REPAIR_LINE_ID is NULL)
1687: THEN
1688: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: END IF;
1691:
1692: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1693: THEN
1693: THEN
1694: -- Hint: Validate data
1695: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1696: -- verify if data is valid
1697: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1698: NULL;
1699: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1700: THEN
1701: -- Hint: Validate data
1700: THEN
1701: -- Hint: Validate data
1702: -- IF p_REPAIR_LINE_ID <> G_MISS_CHAR
1703: -- verify if data is valid
1704: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1705: NULL;
1706: END IF;
1707:
1708: -- Standard call to get message count and if count is 1, get message info.
1714: END Validate_REPAIR_LINE_ID;
1715:
1716:
1717: PROCEDURE Validate_EVENT_CODE (
1718: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1719: P_Validation_mode IN VARCHAR2,
1720: P_EVENT_CODE IN VARCHAR2,
1721: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1722: X_Return_Status OUT NOCOPY VARCHAR2,
1726: IS
1727: BEGIN
1728:
1729: -- Initialize message list if p_init_msg_list is set to TRUE.
1730: IF FND_API.to_Boolean( p_init_msg_list )
1731: THEN
1732: FND_MSG_PUB.initialize;
1733: END IF;
1734:
1733: END IF;
1734:
1735:
1736: -- Initialize API return status to SUCCESS
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738:
1739: -- validate NOT NULL column
1740: IF(p_EVENT_CODE is NULL)
1741: THEN
1739: -- validate NOT NULL column
1740: IF(p_EVENT_CODE is NULL)
1741: THEN
1742: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_CODE)');
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1744: END IF;
1745:
1746: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1747: THEN
1747: THEN
1748: -- Hint: Validate data
1749: -- IF p_EVENT_CODE is not NULL and p_EVENT_CODE <> G_MISS_CHAR
1750: -- verify if data is valid
1751: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1752: NULL;
1753: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1754: THEN
1755: -- Hint: Validate data
1754: THEN
1755: -- Hint: Validate data
1756: -- IF p_EVENT_CODE <> G_MISS_CHAR
1757: -- verify if data is valid
1758: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1759: NULL;
1760: END IF;
1761:
1762: -- Standard call to get message count and if count is 1, get message info.
1770:
1771:
1772:
1773: PROCEDURE Validate_EVENT_meaning (
1774: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1775: P_Validation_mode IN VARCHAR2,
1776: P_EVENT_meaning IN VARCHAR2,
1777: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1778: X_Return_Status OUT NOCOPY VARCHAR2,
1782: IS
1783: BEGIN
1784:
1785: -- Initialize message list if p_init_msg_list is set to TRUE.
1786: IF FND_API.to_Boolean( p_init_msg_list )
1787: THEN
1788: FND_MSG_PUB.initialize;
1789: END IF;
1790:
1789: END IF;
1790:
1791:
1792: -- Initialize API return status to SUCCESS
1793: x_return_status := FND_API.G_RET_STS_SUCCESS;
1794:
1795: -- validate NOT NULL column
1796: IF(p_EVENT_meaning is NULL)
1797: THEN
1795: -- validate NOT NULL column
1796: IF(p_EVENT_meaning is NULL)
1797: THEN
1798: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_MEANING)');
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: END IF;
1801:
1802: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1803: THEN
1803: THEN
1804: -- Hint: Validate data
1805: -- IF p_EVENT_meaning is not NULL and p_EVENT_meaning <> 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 = JTF_PLSQL_API.G_UPDATE)
1810: THEN
1811: -- Hint: Validate data
1810: THEN
1811: -- Hint: Validate data
1812: -- IF p_EVENT_meaning <> 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_EVENT_meaning;
1825:
1826:
1827: PROCEDURE Validate_EVENT_DATE (
1828: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1829: P_Validation_mode IN VARCHAR2,
1830: P_EVENT_DATE IN DATE,
1831: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.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: -- validate NOT NULL column
1850: IF(p_EVENT_DATE is NULL)
1851: THEN
1849: -- validate NOT NULL column
1850: IF(p_EVENT_DATE is NULL)
1851: THEN
1852: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_DATE)');
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;
1855:
1856: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1857: THEN
1857: THEN
1858: -- Hint: Validate data
1859: -- IF p_EVENT_DATE is not NULL and p_EVENT_DATE <> 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: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1864: THEN
1865: -- Hint: Validate data
1864: THEN
1865: -- Hint: Validate data
1866: -- IF p_EVENT_DATE <> G_MISS_CHAR
1867: -- verify if data is valid
1868: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1869: NULL;
1870: END IF;
1871:
1872: -- Standard call to get message count and if count is 1, get message info.
1878: END Validate_EVENT_DATE;
1879:
1880:
1881: PROCEDURE Validate_QUANTITY (
1882: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1883: P_Validation_mode IN VARCHAR2,
1884: P_QUANTITY IN NUMBER,
1885: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1886: X_Return_Status OUT NOCOPY VARCHAR2,
1890: IS
1891: BEGIN
1892:
1893: -- Initialize message list if p_init_msg_list is set to TRUE.
1894: IF FND_API.to_Boolean( p_init_msg_list )
1895: THEN
1896: FND_MSG_PUB.initialize;
1897: END IF;
1898:
1897: END IF;
1898:
1899:
1900: -- Initialize API return status to SUCCESS
1901: x_return_status := FND_API.G_RET_STS_SUCCESS;
1902:
1903: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1904: THEN
1905: -- Hint: Validate data
1904: THEN
1905: -- Hint: Validate data
1906: -- IF p_QUANTITY is not NULL and p_QUANTITY <> 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: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1911: THEN
1912: -- Hint: Validate data
1911: THEN
1912: -- Hint: Validate data
1913: -- IF p_QUANTITY <> G_MISS_CHAR
1914: -- verify if data is valid
1915: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1916: NULL;
1917: END IF;
1918:
1919: -- Standard call to get message count and if count is 1, get message info.
1925: END Validate_QUANTITY;
1926:
1927:
1928: PROCEDURE Validate_PARAMN1 (
1929: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1930: P_Validation_mode IN VARCHAR2,
1931: P_PARAMN1 IN NUMBER,
1932: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1933: X_Return_Status OUT NOCOPY VARCHAR2,
1937: IS
1938: BEGIN
1939:
1940: -- Initialize message list if p_init_msg_list is set to TRUE.
1941: IF FND_API.to_Boolean( p_init_msg_list )
1942: THEN
1943: FND_MSG_PUB.initialize;
1944: END IF;
1945:
1944: END IF;
1945:
1946:
1947: -- Initialize API return status to SUCCESS
1948: x_return_status := FND_API.G_RET_STS_SUCCESS;
1949:
1950: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1951: THEN
1952: -- Hint: Validate data
1951: THEN
1952: -- Hint: Validate data
1953: -- IF p_PARAMN1 is not NULL and p_PARAMN1 <> 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: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1958: THEN
1959: -- Hint: Validate data
1958: THEN
1959: -- Hint: Validate data
1960: -- IF p_PARAMN1 <> G_MISS_CHAR
1961: -- verify if data is valid
1962: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1963: NULL;
1964: END IF;
1965:
1966: -- Standard call to get message count and if count is 1, get message info.
1972: END Validate_PARAMN1;
1973:
1974:
1975: PROCEDURE Validate_PARAMN2 (
1976: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1977: P_Validation_mode IN VARCHAR2,
1978: P_PARAMN2 IN NUMBER,
1979: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1980: X_Return_Status OUT NOCOPY VARCHAR2,
1984: IS
1985: BEGIN
1986:
1987: -- Initialize message list if p_init_msg_list is set to TRUE.
1988: IF FND_API.to_Boolean( p_init_msg_list )
1989: THEN
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1991: END IF;
1992:
1993:
1994: -- Initialize API return status to SUCCESS
1995: x_return_status := FND_API.G_RET_STS_SUCCESS;
1996:
1997: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1998: THEN
1999: -- Hint: Validate data
1998: THEN
1999: -- Hint: Validate data
2000: -- IF p_PARAMN2 is not NULL and p_PARAMN2 <> 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: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2005: THEN
2006: -- Hint: Validate data
2005: THEN
2006: -- Hint: Validate data
2007: -- IF p_PARAMN2 <> G_MISS_CHAR
2008: -- verify if data is valid
2009: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2010: NULL;
2011: END IF;
2012:
2013: -- Standard call to get message count and if count is 1, get message info.
2019: END Validate_PARAMN2;
2020:
2021:
2022: PROCEDURE Validate_PARAMN3 (
2023: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2024: P_Validation_mode IN VARCHAR2,
2025: P_PARAMN3 IN NUMBER,
2026: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2027: X_Return_Status OUT NOCOPY VARCHAR2,
2031: IS
2032: BEGIN
2033:
2034: -- Initialize message list if p_init_msg_list is set to TRUE.
2035: IF FND_API.to_Boolean( p_init_msg_list )
2036: THEN
2037: FND_MSG_PUB.initialize;
2038: END IF;
2039:
2038: END IF;
2039:
2040:
2041: -- Initialize API return status to SUCCESS
2042: x_return_status := FND_API.G_RET_STS_SUCCESS;
2043:
2044: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2045: THEN
2046: -- Hint: Validate data
2045: THEN
2046: -- Hint: Validate data
2047: -- IF p_PARAMN3 is not NULL and p_PARAMN3 <> 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: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2052: THEN
2053: -- Hint: Validate data
2052: THEN
2053: -- Hint: Validate data
2054: -- IF p_PARAMN3 <> G_MISS_CHAR
2055: -- verify if data is valid
2056: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2057: NULL;
2058: END IF;
2059:
2060: -- Standard call to get message count and if count is 1, get message info.
2066: END Validate_PARAMN3;
2067:
2068:
2069: PROCEDURE Validate_PARAMN4 (
2070: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2071: P_Validation_mode IN VARCHAR2,
2072: P_PARAMN4 IN NUMBER,
2073: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2074: X_Return_Status OUT NOCOPY VARCHAR2,
2078: IS
2079: BEGIN
2080:
2081: -- Initialize message list if p_init_msg_list is set to TRUE.
2082: IF FND_API.to_Boolean( p_init_msg_list )
2083: THEN
2084: FND_MSG_PUB.initialize;
2085: END IF;
2086:
2085: END IF;
2086:
2087:
2088: -- Initialize API return status to SUCCESS
2089: x_return_status := FND_API.G_RET_STS_SUCCESS;
2090:
2091: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2092: THEN
2093: -- Hint: Validate data
2092: THEN
2093: -- Hint: Validate data
2094: -- IF p_PARAMN4 is not NULL and p_PARAMN4 <> G_MISS_CHAR
2095: -- verify if data is valid
2096: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2097: NULL;
2098: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2099: THEN
2100: -- Hint: Validate data
2099: THEN
2100: -- Hint: Validate data
2101: -- IF p_PARAMN4 <> G_MISS_CHAR
2102: -- verify if data is valid
2103: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2104: NULL;
2105: END IF;
2106:
2107: -- Standard call to get message count and if count is 1, get message info.
2113: END Validate_PARAMN4;
2114:
2115:
2116: PROCEDURE Validate_PARAMN5 (
2117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2118: P_Validation_mode IN VARCHAR2,
2119: P_PARAMN5 IN NUMBER,
2120: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2121: X_Return_Status OUT NOCOPY VARCHAR2,
2125: IS
2126: BEGIN
2127:
2128: -- Initialize message list if p_init_msg_list is set to TRUE.
2129: IF FND_API.to_Boolean( p_init_msg_list )
2130: THEN
2131: FND_MSG_PUB.initialize;
2132: END IF;
2133:
2132: END IF;
2133:
2134:
2135: -- Initialize API return status to SUCCESS
2136: x_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2139: THEN
2140: -- Hint: Validate data
2139: THEN
2140: -- Hint: Validate data
2141: -- IF p_PARAMN5 is not NULL and p_PARAMN5 <> G_MISS_CHAR
2142: -- verify if data is valid
2143: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2144: NULL;
2145: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2146: THEN
2147: -- Hint: Validate data
2146: THEN
2147: -- Hint: Validate data
2148: -- IF p_PARAMN5 <> G_MISS_CHAR
2149: -- verify if data is valid
2150: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2151: NULL;
2152: END IF;
2153:
2154: -- Standard call to get message count and if count is 1, get message info.
2160: END Validate_PARAMN5;
2161:
2162:
2163: PROCEDURE Validate_PARAMN6 (
2164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2165: P_Validation_mode IN VARCHAR2,
2166: P_PARAMN6 IN NUMBER,
2167: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2168: X_Return_Status OUT NOCOPY VARCHAR2,
2172: IS
2173: BEGIN
2174:
2175: -- Initialize message list if p_init_msg_list is set to TRUE.
2176: IF FND_API.to_Boolean( p_init_msg_list )
2177: THEN
2178: FND_MSG_PUB.initialize;
2179: END IF;
2180:
2179: END IF;
2180:
2181:
2182: -- Initialize API return status to SUCCESS
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184:
2185: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2186: THEN
2187: -- Hint: Validate data
2186: THEN
2187: -- Hint: Validate data
2188: -- IF p_PARAMN6 is not NULL and p_PARAMN6 <> G_MISS_CHAR
2189: -- verify if data is valid
2190: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2191: NULL;
2192: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2193: THEN
2194: -- Hint: Validate data
2193: THEN
2194: -- Hint: Validate data
2195: -- IF p_PARAMN6 <> G_MISS_CHAR
2196: -- verify if data is valid
2197: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2198: NULL;
2199: END IF;
2200:
2201: -- Standard call to get message count and if count is 1, get message info.
2207: END Validate_PARAMN6;
2208:
2209:
2210: PROCEDURE Validate_PARAMN7 (
2211: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2212: P_Validation_mode IN VARCHAR2,
2213: P_PARAMN7 IN NUMBER,
2214: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2215: X_Return_Status OUT NOCOPY VARCHAR2,
2219: IS
2220: BEGIN
2221:
2222: -- Initialize message list if p_init_msg_list is set to TRUE.
2223: IF FND_API.to_Boolean( p_init_msg_list )
2224: THEN
2225: FND_MSG_PUB.initialize;
2226: END IF;
2227:
2226: END IF;
2227:
2228:
2229: -- Initialize API return status to SUCCESS
2230: x_return_status := FND_API.G_RET_STS_SUCCESS;
2231:
2232: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2233: THEN
2234: -- Hint: Validate data
2233: THEN
2234: -- Hint: Validate data
2235: -- IF p_PARAMN7 is not NULL and p_PARAMN7 <> G_MISS_CHAR
2236: -- verify if data is valid
2237: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2238: NULL;
2239: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2240: THEN
2241: -- Hint: Validate data
2240: THEN
2241: -- Hint: Validate data
2242: -- IF p_PARAMN7 <> G_MISS_CHAR
2243: -- verify if data is valid
2244: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2245: NULL;
2246: END IF;
2247:
2248: -- Standard call to get message count and if count is 1, get message info.
2254: END Validate_PARAMN7;
2255:
2256:
2257: PROCEDURE Validate_PARAMN8 (
2258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2259: P_Validation_mode IN VARCHAR2,
2260: P_PARAMN8 IN NUMBER,
2261: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2262: X_Return_Status OUT NOCOPY VARCHAR2,
2266: IS
2267: BEGIN
2268:
2269: -- Initialize message list if p_init_msg_list is set to TRUE.
2270: IF FND_API.to_Boolean( p_init_msg_list )
2271: THEN
2272: FND_MSG_PUB.initialize;
2273: END IF;
2274:
2273: END IF;
2274:
2275:
2276: -- Initialize API return status to SUCCESS
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;
2278:
2279: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2280: THEN
2281: -- Hint: Validate data
2280: THEN
2281: -- Hint: Validate data
2282: -- IF p_PARAMN8 is not NULL and p_PARAMN8 <> G_MISS_CHAR
2283: -- verify if data is valid
2284: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2285: NULL;
2286: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2287: THEN
2288: -- Hint: Validate data
2287: THEN
2288: -- Hint: Validate data
2289: -- IF p_PARAMN8 <> G_MISS_CHAR
2290: -- verify if data is valid
2291: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2292: NULL;
2293: END IF;
2294:
2295: -- Standard call to get message count and if count is 1, get message info.
2301: END Validate_PARAMN8;
2302:
2303:
2304: PROCEDURE Validate_PARAMN9 (
2305: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2306: P_Validation_mode IN VARCHAR2,
2307: P_PARAMN9 IN NUMBER,
2308: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2309: X_Return_Status OUT NOCOPY VARCHAR2,
2313: IS
2314: BEGIN
2315:
2316: -- Initialize message list if p_init_msg_list is set to TRUE.
2317: IF FND_API.to_Boolean( p_init_msg_list )
2318: THEN
2319: FND_MSG_PUB.initialize;
2320: END IF;
2321:
2320: END IF;
2321:
2322:
2323: -- Initialize API return status to SUCCESS
2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2327: THEN
2328: -- Hint: Validate data
2327: THEN
2328: -- Hint: Validate data
2329: -- IF p_PARAMN9 is not NULL and p_PARAMN9 <> G_MISS_CHAR
2330: -- verify if data is valid
2331: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2332: NULL;
2333: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2334: THEN
2335: -- Hint: Validate data
2334: THEN
2335: -- Hint: Validate data
2336: -- IF p_PARAMN9 <> G_MISS_CHAR
2337: -- verify if data is valid
2338: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2339: NULL;
2340: END IF;
2341:
2342: -- Standard call to get message count and if count is 1, get message info.
2348: END Validate_PARAMN9;
2349:
2350:
2351: PROCEDURE Validate_PARAMN10 (
2352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2353: P_Validation_mode IN VARCHAR2,
2354: P_PARAMN10 IN NUMBER,
2355: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2356: X_Return_Status OUT NOCOPY VARCHAR2,
2360: IS
2361: BEGIN
2362:
2363: -- Initialize message list if p_init_msg_list is set to TRUE.
2364: IF FND_API.to_Boolean( p_init_msg_list )
2365: THEN
2366: FND_MSG_PUB.initialize;
2367: END IF;
2368:
2367: END IF;
2368:
2369:
2370: -- Initialize API return status to SUCCESS
2371: x_return_status := FND_API.G_RET_STS_SUCCESS;
2372:
2373: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2374: THEN
2375: -- Hint: Validate data
2374: THEN
2375: -- Hint: Validate data
2376: -- IF p_PARAMN10 is not NULL and p_PARAMN10 <> G_MISS_CHAR
2377: -- verify if data is valid
2378: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2379: NULL;
2380: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2381: THEN
2382: -- Hint: Validate data
2381: THEN
2382: -- Hint: Validate data
2383: -- IF p_PARAMN10 <> G_MISS_CHAR
2384: -- verify if data is valid
2385: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2386: NULL;
2387: END IF;
2388:
2389: -- Standard call to get message count and if count is 1, get message info.
2395: END Validate_PARAMN10;
2396:
2397:
2398: PROCEDURE Validate_PARAMC1 (
2399: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2400: P_Validation_mode IN VARCHAR2,
2401: P_PARAMC1 IN VARCHAR2,
2402: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2403: X_Return_Status OUT NOCOPY VARCHAR2,
2407: IS
2408: BEGIN
2409:
2410: -- Initialize message list if p_init_msg_list is set to TRUE.
2411: IF FND_API.to_Boolean( p_init_msg_list )
2412: THEN
2413: FND_MSG_PUB.initialize;
2414: END IF;
2415:
2414: END IF;
2415:
2416:
2417: -- Initialize API return status to SUCCESS
2418: x_return_status := FND_API.G_RET_STS_SUCCESS;
2419:
2420: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2421: THEN
2422: -- Hint: Validate data
2421: THEN
2422: -- Hint: Validate data
2423: -- IF p_PARAMC1 is not NULL and p_PARAMC1 <> G_MISS_CHAR
2424: -- verify if data is valid
2425: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2426: NULL;
2427: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2428: THEN
2429: -- Hint: Validate data
2428: THEN
2429: -- Hint: Validate data
2430: -- IF p_PARAMC1 <> G_MISS_CHAR
2431: -- verify if data is valid
2432: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2433: NULL;
2434: END IF;
2435:
2436: -- Standard call to get message count and if count is 1, get message info.
2442: END Validate_PARAMC1;
2443:
2444:
2445: PROCEDURE Validate_PARAMC2 (
2446: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2447: P_Validation_mode IN VARCHAR2,
2448: P_PARAMC2 IN VARCHAR2,
2449: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2450: X_Return_Status OUT NOCOPY VARCHAR2,
2454: IS
2455: BEGIN
2456:
2457: -- Initialize message list if p_init_msg_list is set to TRUE.
2458: IF FND_API.to_Boolean( p_init_msg_list )
2459: THEN
2460: FND_MSG_PUB.initialize;
2461: END IF;
2462:
2461: END IF;
2462:
2463:
2464: -- Initialize API return status to SUCCESS
2465: x_return_status := FND_API.G_RET_STS_SUCCESS;
2466:
2467: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2468: THEN
2469: -- Hint: Validate data
2468: THEN
2469: -- Hint: Validate data
2470: -- IF p_PARAMC2 is not NULL and p_PARAMC2 <> G_MISS_CHAR
2471: -- verify if data is valid
2472: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2473: NULL;
2474: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2475: THEN
2476: -- Hint: Validate data
2475: THEN
2476: -- Hint: Validate data
2477: -- IF p_PARAMC2 <> G_MISS_CHAR
2478: -- verify if data is valid
2479: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2480: NULL;
2481: END IF;
2482:
2483: -- Standard call to get message count and if count is 1, get message info.
2489: END Validate_PARAMC2;
2490:
2491:
2492: PROCEDURE Validate_PARAMC3 (
2493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2494: P_Validation_mode IN VARCHAR2,
2495: P_PARAMC3 IN VARCHAR2,
2496: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2497: X_Return_Status OUT NOCOPY VARCHAR2,
2501: IS
2502: BEGIN
2503:
2504: -- Initialize message list if p_init_msg_list is set to TRUE.
2505: IF FND_API.to_Boolean( p_init_msg_list )
2506: THEN
2507: FND_MSG_PUB.initialize;
2508: END IF;
2509:
2508: END IF;
2509:
2510:
2511: -- Initialize API return status to SUCCESS
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;
2513:
2514: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2515: THEN
2516: -- Hint: Validate data
2515: THEN
2516: -- Hint: Validate data
2517: -- IF p_PARAMC3 is not NULL and p_PARAMC3 <> G_MISS_CHAR
2518: -- verify if data is valid
2519: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2520: NULL;
2521: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2522: THEN
2523: -- Hint: Validate data
2522: THEN
2523: -- Hint: Validate data
2524: -- IF p_PARAMC3 <> G_MISS_CHAR
2525: -- verify if data is valid
2526: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2527: NULL;
2528: END IF;
2529:
2530: -- Standard call to get message count and if count is 1, get message info.
2536: END Validate_PARAMC3;
2537:
2538:
2539: PROCEDURE Validate_PARAMC4 (
2540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2541: P_Validation_mode IN VARCHAR2,
2542: P_PARAMC4 IN VARCHAR2,
2543: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2544: X_Return_Status OUT NOCOPY VARCHAR2,
2548: IS
2549: BEGIN
2550:
2551: -- Initialize message list if p_init_msg_list is set to TRUE.
2552: IF FND_API.to_Boolean( p_init_msg_list )
2553: THEN
2554: FND_MSG_PUB.initialize;
2555: END IF;
2556:
2555: END IF;
2556:
2557:
2558: -- Initialize API return status to SUCCESS
2559: x_return_status := FND_API.G_RET_STS_SUCCESS;
2560:
2561: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2562: THEN
2563: -- Hint: Validate data
2562: THEN
2563: -- Hint: Validate data
2564: -- IF p_PARAMC4 is not NULL and p_PARAMC4 <> G_MISS_CHAR
2565: -- verify if data is valid
2566: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2567: NULL;
2568: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2569: THEN
2570: -- Hint: Validate data
2569: THEN
2570: -- Hint: Validate data
2571: -- IF p_PARAMC4 <> G_MISS_CHAR
2572: -- verify if data is valid
2573: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2574: NULL;
2575: END IF;
2576:
2577: -- Standard call to get message count and if count is 1, get message info.
2583: END Validate_PARAMC4;
2584:
2585:
2586: PROCEDURE Validate_PARAMC5 (
2587: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2588: P_Validation_mode IN VARCHAR2,
2589: P_PARAMC5 IN VARCHAR2,
2590: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2591: X_Return_Status OUT NOCOPY VARCHAR2,
2595: IS
2596: BEGIN
2597:
2598: -- Initialize message list if p_init_msg_list is set to TRUE.
2599: IF FND_API.to_Boolean( p_init_msg_list )
2600: THEN
2601: FND_MSG_PUB.initialize;
2602: END IF;
2603:
2602: END IF;
2603:
2604:
2605: -- Initialize API return status to SUCCESS
2606: x_return_status := FND_API.G_RET_STS_SUCCESS;
2607:
2608: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2609: THEN
2610: -- Hint: Validate data
2609: THEN
2610: -- Hint: Validate data
2611: -- IF p_PARAMC5 is not NULL and p_PARAMC5 <> G_MISS_CHAR
2612: -- verify if data is valid
2613: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2614: NULL;
2615: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2616: THEN
2617: -- Hint: Validate data
2616: THEN
2617: -- Hint: Validate data
2618: -- IF p_PARAMC5 <> G_MISS_CHAR
2619: -- verify if data is valid
2620: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2621: NULL;
2622: END IF;
2623:
2624: -- Standard call to get message count and if count is 1, get message info.
2630: END Validate_PARAMC5;
2631:
2632:
2633: PROCEDURE Validate_PARAMC6 (
2634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2635: P_Validation_mode IN VARCHAR2,
2636: P_PARAMC6 IN VARCHAR2,
2637: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2638: X_Return_Status OUT NOCOPY VARCHAR2,
2642: IS
2643: BEGIN
2644:
2645: -- Initialize message list if p_init_msg_list is set to TRUE.
2646: IF FND_API.to_Boolean( p_init_msg_list )
2647: THEN
2648: FND_MSG_PUB.initialize;
2649: END IF;
2650:
2649: END IF;
2650:
2651:
2652: -- Initialize API return status to SUCCESS
2653: x_return_status := FND_API.G_RET_STS_SUCCESS;
2654:
2655: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2656: THEN
2657: -- Hint: Validate data
2656: THEN
2657: -- Hint: Validate data
2658: -- IF p_PARAMC6 is not NULL and p_PARAMC6 <> G_MISS_CHAR
2659: -- verify if data is valid
2660: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2661: NULL;
2662: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2663: THEN
2664: -- Hint: Validate data
2663: THEN
2664: -- Hint: Validate data
2665: -- IF p_PARAMC6 <> G_MISS_CHAR
2666: -- verify if data is valid
2667: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2668: NULL;
2669: END IF;
2670:
2671: -- Standard call to get message count and if count is 1, get message info.
2677: END Validate_PARAMC6;
2678:
2679:
2680: PROCEDURE Validate_PARAMC7 (
2681: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2682: P_Validation_mode IN VARCHAR2,
2683: P_PARAMC7 IN VARCHAR2,
2684: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2685: X_Return_Status OUT NOCOPY VARCHAR2,
2689: IS
2690: BEGIN
2691:
2692: -- Initialize message list if p_init_msg_list is set to TRUE.
2693: IF FND_API.to_Boolean( p_init_msg_list )
2694: THEN
2695: FND_MSG_PUB.initialize;
2696: END IF;
2697:
2696: END IF;
2697:
2698:
2699: -- Initialize API return status to SUCCESS
2700: x_return_status := FND_API.G_RET_STS_SUCCESS;
2701:
2702: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2703: THEN
2704: -- Hint: Validate data
2703: THEN
2704: -- Hint: Validate data
2705: -- IF p_PARAMC7 is not NULL and p_PARAMC7 <> G_MISS_CHAR
2706: -- verify if data is valid
2707: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2708: NULL;
2709: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2710: THEN
2711: -- Hint: Validate data
2710: THEN
2711: -- Hint: Validate data
2712: -- IF p_PARAMC7 <> G_MISS_CHAR
2713: -- verify if data is valid
2714: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2715: NULL;
2716: END IF;
2717:
2718: -- Standard call to get message count and if count is 1, get message info.
2724: END Validate_PARAMC7;
2725:
2726:
2727: PROCEDURE Validate_PARAMC8 (
2728: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2729: P_Validation_mode IN VARCHAR2,
2730: P_PARAMC8 IN VARCHAR2,
2731: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2732: X_Return_Status OUT NOCOPY VARCHAR2,
2736: IS
2737: BEGIN
2738:
2739: -- Initialize message list if p_init_msg_list is set to TRUE.
2740: IF FND_API.to_Boolean( p_init_msg_list )
2741: THEN
2742: FND_MSG_PUB.initialize;
2743: END IF;
2744:
2743: END IF;
2744:
2745:
2746: -- Initialize API return status to SUCCESS
2747: x_return_status := FND_API.G_RET_STS_SUCCESS;
2748:
2749: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2750: THEN
2751: -- Hint: Validate data
2750: THEN
2751: -- Hint: Validate data
2752: -- IF p_PARAMC8 is not NULL and p_PARAMC8 <> G_MISS_CHAR
2753: -- verify if data is valid
2754: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2755: NULL;
2756: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2757: THEN
2758: -- Hint: Validate data
2757: THEN
2758: -- Hint: Validate data
2759: -- IF p_PARAMC8 <> G_MISS_CHAR
2760: -- verify if data is valid
2761: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2762: NULL;
2763: END IF;
2764:
2765: -- Standard call to get message count and if count is 1, get message info.
2771: END Validate_PARAMC8;
2772:
2773:
2774: PROCEDURE Validate_PARAMC9 (
2775: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2776: P_Validation_mode IN VARCHAR2,
2777: P_PARAMC9 IN VARCHAR2,
2778: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2779: X_Return_Status OUT NOCOPY VARCHAR2,
2783: IS
2784: BEGIN
2785:
2786: -- Initialize message list if p_init_msg_list is set to TRUE.
2787: IF FND_API.to_Boolean( p_init_msg_list )
2788: THEN
2789: FND_MSG_PUB.initialize;
2790: END IF;
2791:
2790: END IF;
2791:
2792:
2793: -- Initialize API return status to SUCCESS
2794: x_return_status := FND_API.G_RET_STS_SUCCESS;
2795:
2796: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2797: THEN
2798: -- Hint: Validate data
2797: THEN
2798: -- Hint: Validate data
2799: -- IF p_PARAMC9 is not NULL and p_PARAMC9 <> G_MISS_CHAR
2800: -- verify if data is valid
2801: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2802: NULL;
2803: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2804: THEN
2805: -- Hint: Validate data
2804: THEN
2805: -- Hint: Validate data
2806: -- IF p_PARAMC9 <> G_MISS_CHAR
2807: -- verify if data is valid
2808: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2809: NULL;
2810: END IF;
2811:
2812: -- Standard call to get message count and if count is 1, get message info.
2818: END Validate_PARAMC9;
2819:
2820:
2821: PROCEDURE Validate_PARAMC10 (
2822: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2823: P_Validation_mode IN VARCHAR2,
2824: P_PARAMC10 IN VARCHAR2,
2825: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2826: X_Return_Status OUT NOCOPY VARCHAR2,
2830: IS
2831: BEGIN
2832:
2833: -- Initialize message list if p_init_msg_list is set to TRUE.
2834: IF FND_API.to_Boolean( p_init_msg_list )
2835: THEN
2836: FND_MSG_PUB.initialize;
2837: END IF;
2838:
2837: END IF;
2838:
2839:
2840: -- Initialize API return status to SUCCESS
2841: x_return_status := FND_API.G_RET_STS_SUCCESS;
2842:
2843: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2844: THEN
2845: -- Hint: Validate data
2844: THEN
2845: -- Hint: Validate data
2846: -- IF p_PARAMC10 is not NULL and p_PARAMC10 <> G_MISS_CHAR
2847: -- verify if data is valid
2848: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2849: NULL;
2850: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2851: THEN
2852: -- Hint: Validate data
2851: THEN
2852: -- Hint: Validate data
2853: -- IF p_PARAMC10 <> G_MISS_CHAR
2854: -- verify if data is valid
2855: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2856: NULL;
2857: END IF;
2858:
2859: -- Standard call to get message count and if count is 1, get message info.
2865: END Validate_PARAMC10;
2866:
2867:
2868: PROCEDURE Validate_PARAMD1 (
2869: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2870: P_Validation_mode IN VARCHAR2,
2871: P_PARAMD1 IN DATE,
2872: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2873: X_Return_Status OUT NOCOPY VARCHAR2,
2877: IS
2878: BEGIN
2879:
2880: -- Initialize message list if p_init_msg_list is set to TRUE.
2881: IF FND_API.to_Boolean( p_init_msg_list )
2882: THEN
2883: FND_MSG_PUB.initialize;
2884: END IF;
2885:
2884: END IF;
2885:
2886:
2887: -- Initialize API return status to SUCCESS
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889:
2890: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2891: THEN
2892: -- Hint: Validate data
2891: THEN
2892: -- Hint: Validate data
2893: -- IF p_PARAMD1 is not NULL and p_PARAMD1 <> G_MISS_CHAR
2894: -- verify if data is valid
2895: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2896: NULL;
2897: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2898: THEN
2899: -- Hint: Validate data
2898: THEN
2899: -- Hint: Validate data
2900: -- IF p_PARAMD1 <> G_MISS_CHAR
2901: -- verify if data is valid
2902: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2903: NULL;
2904: END IF;
2905:
2906: -- Standard call to get message count and if count is 1, get message info.
2912: END Validate_PARAMD1;
2913:
2914:
2915: PROCEDURE Validate_PARAMD2 (
2916: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2917: P_Validation_mode IN VARCHAR2,
2918: P_PARAMD2 IN DATE,
2919: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2920: X_Return_Status OUT NOCOPY VARCHAR2,
2924: IS
2925: BEGIN
2926:
2927: -- Initialize message list if p_init_msg_list is set to TRUE.
2928: IF FND_API.to_Boolean( p_init_msg_list )
2929: THEN
2930: FND_MSG_PUB.initialize;
2931: END IF;
2932:
2931: END IF;
2932:
2933:
2934: -- Initialize API return status to SUCCESS
2935: x_return_status := FND_API.G_RET_STS_SUCCESS;
2936:
2937: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2938: THEN
2939: -- Hint: Validate data
2938: THEN
2939: -- Hint: Validate data
2940: -- IF p_PARAMD2 is not NULL and p_PARAMD2 <> G_MISS_CHAR
2941: -- verify if data is valid
2942: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2943: NULL;
2944: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2945: THEN
2946: -- Hint: Validate data
2945: THEN
2946: -- Hint: Validate data
2947: -- IF p_PARAMD2 <> G_MISS_CHAR
2948: -- verify if data is valid
2949: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2950: NULL;
2951: END IF;
2952:
2953: -- Standard call to get message count and if count is 1, get message info.
2959: END Validate_PARAMD2;
2960:
2961:
2962: PROCEDURE Validate_PARAMD3 (
2963: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2964: P_Validation_mode IN VARCHAR2,
2965: P_PARAMD3 IN DATE,
2966: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2967: X_Return_Status OUT NOCOPY VARCHAR2,
2971: IS
2972: BEGIN
2973:
2974: -- Initialize message list if p_init_msg_list is set to TRUE.
2975: IF FND_API.to_Boolean( p_init_msg_list )
2976: THEN
2977: FND_MSG_PUB.initialize;
2978: END IF;
2979:
2978: END IF;
2979:
2980:
2981: -- Initialize API return status to SUCCESS
2982: x_return_status := FND_API.G_RET_STS_SUCCESS;
2983:
2984: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2985: THEN
2986: -- Hint: Validate data
2985: THEN
2986: -- Hint: Validate data
2987: -- IF p_PARAMD3 is not NULL and p_PARAMD3 <> G_MISS_CHAR
2988: -- verify if data is valid
2989: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2990: NULL;
2991: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2992: THEN
2993: -- Hint: Validate data
2992: THEN
2993: -- Hint: Validate data
2994: -- IF p_PARAMD3 <> G_MISS_CHAR
2995: -- verify if data is valid
2996: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2997: NULL;
2998: END IF;
2999:
3000: -- Standard call to get message count and if count is 1, get message info.
3006: END Validate_PARAMD3;
3007:
3008:
3009: PROCEDURE Validate_PARAMD4 (
3010: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3011: P_Validation_mode IN VARCHAR2,
3012: P_PARAMD4 IN DATE,
3013: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3014: X_Return_Status OUT NOCOPY VARCHAR2,
3018: IS
3019: BEGIN
3020:
3021: -- Initialize message list if p_init_msg_list is set to TRUE.
3022: IF FND_API.to_Boolean( p_init_msg_list )
3023: THEN
3024: FND_MSG_PUB.initialize;
3025: END IF;
3026:
3025: END IF;
3026:
3027:
3028: -- Initialize API return status to SUCCESS
3029: x_return_status := FND_API.G_RET_STS_SUCCESS;
3030:
3031: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3032: THEN
3033: -- Hint: Validate data
3032: THEN
3033: -- Hint: Validate data
3034: -- IF p_PARAMD4 is not NULL and p_PARAMD4 <> G_MISS_CHAR
3035: -- verify if data is valid
3036: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3037: NULL;
3038: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3039: THEN
3040: -- Hint: Validate data
3039: THEN
3040: -- Hint: Validate data
3041: -- IF p_PARAMD4 <> G_MISS_CHAR
3042: -- verify if data is valid
3043: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3044: NULL;
3045: END IF;
3046:
3047: -- Standard call to get message count and if count is 1, get message info.
3053: END Validate_PARAMD4;
3054:
3055:
3056: PROCEDURE Validate_PARAMD5 (
3057: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3058: P_Validation_mode IN VARCHAR2,
3059: P_PARAMD5 IN DATE,
3060: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3061: X_Return_Status OUT NOCOPY VARCHAR2,
3065: IS
3066: BEGIN
3067:
3068: -- Initialize message list if p_init_msg_list is set to TRUE.
3069: IF FND_API.to_Boolean( p_init_msg_list )
3070: THEN
3071: FND_MSG_PUB.initialize;
3072: END IF;
3073:
3072: END IF;
3073:
3074:
3075: -- Initialize API return status to SUCCESS
3076: x_return_status := FND_API.G_RET_STS_SUCCESS;
3077:
3078: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3079: THEN
3080: -- Hint: Validate data
3079: THEN
3080: -- Hint: Validate data
3081: -- IF p_PARAMD5 is not NULL and p_PARAMD5 <> G_MISS_CHAR
3082: -- verify if data is valid
3083: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3084: NULL;
3085: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3086: THEN
3087: -- Hint: Validate data
3086: THEN
3087: -- Hint: Validate data
3088: -- IF p_PARAMD5 <> G_MISS_CHAR
3089: -- verify if data is valid
3090: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3091: NULL;
3092: END IF;
3093:
3094: -- Standard call to get message count and if count is 1, get message info.
3100: END Validate_PARAMD5;
3101:
3102:
3103: PROCEDURE Validate_PARAMD6 (
3104: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3105: P_Validation_mode IN VARCHAR2,
3106: P_PARAMD6 IN DATE,
3107: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3108: X_Return_Status OUT NOCOPY VARCHAR2,
3112: IS
3113: BEGIN
3114:
3115: -- Initialize message list if p_init_msg_list is set to TRUE.
3116: IF FND_API.to_Boolean( p_init_msg_list )
3117: THEN
3118: FND_MSG_PUB.initialize;
3119: END IF;
3120:
3119: END IF;
3120:
3121:
3122: -- Initialize API return status to SUCCESS
3123: x_return_status := FND_API.G_RET_STS_SUCCESS;
3124:
3125: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3126: THEN
3127: -- Hint: Validate data
3126: THEN
3127: -- Hint: Validate data
3128: -- IF p_PARAMD6 is not NULL and p_PARAMD6 <> G_MISS_CHAR
3129: -- verify if data is valid
3130: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3131: NULL;
3132: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3133: THEN
3134: -- Hint: Validate data
3133: THEN
3134: -- Hint: Validate data
3135: -- IF p_PARAMD6 <> G_MISS_CHAR
3136: -- verify if data is valid
3137: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3138: NULL;
3139: END IF;
3140:
3141: -- Standard call to get message count and if count is 1, get message info.
3147: END Validate_PARAMD6;
3148:
3149:
3150: PROCEDURE Validate_PARAMD7 (
3151: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3152: P_Validation_mode IN VARCHAR2,
3153: P_PARAMD7 IN DATE,
3154: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3155: X_Return_Status OUT NOCOPY VARCHAR2,
3159: IS
3160: BEGIN
3161:
3162: -- Initialize message list if p_init_msg_list is set to TRUE.
3163: IF FND_API.to_Boolean( p_init_msg_list )
3164: THEN
3165: FND_MSG_PUB.initialize;
3166: END IF;
3167:
3166: END IF;
3167:
3168:
3169: -- Initialize API return status to SUCCESS
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3173: THEN
3174: -- Hint: Validate data
3173: THEN
3174: -- Hint: Validate data
3175: -- IF p_PARAMD7 is not NULL and p_PARAMD7 <> G_MISS_CHAR
3176: -- verify if data is valid
3177: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3178: NULL;
3179: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3180: THEN
3181: -- Hint: Validate data
3180: THEN
3181: -- Hint: Validate data
3182: -- IF p_PARAMD7 <> G_MISS_CHAR
3183: -- verify if data is valid
3184: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3185: NULL;
3186: END IF;
3187:
3188: -- Standard call to get message count and if count is 1, get message info.
3194: END Validate_PARAMD7;
3195:
3196:
3197: PROCEDURE Validate_PARAMD8 (
3198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3199: P_Validation_mode IN VARCHAR2,
3200: P_PARAMD8 IN DATE,
3201: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3202: X_Return_Status OUT NOCOPY VARCHAR2,
3206: IS
3207: BEGIN
3208:
3209: -- Initialize message list if p_init_msg_list is set to TRUE.
3210: IF FND_API.to_Boolean( p_init_msg_list )
3211: THEN
3212: FND_MSG_PUB.initialize;
3213: END IF;
3214:
3213: END IF;
3214:
3215:
3216: -- Initialize API return status to SUCCESS
3217: x_return_status := FND_API.G_RET_STS_SUCCESS;
3218:
3219: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3220: THEN
3221: -- Hint: Validate data
3220: THEN
3221: -- Hint: Validate data
3222: -- IF p_PARAMD8 is not NULL and p_PARAMD8 <> G_MISS_CHAR
3223: -- verify if data is valid
3224: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3225: NULL;
3226: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3227: THEN
3228: -- Hint: Validate data
3227: THEN
3228: -- Hint: Validate data
3229: -- IF p_PARAMD8 <> G_MISS_CHAR
3230: -- verify if data is valid
3231: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3232: NULL;
3233: END IF;
3234:
3235: -- Standard call to get message count and if count is 1, get message info.
3241: END Validate_PARAMD8;
3242:
3243:
3244: PROCEDURE Validate_PARAMD9 (
3245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3246: P_Validation_mode IN VARCHAR2,
3247: P_PARAMD9 IN DATE,
3248: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3249: X_Return_Status OUT NOCOPY VARCHAR2,
3253: IS
3254: BEGIN
3255:
3256: -- Initialize message list if p_init_msg_list is set to TRUE.
3257: IF FND_API.to_Boolean( p_init_msg_list )
3258: THEN
3259: FND_MSG_PUB.initialize;
3260: END IF;
3261:
3260: END IF;
3261:
3262:
3263: -- Initialize API return status to SUCCESS
3264: x_return_status := FND_API.G_RET_STS_SUCCESS;
3265:
3266: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3267: THEN
3268: -- Hint: Validate data
3267: THEN
3268: -- Hint: Validate data
3269: -- IF p_PARAMD9 is not NULL and p_PARAMD9 <> G_MISS_CHAR
3270: -- verify if data is valid
3271: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3272: NULL;
3273: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3274: THEN
3275: -- Hint: Validate data
3274: THEN
3275: -- Hint: Validate data
3276: -- IF p_PARAMD9 <> G_MISS_CHAR
3277: -- verify if data is valid
3278: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3279: NULL;
3280: END IF;
3281:
3282: -- Standard call to get message count and if count is 1, get message info.
3288: END Validate_PARAMD9;
3289:
3290:
3291: PROCEDURE Validate_PARAMD10 (
3292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3293: P_Validation_mode IN VARCHAR2,
3294: P_PARAMD10 IN DATE,
3295: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3296: X_Return_Status OUT NOCOPY VARCHAR2,
3300: IS
3301: BEGIN
3302:
3303: -- Initialize message list if p_init_msg_list is set to TRUE.
3304: IF FND_API.to_Boolean( p_init_msg_list )
3305: THEN
3306: FND_MSG_PUB.initialize;
3307: END IF;
3308:
3307: END IF;
3308:
3309:
3310: -- Initialize API return status to SUCCESS
3311: x_return_status := FND_API.G_RET_STS_SUCCESS;
3312:
3313: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3314: THEN
3315: -- Hint: Validate data
3314: THEN
3315: -- Hint: Validate data
3316: -- IF p_PARAMD10 is not NULL and p_PARAMD10 <> G_MISS_CHAR
3317: -- verify if data is valid
3318: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3319: NULL;
3320: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3321: THEN
3322: -- Hint: Validate data
3321: THEN
3322: -- Hint: Validate data
3323: -- IF p_PARAMD10 <> G_MISS_CHAR
3324: -- verify if data is valid
3325: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3326: NULL;
3327: END IF;
3328:
3329: -- Standard call to get message count and if count is 1, get message info.
3335: END Validate_PARAMD10;
3336:
3337: -- travi OBJECT_VERSION_NUMBER validation
3338: PROCEDURE Validate_OBJECT_VERSION_NUMBER (
3339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3340: P_Validation_mode IN VARCHAR2,
3341: P_OBJECT_VERSION_NUMBER IN NUMBER,
3342: P_REPAIR_HISTORY_ID IN NUMBER,
3343: X_Return_Status OUT NOCOPY VARCHAR2,
3350:
3351: BEGIN
3352:
3353: -- Initialize message list if p_init_msg_list is set to TRUE.
3354: IF FND_API.to_Boolean( p_init_msg_list )
3355: THEN
3356: FND_MSG_PUB.initialize;
3357: END IF;
3358:
3357: END IF;
3358:
3359:
3360: -- Initialize API return status to SUCCESS
3361: x_return_status := FND_API.G_RET_STS_SUCCESS;
3362:
3363: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3364: THEN
3365: IF (g_debug > 0 ) THEN
3395:
3396:
3397: if (l_OBJECT_VERSION_NUMBER <> p_OBJECT_VERSION_NUMBER) then
3398: -- data is not valid
3399: x_return_status := FND_API.G_RET_STS_ERROR;
3400:
3401: IF (g_debug > 0 ) THEN
3402: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');
3403: END IF;
3421: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
3422: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
3423: -- stored in database table.
3424: PROCEDURE Validate_REPH_rec(
3425: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3426: P_Validation_mode IN VARCHAR2,
3427: P_REPH_Rec IN REPH_Rec_Type,
3428: X_Return_Status OUT NOCOPY VARCHAR2,
3429: X_Msg_Count OUT NOCOPY NUMBER,
3432: IS
3433: BEGIN
3434:
3435: -- Initialize message list if p_init_msg_list is set to TRUE.
3436: IF FND_API.to_Boolean( p_init_msg_list )
3437: THEN
3438: FND_MSG_PUB.initialize;
3439: END IF;
3440:
3439: END IF;
3440:
3441:
3442: -- Initialize API return status to SUCCESS
3443: x_return_status := FND_API.G_RET_STS_SUCCESS;
3444:
3445: -- Hint: Validate data
3446: -- If data not valid
3447: -- THEN
3444:
3445: -- Hint: Validate data
3446: -- If data not valid
3447: -- THEN
3448: -- x_return_status := FND_API.G_RET_STS_ERROR;
3449:
3450: -- Debug Message
3451: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
3452:
3458:
3459: END Validate_REPH_Rec;
3460:
3461: PROCEDURE Validate_repair_history(
3462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3463: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3464: P_Validation_mode IN VARCHAR2,
3465: P_REPH_Rec IN REPH_Rec_Type,
3466: X_Return_Status OUT NOCOPY VARCHAR2,
3459: END Validate_REPH_Rec;
3460:
3461: PROCEDURE Validate_repair_history(
3462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3463: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3464: P_Validation_mode IN VARCHAR2,
3465: P_REPH_Rec IN REPH_Rec_Type,
3466: X_Return_Status OUT NOCOPY VARCHAR2,
3467: X_Msg_Count OUT NOCOPY NUMBER,
3475: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
3476:
3477:
3478: -- Initialize API return status to SUCCESS
3479: x_return_status := FND_API.G_RET_STS_SUCCESS;
3480:
3481: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
3482: -- Hint: We provide validation procedure for every column. Developer should delete
3483: -- unnecessary validation procedures.
3481: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
3482: -- Hint: We provide validation procedure for every column. Developer should delete
3483: -- unnecessary validation procedures.
3484: Validate_REPAIR_HISTORY_ID(
3485: p_init_msg_list => FND_API.G_FALSE,
3486: p_validation_mode => p_validation_mode,
3487: p_REPAIR_HISTORY_ID => P_REPH_Rec.REPAIR_HISTORY_ID,
3488: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3489: x_return_status => x_return_status,
3488: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3489: x_return_status => x_return_status,
3490: x_msg_count => x_msg_count,
3491: x_msg_data => x_msg_data);
3492: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3493: raise FND_API.G_EXC_ERROR;
3494: END IF;
3495:
3496: Validate_REQUEST_ID(
3489: x_return_status => x_return_status,
3490: x_msg_count => x_msg_count,
3491: x_msg_data => x_msg_data);
3492: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3493: raise FND_API.G_EXC_ERROR;
3494: END IF;
3495:
3496: Validate_REQUEST_ID(
3497: p_init_msg_list => FND_API.G_FALSE,
3493: raise FND_API.G_EXC_ERROR;
3494: END IF;
3495:
3496: Validate_REQUEST_ID(
3497: p_init_msg_list => FND_API.G_FALSE,
3498: p_validation_mode => p_validation_mode,
3499: p_REQUEST_ID => P_REPH_Rec.REQUEST_ID,
3500: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3501: x_return_status => x_return_status,
3500: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3501: x_return_status => x_return_status,
3502: x_msg_count => x_msg_count,
3503: x_msg_data => x_msg_data);
3504: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3505: raise FND_API.G_EXC_ERROR;
3506: END IF;
3507:
3508: Validate_REPAIR_LINE_ID(
3501: x_return_status => x_return_status,
3502: x_msg_count => x_msg_count,
3503: x_msg_data => x_msg_data);
3504: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3505: raise FND_API.G_EXC_ERROR;
3506: END IF;
3507:
3508: Validate_REPAIR_LINE_ID(
3509: p_init_msg_list => FND_API.G_FALSE,
3505: raise FND_API.G_EXC_ERROR;
3506: END IF;
3507:
3508: Validate_REPAIR_LINE_ID(
3509: p_init_msg_list => FND_API.G_FALSE,
3510: p_validation_mode => p_validation_mode,
3511: p_REPAIR_LINE_ID => P_REPH_Rec.REPAIR_LINE_ID,
3512: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3513: x_return_status => x_return_status,
3512: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3513: x_return_status => x_return_status,
3514: x_msg_count => x_msg_count,
3515: x_msg_data => x_msg_data);
3516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3517: raise FND_API.G_EXC_ERROR;
3518: END IF;
3519:
3520: Validate_EVENT_CODE(
3513: x_return_status => x_return_status,
3514: x_msg_count => x_msg_count,
3515: x_msg_data => x_msg_data);
3516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3517: raise FND_API.G_EXC_ERROR;
3518: END IF;
3519:
3520: Validate_EVENT_CODE(
3521: p_init_msg_list => FND_API.G_FALSE,
3517: raise FND_API.G_EXC_ERROR;
3518: END IF;
3519:
3520: Validate_EVENT_CODE(
3521: p_init_msg_list => FND_API.G_FALSE,
3522: p_validation_mode => p_validation_mode,
3523: p_EVENT_CODE => P_REPH_Rec.EVENT_CODE,
3524: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3525: x_return_status => x_return_status,
3524: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3525: x_return_status => x_return_status,
3526: x_msg_count => x_msg_count,
3527: x_msg_data => x_msg_data);
3528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3529: raise FND_API.G_EXC_ERROR;
3530: END IF;
3531:
3532: Validate_EVENT_DATE(
3525: x_return_status => x_return_status,
3526: x_msg_count => x_msg_count,
3527: x_msg_data => x_msg_data);
3528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3529: raise FND_API.G_EXC_ERROR;
3530: END IF;
3531:
3532: Validate_EVENT_DATE(
3533: p_init_msg_list => FND_API.G_FALSE,
3529: raise FND_API.G_EXC_ERROR;
3530: END IF;
3531:
3532: Validate_EVENT_DATE(
3533: p_init_msg_list => FND_API.G_FALSE,
3534: p_validation_mode => p_validation_mode,
3535: p_EVENT_DATE => P_REPH_Rec.EVENT_DATE,
3536: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3537: x_return_status => x_return_status,
3536: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3537: x_return_status => x_return_status,
3538: x_msg_count => x_msg_count,
3539: x_msg_data => x_msg_data);
3540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3541: raise FND_API.G_EXC_ERROR;
3542: END IF;
3543:
3544: Validate_QUANTITY(
3537: x_return_status => x_return_status,
3538: x_msg_count => x_msg_count,
3539: x_msg_data => x_msg_data);
3540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3541: raise FND_API.G_EXC_ERROR;
3542: END IF;
3543:
3544: Validate_QUANTITY(
3545: p_init_msg_list => FND_API.G_FALSE,
3541: raise FND_API.G_EXC_ERROR;
3542: END IF;
3543:
3544: Validate_QUANTITY(
3545: p_init_msg_list => FND_API.G_FALSE,
3546: p_validation_mode => p_validation_mode,
3547: p_QUANTITY => P_REPH_Rec.QUANTITY,
3548: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3549: x_return_status => x_return_status,
3548: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3549: x_return_status => x_return_status,
3550: x_msg_count => x_msg_count,
3551: x_msg_data => x_msg_data);
3552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3553: raise FND_API.G_EXC_ERROR;
3554: END IF;
3555:
3556: Validate_PARAMN1(
3549: x_return_status => x_return_status,
3550: x_msg_count => x_msg_count,
3551: x_msg_data => x_msg_data);
3552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3553: raise FND_API.G_EXC_ERROR;
3554: END IF;
3555:
3556: Validate_PARAMN1(
3557: p_init_msg_list => FND_API.G_FALSE,
3553: raise FND_API.G_EXC_ERROR;
3554: END IF;
3555:
3556: Validate_PARAMN1(
3557: p_init_msg_list => FND_API.G_FALSE,
3558: p_validation_mode => p_validation_mode,
3559: p_PARAMN1 => P_REPH_Rec.PARAMN1,
3560: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3561: x_return_status => x_return_status,
3560: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3561: x_return_status => x_return_status,
3562: x_msg_count => x_msg_count,
3563: x_msg_data => x_msg_data);
3564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3565: raise FND_API.G_EXC_ERROR;
3566: END IF;
3567:
3568: Validate_PARAMN2(
3561: x_return_status => x_return_status,
3562: x_msg_count => x_msg_count,
3563: x_msg_data => x_msg_data);
3564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3565: raise FND_API.G_EXC_ERROR;
3566: END IF;
3567:
3568: Validate_PARAMN2(
3569: p_init_msg_list => FND_API.G_FALSE,
3565: raise FND_API.G_EXC_ERROR;
3566: END IF;
3567:
3568: Validate_PARAMN2(
3569: p_init_msg_list => FND_API.G_FALSE,
3570: p_validation_mode => p_validation_mode,
3571: p_PARAMN2 => P_REPH_Rec.PARAMN2,
3572: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3573: x_return_status => x_return_status,
3572: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3573: x_return_status => x_return_status,
3574: x_msg_count => x_msg_count,
3575: x_msg_data => x_msg_data);
3576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3577: raise FND_API.G_EXC_ERROR;
3578: END IF;
3579:
3580:
3573: x_return_status => x_return_status,
3574: x_msg_count => x_msg_count,
3575: x_msg_data => x_msg_data);
3576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3577: raise FND_API.G_EXC_ERROR;
3578: END IF;
3579:
3580:
3581: Validate_PARAMN3(
3578: END IF;
3579:
3580:
3581: Validate_PARAMN3(
3582: p_init_msg_list => FND_API.G_FALSE,
3583: p_validation_mode => p_validation_mode,
3584: p_PARAMN3 => P_REPH_Rec.PARAMN3,
3585: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3586: x_return_status => x_return_status,
3585: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3586: x_return_status => x_return_status,
3587: x_msg_count => x_msg_count,
3588: x_msg_data => x_msg_data);
3589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3590: raise FND_API.G_EXC_ERROR;
3591: END IF;
3592:
3593: Validate_PARAMN4(
3586: x_return_status => x_return_status,
3587: x_msg_count => x_msg_count,
3588: x_msg_data => x_msg_data);
3589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3590: raise FND_API.G_EXC_ERROR;
3591: END IF;
3592:
3593: Validate_PARAMN4(
3594: p_init_msg_list => FND_API.G_FALSE,
3590: raise FND_API.G_EXC_ERROR;
3591: END IF;
3592:
3593: Validate_PARAMN4(
3594: p_init_msg_list => FND_API.G_FALSE,
3595: p_validation_mode => p_validation_mode,
3596: p_PARAMN4 => P_REPH_Rec.PARAMN4,
3597: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3598: x_return_status => x_return_status,
3597: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3598: x_return_status => x_return_status,
3599: x_msg_count => x_msg_count,
3600: x_msg_data => x_msg_data);
3601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3602: raise FND_API.G_EXC_ERROR;
3603: END IF;
3604:
3605: Validate_PARAMN5(
3598: x_return_status => x_return_status,
3599: x_msg_count => x_msg_count,
3600: x_msg_data => x_msg_data);
3601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3602: raise FND_API.G_EXC_ERROR;
3603: END IF;
3604:
3605: Validate_PARAMN5(
3606: p_init_msg_list => FND_API.G_FALSE,
3602: raise FND_API.G_EXC_ERROR;
3603: END IF;
3604:
3605: Validate_PARAMN5(
3606: p_init_msg_list => FND_API.G_FALSE,
3607: p_validation_mode => p_validation_mode,
3608: p_PARAMN5 => P_REPH_Rec.PARAMN5,
3609: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3610: x_return_status => x_return_status,
3609: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3610: x_return_status => x_return_status,
3611: x_msg_count => x_msg_count,
3612: x_msg_data => x_msg_data);
3613: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3614: raise FND_API.G_EXC_ERROR;
3615: END IF;
3616:
3617: Validate_PARAMN6(
3610: x_return_status => x_return_status,
3611: x_msg_count => x_msg_count,
3612: x_msg_data => x_msg_data);
3613: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3614: raise FND_API.G_EXC_ERROR;
3615: END IF;
3616:
3617: Validate_PARAMN6(
3618: p_init_msg_list => FND_API.G_FALSE,
3614: raise FND_API.G_EXC_ERROR;
3615: END IF;
3616:
3617: Validate_PARAMN6(
3618: p_init_msg_list => FND_API.G_FALSE,
3619: p_validation_mode => p_validation_mode,
3620: p_PARAMN6 => P_REPH_Rec.PARAMN6,
3621: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3622: x_return_status => x_return_status,
3621: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3622: x_return_status => x_return_status,
3623: x_msg_count => x_msg_count,
3624: x_msg_data => x_msg_data);
3625: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3626: raise FND_API.G_EXC_ERROR;
3627: END IF;
3628:
3629: Validate_PARAMN7(
3622: x_return_status => x_return_status,
3623: x_msg_count => x_msg_count,
3624: x_msg_data => x_msg_data);
3625: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3626: raise FND_API.G_EXC_ERROR;
3627: END IF;
3628:
3629: Validate_PARAMN7(
3630: p_init_msg_list => FND_API.G_FALSE,
3626: raise FND_API.G_EXC_ERROR;
3627: END IF;
3628:
3629: Validate_PARAMN7(
3630: p_init_msg_list => FND_API.G_FALSE,
3631: p_validation_mode => p_validation_mode,
3632: p_PARAMN7 => P_REPH_Rec.PARAMN7,
3633: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3634: x_return_status => x_return_status,
3633: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3634: x_return_status => x_return_status,
3635: x_msg_count => x_msg_count,
3636: x_msg_data => x_msg_data);
3637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3638: raise FND_API.G_EXC_ERROR;
3639: END IF;
3640:
3641: Validate_PARAMN8(
3634: x_return_status => x_return_status,
3635: x_msg_count => x_msg_count,
3636: x_msg_data => x_msg_data);
3637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3638: raise FND_API.G_EXC_ERROR;
3639: END IF;
3640:
3641: Validate_PARAMN8(
3642: p_init_msg_list => FND_API.G_FALSE,
3638: raise FND_API.G_EXC_ERROR;
3639: END IF;
3640:
3641: Validate_PARAMN8(
3642: p_init_msg_list => FND_API.G_FALSE,
3643: p_validation_mode => p_validation_mode,
3644: p_PARAMN8 => P_REPH_Rec.PARAMN8,
3645: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3646: x_return_status => x_return_status,
3645: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3646: x_return_status => x_return_status,
3647: x_msg_count => x_msg_count,
3648: x_msg_data => x_msg_data);
3649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3650: raise FND_API.G_EXC_ERROR;
3651: END IF;
3652:
3653: Validate_PARAMN9(
3646: x_return_status => x_return_status,
3647: x_msg_count => x_msg_count,
3648: x_msg_data => x_msg_data);
3649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3650: raise FND_API.G_EXC_ERROR;
3651: END IF;
3652:
3653: Validate_PARAMN9(
3654: p_init_msg_list => FND_API.G_FALSE,
3650: raise FND_API.G_EXC_ERROR;
3651: END IF;
3652:
3653: Validate_PARAMN9(
3654: p_init_msg_list => FND_API.G_FALSE,
3655: p_validation_mode => p_validation_mode,
3656: p_PARAMN9 => P_REPH_Rec.PARAMN9,
3657: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3658: x_return_status => x_return_status,
3657: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3658: x_return_status => x_return_status,
3659: x_msg_count => x_msg_count,
3660: x_msg_data => x_msg_data);
3661: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3662: raise FND_API.G_EXC_ERROR;
3663: END IF;
3664:
3665: Validate_PARAMN10(
3658: x_return_status => x_return_status,
3659: x_msg_count => x_msg_count,
3660: x_msg_data => x_msg_data);
3661: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3662: raise FND_API.G_EXC_ERROR;
3663: END IF;
3664:
3665: Validate_PARAMN10(
3666: p_init_msg_list => FND_API.G_FALSE,
3662: raise FND_API.G_EXC_ERROR;
3663: END IF;
3664:
3665: Validate_PARAMN10(
3666: p_init_msg_list => FND_API.G_FALSE,
3667: p_validation_mode => p_validation_mode,
3668: p_PARAMN10 => P_REPH_Rec.PARAMN10,
3669: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3670: x_return_status => x_return_status,
3669: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3670: x_return_status => x_return_status,
3671: x_msg_count => x_msg_count,
3672: x_msg_data => x_msg_data);
3673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3674: raise FND_API.G_EXC_ERROR;
3675: END IF;
3676:
3677: Validate_PARAMC1(
3670: x_return_status => x_return_status,
3671: x_msg_count => x_msg_count,
3672: x_msg_data => x_msg_data);
3673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3674: raise FND_API.G_EXC_ERROR;
3675: END IF;
3676:
3677: Validate_PARAMC1(
3678: p_init_msg_list => FND_API.G_FALSE,
3674: raise FND_API.G_EXC_ERROR;
3675: END IF;
3676:
3677: Validate_PARAMC1(
3678: p_init_msg_list => FND_API.G_FALSE,
3679: p_validation_mode => p_validation_mode,
3680: p_PARAMC1 => P_REPH_Rec.PARAMC1,
3681: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3682: x_return_status => x_return_status,
3681: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3682: x_return_status => x_return_status,
3683: x_msg_count => x_msg_count,
3684: x_msg_data => x_msg_data);
3685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3686: raise FND_API.G_EXC_ERROR;
3687: END IF;
3688:
3689: Validate_PARAMC2(
3682: x_return_status => x_return_status,
3683: x_msg_count => x_msg_count,
3684: x_msg_data => x_msg_data);
3685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3686: raise FND_API.G_EXC_ERROR;
3687: END IF;
3688:
3689: Validate_PARAMC2(
3690: p_init_msg_list => FND_API.G_FALSE,
3686: raise FND_API.G_EXC_ERROR;
3687: END IF;
3688:
3689: Validate_PARAMC2(
3690: p_init_msg_list => FND_API.G_FALSE,
3691: p_validation_mode => p_validation_mode,
3692: p_PARAMC2 => P_REPH_Rec.PARAMC2,
3693: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3694: x_return_status => x_return_status,
3693: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3694: x_return_status => x_return_status,
3695: x_msg_count => x_msg_count,
3696: x_msg_data => x_msg_data);
3697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3698: raise FND_API.G_EXC_ERROR;
3699: END IF;
3700: /*
3701: Validate_PARAMC3(
3694: x_return_status => x_return_status,
3695: x_msg_count => x_msg_count,
3696: x_msg_data => x_msg_data);
3697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3698: raise FND_API.G_EXC_ERROR;
3699: END IF;
3700: /*
3701: Validate_PARAMC3(
3702: p_init_msg_list => FND_API.G_FALSE,
3698: raise FND_API.G_EXC_ERROR;
3699: END IF;
3700: /*
3701: Validate_PARAMC3(
3702: p_init_msg_list => FND_API.G_FALSE,
3703: p_validation_mode => p_validation_mode,
3704: p_PARAMC3 => P_REPH_Rec.PARAMC3,
3705: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3706: x_return_status => x_return_status,
3705: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3706: x_return_status => x_return_status,
3707: x_msg_count => x_msg_count,
3708: x_msg_data => x_msg_data);
3709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3710: raise FND_API.G_EXC_ERROR;
3711: END IF;
3712:
3713: */
3706: x_return_status => x_return_status,
3707: x_msg_count => x_msg_count,
3708: x_msg_data => x_msg_data);
3709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3710: raise FND_API.G_EXC_ERROR;
3711: END IF;
3712:
3713: */
3714:
3712:
3713: */
3714:
3715: Validate_PARAMC4(
3716: p_init_msg_list => FND_API.G_FALSE,
3717: p_validation_mode => p_validation_mode,
3718: p_PARAMC4 => P_REPH_Rec.PARAMC4,
3719: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3720: x_return_status => x_return_status,
3719: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3720: x_return_status => x_return_status,
3721: x_msg_count => x_msg_count,
3722: x_msg_data => x_msg_data);
3723: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3724: raise FND_API.G_EXC_ERROR;
3725: END IF;
3726:
3727: Validate_PARAMC5(
3720: x_return_status => x_return_status,
3721: x_msg_count => x_msg_count,
3722: x_msg_data => x_msg_data);
3723: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3724: raise FND_API.G_EXC_ERROR;
3725: END IF;
3726:
3727: Validate_PARAMC5(
3728: p_init_msg_list => FND_API.G_FALSE,
3724: raise FND_API.G_EXC_ERROR;
3725: END IF;
3726:
3727: Validate_PARAMC5(
3728: p_init_msg_list => FND_API.G_FALSE,
3729: p_validation_mode => p_validation_mode,
3730: p_PARAMC5 => P_REPH_Rec.PARAMC5,
3731: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3732: x_return_status => x_return_status,
3731: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3732: x_return_status => x_return_status,
3733: x_msg_count => x_msg_count,
3734: x_msg_data => x_msg_data);
3735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3736: raise FND_API.G_EXC_ERROR;
3737: END IF;
3738:
3739: Validate_PARAMC6(
3732: x_return_status => x_return_status,
3733: x_msg_count => x_msg_count,
3734: x_msg_data => x_msg_data);
3735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3736: raise FND_API.G_EXC_ERROR;
3737: END IF;
3738:
3739: Validate_PARAMC6(
3740: p_init_msg_list => FND_API.G_FALSE,
3736: raise FND_API.G_EXC_ERROR;
3737: END IF;
3738:
3739: Validate_PARAMC6(
3740: p_init_msg_list => FND_API.G_FALSE,
3741: p_validation_mode => p_validation_mode,
3742: p_PARAMC6 => P_REPH_Rec.PARAMC6,
3743: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3744: x_return_status => x_return_status,
3743: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3744: x_return_status => x_return_status,
3745: x_msg_count => x_msg_count,
3746: x_msg_data => x_msg_data);
3747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3748: raise FND_API.G_EXC_ERROR;
3749: END IF;
3750:
3751: Validate_PARAMC7(
3744: x_return_status => x_return_status,
3745: x_msg_count => x_msg_count,
3746: x_msg_data => x_msg_data);
3747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3748: raise FND_API.G_EXC_ERROR;
3749: END IF;
3750:
3751: Validate_PARAMC7(
3752: p_init_msg_list => FND_API.G_FALSE,
3748: raise FND_API.G_EXC_ERROR;
3749: END IF;
3750:
3751: Validate_PARAMC7(
3752: p_init_msg_list => FND_API.G_FALSE,
3753: p_validation_mode => p_validation_mode,
3754: p_PARAMC7 => P_REPH_Rec.PARAMC7,
3755: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3756: x_return_status => x_return_status,
3755: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3756: x_return_status => x_return_status,
3757: x_msg_count => x_msg_count,
3758: x_msg_data => x_msg_data);
3759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3760: raise FND_API.G_EXC_ERROR;
3761: END IF;
3762:
3763: Validate_PARAMC8(
3756: x_return_status => x_return_status,
3757: x_msg_count => x_msg_count,
3758: x_msg_data => x_msg_data);
3759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3760: raise FND_API.G_EXC_ERROR;
3761: END IF;
3762:
3763: Validate_PARAMC8(
3764: p_init_msg_list => FND_API.G_FALSE,
3760: raise FND_API.G_EXC_ERROR;
3761: END IF;
3762:
3763: Validate_PARAMC8(
3764: p_init_msg_list => FND_API.G_FALSE,
3765: p_validation_mode => p_validation_mode,
3766: p_PARAMC8 => P_REPH_Rec.PARAMC8,
3767: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3768: x_return_status => x_return_status,
3767: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3768: x_return_status => x_return_status,
3769: x_msg_count => x_msg_count,
3770: x_msg_data => x_msg_data);
3771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3772: raise FND_API.G_EXC_ERROR;
3773: END IF;
3774:
3775: Validate_PARAMC9(
3768: x_return_status => x_return_status,
3769: x_msg_count => x_msg_count,
3770: x_msg_data => x_msg_data);
3771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3772: raise FND_API.G_EXC_ERROR;
3773: END IF;
3774:
3775: Validate_PARAMC9(
3776: p_init_msg_list => FND_API.G_FALSE,
3772: raise FND_API.G_EXC_ERROR;
3773: END IF;
3774:
3775: Validate_PARAMC9(
3776: p_init_msg_list => FND_API.G_FALSE,
3777: p_validation_mode => p_validation_mode,
3778: p_PARAMC9 => P_REPH_Rec.PARAMC9,
3779: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3780: x_return_status => x_return_status,
3779: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3780: x_return_status => x_return_status,
3781: x_msg_count => x_msg_count,
3782: x_msg_data => x_msg_data);
3783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3784: raise FND_API.G_EXC_ERROR;
3785: END IF;
3786:
3787: Validate_PARAMC10(
3780: x_return_status => x_return_status,
3781: x_msg_count => x_msg_count,
3782: x_msg_data => x_msg_data);
3783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3784: raise FND_API.G_EXC_ERROR;
3785: END IF;
3786:
3787: Validate_PARAMC10(
3788: p_init_msg_list => FND_API.G_FALSE,
3784: raise FND_API.G_EXC_ERROR;
3785: END IF;
3786:
3787: Validate_PARAMC10(
3788: p_init_msg_list => FND_API.G_FALSE,
3789: p_validation_mode => p_validation_mode,
3790: p_PARAMC10 => P_REPH_Rec.PARAMC10,
3791: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3792: x_return_status => x_return_status,
3791: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3792: x_return_status => x_return_status,
3793: x_msg_count => x_msg_count,
3794: x_msg_data => x_msg_data);
3795: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3796: raise FND_API.G_EXC_ERROR;
3797: END IF;
3798:
3799: Validate_PARAMD1(
3792: x_return_status => x_return_status,
3793: x_msg_count => x_msg_count,
3794: x_msg_data => x_msg_data);
3795: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3796: raise FND_API.G_EXC_ERROR;
3797: END IF;
3798:
3799: Validate_PARAMD1(
3800: p_init_msg_list => FND_API.G_FALSE,
3796: raise FND_API.G_EXC_ERROR;
3797: END IF;
3798:
3799: Validate_PARAMD1(
3800: p_init_msg_list => FND_API.G_FALSE,
3801: p_validation_mode => p_validation_mode,
3802: p_PARAMD1 => P_REPH_Rec.PARAMD1,
3803: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3804: x_return_status => x_return_status,
3803: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3804: x_return_status => x_return_status,
3805: x_msg_count => x_msg_count,
3806: x_msg_data => x_msg_data);
3807: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3808: raise FND_API.G_EXC_ERROR;
3809: END IF;
3810:
3811: Validate_PARAMD2(
3804: x_return_status => x_return_status,
3805: x_msg_count => x_msg_count,
3806: x_msg_data => x_msg_data);
3807: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3808: raise FND_API.G_EXC_ERROR;
3809: END IF;
3810:
3811: Validate_PARAMD2(
3812: p_init_msg_list => FND_API.G_FALSE,
3808: raise FND_API.G_EXC_ERROR;
3809: END IF;
3810:
3811: Validate_PARAMD2(
3812: p_init_msg_list => FND_API.G_FALSE,
3813: p_validation_mode => p_validation_mode,
3814: p_PARAMD2 => P_REPH_Rec.PARAMD2,
3815: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3816: x_return_status => x_return_status,
3815: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3816: x_return_status => x_return_status,
3817: x_msg_count => x_msg_count,
3818: x_msg_data => x_msg_data);
3819: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3820: raise FND_API.G_EXC_ERROR;
3821: END IF;
3822:
3823: Validate_PARAMD3(
3816: x_return_status => x_return_status,
3817: x_msg_count => x_msg_count,
3818: x_msg_data => x_msg_data);
3819: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3820: raise FND_API.G_EXC_ERROR;
3821: END IF;
3822:
3823: Validate_PARAMD3(
3824: p_init_msg_list => FND_API.G_FALSE,
3820: raise FND_API.G_EXC_ERROR;
3821: END IF;
3822:
3823: Validate_PARAMD3(
3824: p_init_msg_list => FND_API.G_FALSE,
3825: p_validation_mode => p_validation_mode,
3826: p_PARAMD3 => P_REPH_Rec.PARAMD3,
3827: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3828: x_return_status => x_return_status,
3827: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3828: x_return_status => x_return_status,
3829: x_msg_count => x_msg_count,
3830: x_msg_data => x_msg_data);
3831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3832: raise FND_API.G_EXC_ERROR;
3833: END IF;
3834:
3835: Validate_PARAMD4(
3828: x_return_status => x_return_status,
3829: x_msg_count => x_msg_count,
3830: x_msg_data => x_msg_data);
3831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3832: raise FND_API.G_EXC_ERROR;
3833: END IF;
3834:
3835: Validate_PARAMD4(
3836: p_init_msg_list => FND_API.G_FALSE,
3832: raise FND_API.G_EXC_ERROR;
3833: END IF;
3834:
3835: Validate_PARAMD4(
3836: p_init_msg_list => FND_API.G_FALSE,
3837: p_validation_mode => p_validation_mode,
3838: p_PARAMD4 => P_REPH_Rec.PARAMD4,
3839: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3840: x_return_status => x_return_status,
3839: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3840: x_return_status => x_return_status,
3841: x_msg_count => x_msg_count,
3842: x_msg_data => x_msg_data);
3843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3844: raise FND_API.G_EXC_ERROR;
3845: END IF;
3846:
3847: Validate_PARAMD5(
3840: x_return_status => x_return_status,
3841: x_msg_count => x_msg_count,
3842: x_msg_data => x_msg_data);
3843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3844: raise FND_API.G_EXC_ERROR;
3845: END IF;
3846:
3847: Validate_PARAMD5(
3848: p_init_msg_list => FND_API.G_FALSE,
3844: raise FND_API.G_EXC_ERROR;
3845: END IF;
3846:
3847: Validate_PARAMD5(
3848: p_init_msg_list => FND_API.G_FALSE,
3849: p_validation_mode => p_validation_mode,
3850: p_PARAMD5 => P_REPH_Rec.PARAMD5,
3851: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3852: x_return_status => x_return_status,
3851: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3852: x_return_status => x_return_status,
3853: x_msg_count => x_msg_count,
3854: x_msg_data => x_msg_data);
3855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3856: raise FND_API.G_EXC_ERROR;
3857: END IF;
3858:
3859: Validate_PARAMD6(
3852: x_return_status => x_return_status,
3853: x_msg_count => x_msg_count,
3854: x_msg_data => x_msg_data);
3855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3856: raise FND_API.G_EXC_ERROR;
3857: END IF;
3858:
3859: Validate_PARAMD6(
3860: p_init_msg_list => FND_API.G_FALSE,
3856: raise FND_API.G_EXC_ERROR;
3857: END IF;
3858:
3859: Validate_PARAMD6(
3860: p_init_msg_list => FND_API.G_FALSE,
3861: p_validation_mode => p_validation_mode,
3862: p_PARAMD6 => P_REPH_Rec.PARAMD6,
3863: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3864: x_return_status => x_return_status,
3863: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3864: x_return_status => x_return_status,
3865: x_msg_count => x_msg_count,
3866: x_msg_data => x_msg_data);
3867: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3868: raise FND_API.G_EXC_ERROR;
3869: END IF;
3870:
3871: Validate_PARAMD7(
3864: x_return_status => x_return_status,
3865: x_msg_count => x_msg_count,
3866: x_msg_data => x_msg_data);
3867: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3868: raise FND_API.G_EXC_ERROR;
3869: END IF;
3870:
3871: Validate_PARAMD7(
3872: p_init_msg_list => FND_API.G_FALSE,
3868: raise FND_API.G_EXC_ERROR;
3869: END IF;
3870:
3871: Validate_PARAMD7(
3872: p_init_msg_list => FND_API.G_FALSE,
3873: p_validation_mode => p_validation_mode,
3874: p_PARAMD7 => P_REPH_Rec.PARAMD7,
3875: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3876: x_return_status => x_return_status,
3875: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3876: x_return_status => x_return_status,
3877: x_msg_count => x_msg_count,
3878: x_msg_data => x_msg_data);
3879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3880: raise FND_API.G_EXC_ERROR;
3881: END IF;
3882:
3883: Validate_PARAMD8(
3876: x_return_status => x_return_status,
3877: x_msg_count => x_msg_count,
3878: x_msg_data => x_msg_data);
3879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3880: raise FND_API.G_EXC_ERROR;
3881: END IF;
3882:
3883: Validate_PARAMD8(
3884: p_init_msg_list => FND_API.G_FALSE,
3880: raise FND_API.G_EXC_ERROR;
3881: END IF;
3882:
3883: Validate_PARAMD8(
3884: p_init_msg_list => FND_API.G_FALSE,
3885: p_validation_mode => p_validation_mode,
3886: p_PARAMD8 => P_REPH_Rec.PARAMD8,
3887: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3888: x_return_status => x_return_status,
3887: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3888: x_return_status => x_return_status,
3889: x_msg_count => x_msg_count,
3890: x_msg_data => x_msg_data);
3891: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3892: raise FND_API.G_EXC_ERROR;
3893: END IF;
3894:
3895: Validate_PARAMD9(
3888: x_return_status => x_return_status,
3889: x_msg_count => x_msg_count,
3890: x_msg_data => x_msg_data);
3891: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3892: raise FND_API.G_EXC_ERROR;
3893: END IF;
3894:
3895: Validate_PARAMD9(
3896: p_init_msg_list => FND_API.G_FALSE,
3892: raise FND_API.G_EXC_ERROR;
3893: END IF;
3894:
3895: Validate_PARAMD9(
3896: p_init_msg_list => FND_API.G_FALSE,
3897: p_validation_mode => p_validation_mode,
3898: p_PARAMD9 => P_REPH_Rec.PARAMD9,
3899: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3900: x_return_status => x_return_status,
3899: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3900: x_return_status => x_return_status,
3901: x_msg_count => x_msg_count,
3902: x_msg_data => x_msg_data);
3903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3904: raise FND_API.G_EXC_ERROR;
3905: END IF;
3906:
3907: Validate_PARAMD10(
3900: x_return_status => x_return_status,
3901: x_msg_count => x_msg_count,
3902: x_msg_data => x_msg_data);
3903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3904: raise FND_API.G_EXC_ERROR;
3905: END IF;
3906:
3907: Validate_PARAMD10(
3908: p_init_msg_list => FND_API.G_FALSE,
3904: raise FND_API.G_EXC_ERROR;
3905: END IF;
3906:
3907: Validate_PARAMD10(
3908: p_init_msg_list => FND_API.G_FALSE,
3909: p_validation_mode => p_validation_mode,
3910: p_PARAMD10 => P_REPH_Rec.PARAMD10,
3911: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3912: x_return_status => x_return_status,
3911: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
3912: x_return_status => x_return_status,
3913: x_msg_count => x_msg_count,
3914: x_msg_data => x_msg_data);
3915: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3916: raise FND_API.G_EXC_ERROR;
3917: END IF;
3918:
3919: -- travi OBJECT_VERSION_NUMBER validation
3912: x_return_status => x_return_status,
3913: x_msg_count => x_msg_count,
3914: x_msg_data => x_msg_data);
3915: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3916: raise FND_API.G_EXC_ERROR;
3917: END IF;
3918:
3919: -- travi OBJECT_VERSION_NUMBER validation
3920: Validate_OBJECT_VERSION_NUMBER(
3917: END IF;
3918:
3919: -- travi OBJECT_VERSION_NUMBER validation
3920: Validate_OBJECT_VERSION_NUMBER(
3921: p_init_msg_list => FND_API.G_FALSE,
3922: p_validation_mode => p_validation_mode,
3923: p_OBJECT_VERSION_NUMBER => P_REPH_Rec.OBJECT_VERSION_NUMBER,
3924: p_REPAIR_HISTORY_ID => P_REPH_Rec.REPAIR_HISTORY_ID,
3925: x_return_status => x_return_status,
3924: p_REPAIR_HISTORY_ID => P_REPH_Rec.REPAIR_HISTORY_ID,
3925: x_return_status => x_return_status,
3926: x_msg_count => x_msg_count,
3927: x_msg_data => x_msg_data);
3928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3929: raise FND_API.G_EXC_ERROR;
3930: END IF;
3931:
3932: END IF;
3925: x_return_status => x_return_status,
3926: x_msg_count => x_msg_count,
3927: x_msg_data => x_msg_data);
3928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3929: raise FND_API.G_EXC_ERROR;
3930: END IF;
3931:
3932: END IF;
3933:
3934: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
3935: -- Hint: Inter-field level validation can be added here
3936: -- invoke record level validation procedures
3937: Validate_REPH_Rec(
3938: p_init_msg_list => FND_API.G_FALSE,
3939: p_validation_mode => p_validation_mode,
3940: P_REPH_Rec => P_REPH_Rec,
3941: x_return_status => x_return_status,
3942: x_msg_count => x_msg_count,
3941: x_return_status => x_return_status,
3942: x_msg_count => x_msg_count,
3943: x_msg_data => x_msg_data);
3944:
3945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: raise FND_API.G_EXC_ERROR;
3947: END IF;
3948: END IF;
3949:
3942: x_msg_count => x_msg_count,
3943: x_msg_data => x_msg_data);
3944:
3945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: raise FND_API.G_EXC_ERROR;
3947: END IF;
3948: END IF;
3949:
3950: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN