[Home] [Help]
21: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
22: -- Hint: Primary key needs to be returned.
23: PROCEDURE CREATE_REPJOBXREF(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
26: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type := G_MISS_REPJOBXREF_REC,
29: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
22: -- Hint: Primary key needs to be returned.
23: PROCEDURE CREATE_REPJOBXREF(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
26: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type := G_MISS_REPJOBXREF_REC,
29: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
30: X_REPAIR_JOB_XREF_ID OUT NOCOPY NUMBER,
23: PROCEDURE CREATE_REPJOBXREF(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
26: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type := G_MISS_REPJOBXREF_REC,
29: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
30: X_REPAIR_JOB_XREF_ID OUT NOCOPY NUMBER,
31: X_Return_Status OUT NOCOPY VARCHAR2,
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_REPJOBXREF_PVT;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)
50: THEN
47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)
50: THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53:
54:
55: -- Initialize message list if p_init_msg_list is set to TRUE.
52: END IF;
53:
54:
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean( p_init_msg_list )
57: THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
63: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
64:
65:
66: -- Initialize API return status to SUCCESS
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: --
70: -- API body
71: --
76: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
77: THEN
78: AS_CALLOUT_PKG.Create_repjobxref_BC(
79: p_api_version_number => 2.0,
80: p_init_msg_list => FND_API.G_FALSE,
81: p_commit => FND_API.G_FALSE,
82: p_validation_level => p_validation_level,
83: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
84: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
77: THEN
78: AS_CALLOUT_PKG.Create_repjobxref_BC(
79: p_api_version_number => 2.0,
80: p_init_msg_list => FND_API.G_FALSE,
81: p_commit => FND_API.G_FALSE,
82: p_validation_level => p_validation_level,
83: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
84: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
85: x_return_status => x_return_status,
97: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
98: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
99: FND_MSG_PUB.ADD;
100: END IF;
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103: /*
104:
105: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
109: ,x_msg_count => x_msg_count
110: ,x_msg_data => x_msg_data
111: ,x_sales_member_rec => l_identity_sales_member_rec);
112:
113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: */
117:
110: ,x_msg_data => x_msg_data
111: ,x_sales_member_rec => l_identity_sales_member_rec);
112:
113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: */
117:
118:
115: END IF;
116: */
117:
118:
119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');
123:
122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');
123:
124: -- Invoke validation procedures
125: Validate_repjobxref(
126: p_init_msg_list => FND_API.G_FALSE,
127: p_validation_level => p_validation_level,
128: p_validation_mode => JTF_PLSQL_API.G_CREATE,
129: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
130: x_return_status => x_return_status,
131: x_msg_count => x_msg_count,
132: x_msg_data => x_msg_data);
133: END IF;
134:
135: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Hint: Add corresponding Master-Detail business logic here if necessary.
132: x_msg_data => x_msg_data);
133: END IF;
134:
135: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Hint: Add corresponding Master-Detail business logic here if necessary.
140:
180: p_QUANTITY_COMPLETED => p_REPJOBXREF_rec.QUANTITY_COMPLETED);
181: -- Hint: Primary key should be returned.
182: -- x_REPAIR_JOB_XREF_ID := px_REPAIR_JOB_XREF_ID;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: --
181: -- Hint: Primary key should be returned.
182: -- x_REPAIR_JOB_XREF_ID := px_REPAIR_JOB_XREF_ID;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: --
189: -- End of API body
189: -- End of API body
190: --
191:
192: -- Standard check for p_commit
193: IF FND_API.to_Boolean( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;
197:
212: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
213: THEN
214: AS_CALLOUT_PKG.Create_repjobxref_AC(
215: p_api_version_number => 2.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_commit => FND_API.G_FALSE,
218: p_validation_level => p_validation_level,
219: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
220: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
213: THEN
214: AS_CALLOUT_PKG.Create_repjobxref_AC(
215: p_api_version_number => 2.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_commit => FND_API.G_FALSE,
218: p_validation_level => p_validation_level,
219: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
220: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
221: x_return_status => x_return_status,
223: x_msg_data => x_msg_data);
224: END IF;
225: */
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
229: P_API_NAME => L_API_NAME
230: ,P_PKG_NAME => G_PKG_NAME
231: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
234: ,X_MSG_DATA => X_MSG_DATA
235: ,X_RETURN_STATUS => X_RETURN_STATUS);
236: -- RAISE;
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
240: P_API_NAME => L_API_NAME
241: ,P_PKG_NAME => G_PKG_NAME
242: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
261:
262: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
263: PROCEDURE Update_repjobxref(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
269: X_Return_Status OUT NOCOPY VARCHAR2,
262: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
263: PROCEDURE Update_repjobxref(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
269: X_Return_Status OUT NOCOPY VARCHAR2,
270: X_Msg_Count OUT NOCOPY NUMBER,
263: PROCEDURE Update_repjobxref(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
269: X_Return_Status OUT NOCOPY VARCHAR2,
270: X_Msg_Count OUT NOCOPY NUMBER,
271: X_Msg_Data OUT NOCOPY VARCHAR2
322: -- Standard Start of API savepoint
323: SAVEPOINT UPDATE_REPJOBXREF_PVT;
324:
325: -- Standard call to check for call compatibility.
326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
327: p_api_version_number,
328: l_api_name,
329: G_PKG_NAME)
330: THEN
327: p_api_version_number,
328: l_api_name,
329: G_PKG_NAME)
330: THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.
332: END IF;
333:
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean( p_init_msg_list )
337: THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:
343: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
344:
345:
346: -- Initialize API return status to SUCCESS
347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348:
349: --
350: -- Api body
351: --
355: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
356: THEN
357: AS_CALLOUT_PKG.Update_repjobxref_BU(
358: p_api_version_number => 2.0,
359: p_init_msg_list => FND_API.G_FALSE,
360: p_commit => FND_API.G_FALSE,
361: p_validation_level => p_validation_level,
362: p_identity_salesforce_id => p_identity_salesforce_id,
363: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
356: THEN
357: AS_CALLOUT_PKG.Update_repjobxref_BU(
358: p_api_version_number => 2.0,
359: p_init_msg_list => FND_API.G_FALSE,
360: p_commit => FND_API.G_FALSE,
361: p_validation_level => p_validation_level,
362: p_identity_salesforce_id => p_identity_salesforce_id,
363: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
364: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
375: ,x_msg_count => x_msg_count
376: ,x_msg_data => x_msg_data
377: ,x_sales_member_rec => l_identity_sales_member_rec);
378:
379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: */
383:
376: ,x_msg_data => x_msg_data
377: ,x_sales_member_rec => l_identity_sales_member_rec);
378:
379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: */
383:
384: -- Debug Message
428: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
429: FND_MESSAGE.Set_Token ('INFO', 'repjobxref', FALSE);
430: FND_MSG_PUB.Add;
431: END IF;
432: raise FND_API.G_EXC_ERROR;
433: END IF;
434: -- Debug Message
435: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Close Cursor');
436: Close C_Get_repjobxref;
437: */
438:
439:
440: If (l_tar_REPJOBXREF_rec.last_update_date is NULL or
441: l_tar_REPJOBXREF_rec.last_update_date = FND_API.G_MISS_Date ) Then
442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
443: THEN
444: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
445: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
444: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
445: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
446: FND_MSG_PUB.ADD;
447: END IF;
448: raise FND_API.G_EXC_ERROR;
449: End if;
450: -- Check Whether record has been changed by someone else
451: If (l_tar_REPJOBXREF_rec.last_update_date <> l_ref_REPJOBXREF_rec.last_update_date) Then
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
454: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
455: FND_MESSAGE.Set_Token('INFO', 'repjobxref', FALSE);
456: FND_MSG_PUB.ADD;
457: END IF;
458: raise FND_API.G_EXC_ERROR;
459: End if;
460:
461: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
462: THEN
457: END IF;
458: raise FND_API.G_EXC_ERROR;
459: End if;
460:
461: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
462: THEN
463: -- Debug message
464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');
465:
464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');
465:
466: -- Invoke validation procedures
467: Validate_repjobxref(
468: p_init_msg_list => FND_API.G_FALSE,
469: p_validation_level => p_validation_level,
470: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
471: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
472: x_return_status => x_return_status,
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: END IF;
476:
477: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: -- Hint: Add corresponding Master-Detail business logic here if necessary.
474: x_msg_data => x_msg_data);
475: END IF;
476:
477: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: -- Hint: Add corresponding Master-Detail business logic here if necessary.
482:
521: -- End of API body.
522: --
523:
524: -- Standard check for p_commit
525: IF FND_API.to_Boolean( p_commit )
526: THEN
527: COMMIT WORK;
528: END IF;
529:
544: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
545: THEN
546: AS_CALLOUT_PKG.Update_repjobxref_AU(
547: p_api_version_number => 2.0,
548: p_init_msg_list => FND_API.G_FALSE,
549: p_commit => FND_API.G_FALSE,
550: p_validation_level => p_validation_level,
551: p_identity_salesforce_id => p_identity_salesforce_id,
552: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
545: THEN
546: AS_CALLOUT_PKG.Update_repjobxref_AU(
547: p_api_version_number => 2.0,
548: p_init_msg_list => FND_API.G_FALSE,
549: p_commit => FND_API.G_FALSE,
550: p_validation_level => p_validation_level,
551: p_identity_salesforce_id => p_identity_salesforce_id,
552: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
553: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
556: x_msg_data => x_msg_data);
557: END IF;
558: */
559: EXCEPTION
560: WHEN FND_API.G_EXC_ERROR THEN
561: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
562: P_API_NAME => L_API_NAME
563: ,P_PKG_NAME => G_PKG_NAME
564: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
567: ,X_MSG_DATA => X_MSG_DATA
568: ,X_RETURN_STATUS => X_RETURN_STATUS);
569: -- RAISE;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
573: P_API_NAME => L_API_NAME
574: ,P_PKG_NAME => G_PKG_NAME
575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
595: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
596: -- The Master delete procedure may not be needed depends on different business requirements.
597: PROCEDURE Delete_repjobxref(
598: P_Api_Version_Number IN NUMBER,
599: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
600: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
602: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
603: X_Return_Status OUT NOCOPY VARCHAR2,
596: -- The Master delete procedure may not be needed depends on different business requirements.
597: PROCEDURE Delete_repjobxref(
598: P_Api_Version_Number IN NUMBER,
599: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
600: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
602: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
603: X_Return_Status OUT NOCOPY VARCHAR2,
604: X_Msg_Count OUT NOCOPY NUMBER,
597: PROCEDURE Delete_repjobxref(
598: P_Api_Version_Number IN NUMBER,
599: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
600: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
601: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
602: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
603: X_Return_Status OUT NOCOPY VARCHAR2,
604: X_Msg_Count OUT NOCOPY NUMBER,
605: X_Msg_Data OUT NOCOPY VARCHAR2
613: -- Standard Start of API savepoint
614: SAVEPOINT DELETE_REPJOBXREF_PVT;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
621: THEN
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
623: END IF;
624:
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF FND_API.to_Boolean( p_init_msg_list )
628: THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
634: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
635:
636:
637: -- Initialize API return status to SUCCESS
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: --
641: -- Api body
642: --
646: IF(FND_PROFILE.VALUE('AS_PRE_CUSTOM_ENABLED')='Y')
647: THEN
648: AS_CALLOUT_PKG.Delete_repjobxref_BD(
649: p_api_version_number => 2.0,
650: p_init_msg_list => FND_API.G_FALSE,
651: p_commit => FND_API.G_FALSE,
652: p_validation_level => p_validation_level,
653: p_identity_salesforce_id => p_identity_salesforce_id,
654: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
647: THEN
648: AS_CALLOUT_PKG.Delete_repjobxref_BD(
649: p_api_version_number => 2.0,
650: p_init_msg_list => FND_API.G_FALSE,
651: p_commit => FND_API.G_FALSE,
652: p_validation_level => p_validation_level,
653: p_identity_salesforce_id => p_identity_salesforce_id,
654: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
655: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
667: ,x_msg_count => x_msg_count
668: ,x_msg_data => x_msg_data
669: ,x_sales_member_rec => l_identity_sales_member_rec);
670:
671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: */
675: -- Debug Message
668: ,x_msg_data => x_msg_data
669: ,x_sales_member_rec => l_identity_sales_member_rec);
670:
671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: */
675: -- Debug Message
676: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
682: -- End of API body
683: --
684:
685: -- Standard check for p_commit
686: IF FND_API.to_Boolean( p_commit )
687: THEN
688: COMMIT WORK;
689: END IF;
690:
705: IF(FND_PROFILE.VALUE('AS_POST_CUSTOM_ENABLED')='Y')
706: THEN
707: AS_CALLOUT_PKG.Delete_repjobxref_AD(
708: p_api_version_number => 2.0,
709: p_init_msg_list => FND_API.G_FALSE,
710: p_commit => FND_API.G_FALSE,
711: p_validation_level => p_validation_level,
712: p_identity_salesforce_id => p_identity_salesforce_id,
713: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
706: THEN
707: AS_CALLOUT_PKG.Delete_repjobxref_AD(
708: p_api_version_number => 2.0,
709: p_init_msg_list => FND_API.G_FALSE,
710: p_commit => FND_API.G_FALSE,
711: p_validation_level => p_validation_level,
712: p_identity_salesforce_id => p_identity_salesforce_id,
713: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
714: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
717: x_msg_data => x_msg_data);
718: END IF;
719: */
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
723: P_API_NAME => L_API_NAME
724: ,P_PKG_NAME => G_PKG_NAME
725: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
728: ,X_MSG_DATA => X_MSG_DATA
729: ,X_RETURN_STATUS => X_RETURN_STATUS);
730: -- RAISE;
731:
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
734: P_API_NAME => L_API_NAME
735: ,P_PKG_NAME => G_PKG_NAME
736: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
864: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
865:
866: JTF_PLSQL_API.Translate_OrderBy(
867: p_api_version_number => 1.0
868: ,p_init_msg_list => FND_API.G_FALSE
869: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
870: ,p_order_by_tbl => l_util_order_by_tbl
871: ,x_order_by_clause => l_order_by_cl
872: ,x_return_status => x_return_status
865:
866: JTF_PLSQL_API.Translate_OrderBy(
867: p_api_version_number => 1.0
868: ,p_init_msg_list => FND_API.G_FALSE
869: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
870: ,p_order_by_tbl => l_util_order_by_tbl
871: ,x_order_by_clause => l_order_by_cl
872: ,x_return_status => x_return_status
873: ,x_msg_count => x_msg_count
897: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Begins');
898:
899: -- The following example applies to all columns,
900: -- developers can copy and paste them.
901: IF( (P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID IS NOT NULL) AND (P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID <> FND_API.G_MISS_NUM) )
902: THEN
903: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPJOBXREF, ':p_REPAIR_JOB_XREF_ID', P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID);
904: END IF;
905:
980: -- NUMBER, DATE, VARCHAR2.
981: -- Developer can copy and paste the following codes for your own record.
982:
983: -- example for NUMBER datatype
984: IF( (P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID IS NOT NULL) AND (P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID <> FND_API.G_MISS_NUM) )
985: THEN
986: IF(x_REPJOBXREF_where IS NULL) THEN
987: x_REPJOBXREF_where := 'Where';
988: ELSE
991: x_REPJOBXREF_where := x_REPJOBXREF_where || 'P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID = :p_REPAIR_JOB_XREF_ID';
992: END IF;
993:
994: -- example for DATE datatype
995: IF( (P_REPJOBXREF_Rec.CREATION_DATE IS NOT NULL) AND (P_REPJOBXREF_Rec.CREATION_DATE <> FND_API.G_MISS_DATE) )
996: THEN
997: -- check if item value contains '%' wildcard
998: OPEN c_chk_str1(P_REPJOBXREF_Rec.CREATION_DATE);
999: FETCH c_chk_str1 INTO str_csr1;
1024: x_REPJOBXREF_where := x_REPJOBXREF_where || 'P_REPJOBXREF_Rec.CREATION_DATE ' || l_operator || ' :p_CREATION_DATE';
1025: END IF;
1026:
1027: -- example for VARCHAR2 datatype
1028: IF( (P_REPJOBXREF_Rec.ATTRIBUTE_CATEGORY IS NOT NULL) AND (P_REPJOBXREF_Rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR) )
1029: THEN
1030: -- check if item value contains '%' wildcard
1031: OPEN c_chk_str1(P_REPJOBXREF_Rec.ATTRIBUTE_CATEGORY);
1032: FETCH c_chk_str1 INTO str_csr1;
1065: END Gen_REPJOBXREF_Where;
1066:
1067: PROCEDURE Get_repjobxref(
1068: P_Api_Version_Number IN NUMBER,
1069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1071: P_identity_salesforce_id IN NUMBER := NULL,
1072: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
1073: -- Hint: Add list of bind variables here
1066:
1067: PROCEDURE Get_repjobxref(
1068: P_Api_Version_Number IN NUMBER,
1069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1070: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1071: P_identity_salesforce_id IN NUMBER := NULL,
1072: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
1073: -- Hint: Add list of bind variables here
1074: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
1072: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
1073: -- Hint: Add list of bind variables here
1074: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
1075: p_start_rec_prt IN NUMBER := 1,
1076: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
1077: -- Hint: user defined record type
1078: p_order_by_rec IN REPJOBXREF_sort_rec_type,
1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_msg_count OUT NOCOPY NUMBER,
1125: -- Standard Start of API savepoint
1126: SAVEPOINT GET_REPJOBXREF_PVT;
1127:
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1130: p_api_version_number,
1131: l_api_name,
1132: G_PKG_NAME)
1133: THEN
1130: p_api_version_number,
1131: l_api_name,
1132: G_PKG_NAME)
1133: THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137:
1138: -- Initialize message list if p_init_msg_list is set to TRUE.
1135: END IF;
1136:
1137:
1138: -- Initialize message list if p_init_msg_list is set to TRUE.
1139: IF FND_API.to_Boolean( p_init_msg_list )
1140: THEN
1141: FND_MSG_PUB.initialize;
1142: END IF;
1143:
1146: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1147:
1148:
1149: -- Initialize API return status to SUCCESS
1150: x_return_status := FND_API.G_RET_STS_SUCCESS;
1151:
1152: --
1153: -- Api body
1154: --
1160: ,x_msg_count => x_msg_count
1161: ,x_msg_data => x_msg_data
1162: ,x_sales_member_rec => l_identity_sales_member_rec);
1163: */
1164: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;
1167:
1168: -- *************************************************
1161: ,x_msg_data => x_msg_data
1162: ,x_sales_member_rec => l_identity_sales_member_rec);
1163: */
1164: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;
1167:
1168: -- *************************************************
1169: -- Generate Dynamic SQL based on criteria passed in.
1254: LOOP
1255: -- 1. There are more rows in the cursor.
1256: -- 2. User does not care about total records, and we need to return more.
1257: -- 3. Or user cares about total number of records.
1258: IF((dbms_sql.fetch_rows(l_cur_get_REPJOBXREF)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1259: OR (l_returned_rec_count
1261: -- Debug Message
1262: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1255: -- 1. There are more rows in the cursor.
1256: -- 2. User does not care about total records, and we need to return more.
1257: -- 3. Or user cares about total number of records.
1258: IF((dbms_sql.fetch_rows(l_cur_get_REPJOBXREF)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1259: OR (l_returned_rec_count
1261: -- Debug Message
1262: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1263:
1300: p_data => x_msg_data
1301: );
1302:
1303: EXCEPTION
1304: WHEN FND_API.G_EXC_ERROR THEN
1305: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1306: P_API_NAME => L_API_NAME
1307: ,P_PKG_NAME => G_PKG_NAME
1308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1311: ,X_MSG_DATA => X_MSG_DATA
1312: ,X_RETURN_STATUS => X_RETURN_STATUS);
1313: -- RAISE;
1314:
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1317: P_API_NAME => L_API_NAME
1318: ,P_PKG_NAME => G_PKG_NAME
1319: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1337:
1338:
1339: -- Item-level validation procedures
1340: PROCEDURE Validate_REPAIR_JOB_XREF_ID (
1341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1342: P_Validation_mode IN VARCHAR2,
1343: P_REPAIR_JOB_XREF_ID IN NUMBER,
1344: -- 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.
1345: X_Return_Status OUT NOCOPY VARCHAR2,
1349: IS
1350: BEGIN
1351:
1352: -- Initialize message list if p_init_msg_list is set to TRUE.
1353: IF FND_API.to_Boolean( p_init_msg_list )
1354: THEN
1355: FND_MSG_PUB.initialize;
1356: END IF;
1357:
1356: END IF;
1357:
1358:
1359: -- Initialize API return status to SUCCESS
1360: x_return_status := FND_API.G_RET_STS_SUCCESS;
1361:
1362: -- validate NOT NULL column
1363: IF(p_REPAIR_JOB_XREF_ID is NULL)
1364: THEN
1362: -- validate NOT NULL column
1363: IF(p_REPAIR_JOB_XREF_ID is NULL)
1364: THEN
1365: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_JOB_XREF_ID)');
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:
1369: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1370: THEN
1370: THEN
1371: -- Hint: Validate data
1372: -- IF p_REPAIR_JOB_XREF_ID is not NULL and p_REPAIR_JOB_XREF_ID <> G_MISS_CHAR
1373: -- verify if data is valid
1374: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1375: NULL;
1376: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1377: THEN
1378: -- Hint: Validate data
1377: THEN
1378: -- Hint: Validate data
1379: -- IF p_REPAIR_JOB_XREF_ID <> G_MISS_CHAR
1380: -- verify if data is valid
1381: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1382: NULL;
1383: END IF;
1384:
1385: -- Standard call to get message count and if count is 1, get message info.
1391: END Validate_REPAIR_JOB_XREF_ID;
1392:
1393:
1394: PROCEDURE Validate_REPAIR_LINE_ID (
1395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1396: P_Validation_mode IN VARCHAR2,
1397: P_REPAIR_LINE_ID IN NUMBER,
1398: -- 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.
1399: X_Return_Status OUT NOCOPY VARCHAR2,
1403: IS
1404: BEGIN
1405:
1406: -- Initialize message list if p_init_msg_list is set to TRUE.
1407: IF FND_API.to_Boolean( p_init_msg_list )
1408: THEN
1409: FND_MSG_PUB.initialize;
1410: END IF;
1411:
1410: END IF;
1411:
1412:
1413: -- Initialize API return status to SUCCESS
1414: x_return_status := FND_API.G_RET_STS_SUCCESS;
1415:
1416: -- validate NOT NULL column
1417: IF(p_REPAIR_LINE_ID is NULL)
1418: THEN
1416: -- validate NOT NULL column
1417: IF(p_REPAIR_LINE_ID is NULL)
1418: THEN
1419: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: END IF;
1422:
1423: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1424: THEN
1424: THEN
1425: -- Hint: Validate data
1426: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1427: -- verify if data is valid
1428: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1429: NULL;
1430: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1431: THEN
1432: -- Hint: Validate data
1431: THEN
1432: -- Hint: Validate data
1433: -- IF p_REPAIR_LINE_ID <> G_MISS_CHAR
1434: -- verify if data is valid
1435: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1436: NULL;
1437: END IF;
1438:
1439: -- Standard call to get message count and if count is 1, get message info.
1445: END Validate_REPAIR_LINE_ID;
1446:
1447:
1448: PROCEDURE Validate_WIP_ENTITY_ID (
1449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1450: P_Validation_mode IN VARCHAR2,
1451: P_WIP_ENTITY_ID IN NUMBER,
1452: -- 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.
1453: X_Return_Status OUT NOCOPY VARCHAR2,
1457: IS
1458: BEGIN
1459:
1460: -- Initialize message list if p_init_msg_list is set to TRUE.
1461: IF FND_API.to_Boolean( p_init_msg_list )
1462: THEN
1463: FND_MSG_PUB.initialize;
1464: END IF;
1465:
1464: END IF;
1465:
1466:
1467: -- Initialize API return status to SUCCESS
1468: x_return_status := FND_API.G_RET_STS_SUCCESS;
1469:
1470: -- validate NOT NULL column
1471: IF(p_WIP_ENTITY_ID is NULL)
1472: THEN
1470: -- validate NOT NULL column
1471: IF(p_WIP_ENTITY_ID is NULL)
1472: THEN
1473: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(WIP_ENTITY_ID)');
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END IF;
1476:
1477: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1478: THEN
1478: THEN
1479: -- Hint: Validate data
1480: -- IF p_WIP_ENTITY_ID is not NULL and p_WIP_ENTITY_ID <> G_MISS_CHAR
1481: -- verify if data is valid
1482: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1483: NULL;
1484: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1485: THEN
1486: -- Hint: Validate data
1485: THEN
1486: -- Hint: Validate data
1487: -- IF p_WIP_ENTITY_ID <> G_MISS_CHAR
1488: -- verify if data is valid
1489: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1490: NULL;
1491: END IF;
1492:
1493: -- Standard call to get message count and if count is 1, get message info.
1499: END Validate_WIP_ENTITY_ID;
1500:
1501:
1502: PROCEDURE Validate_GROUP_ID (
1503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1504: P_Validation_mode IN VARCHAR2,
1505: P_GROUP_ID IN NUMBER,
1506: -- 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.
1507: X_Return_Status OUT NOCOPY VARCHAR2,
1511: IS
1512: BEGIN
1513:
1514: -- Initialize message list if p_init_msg_list is set to TRUE.
1515: IF FND_API.to_Boolean( p_init_msg_list )
1516: THEN
1517: FND_MSG_PUB.initialize;
1518: END IF;
1519:
1518: END IF;
1519:
1520:
1521: -- Initialize API return status to SUCCESS
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523:
1524: -- validate NOT NULL column
1525: IF(p_GROUP_ID is NULL)
1526: THEN
1524: -- validate NOT NULL column
1525: IF(p_GROUP_ID is NULL)
1526: THEN
1527: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(GROUP_ID)');
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530:
1531: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1532: THEN
1532: THEN
1533: -- Hint: Validate data
1534: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
1535: -- verify if data is valid
1536: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1537: NULL;
1538: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1539: THEN
1540: -- Hint: Validate data
1539: THEN
1540: -- Hint: Validate data
1541: -- IF p_GROUP_ID <> G_MISS_CHAR
1542: -- verify if data is valid
1543: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1544: NULL;
1545: END IF;
1546:
1547: -- Standard call to get message count and if count is 1, get message info.
1553: END Validate_GROUP_ID;
1554:
1555:
1556: PROCEDURE Validate_ORGANIZATION_ID (
1557: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1558: P_Validation_mode IN VARCHAR2,
1559: P_ORGANIZATION_ID IN NUMBER,
1560: -- 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.
1561: X_Return_Status OUT NOCOPY VARCHAR2,
1565: IS
1566: BEGIN
1567:
1568: -- Initialize message list if p_init_msg_list is set to TRUE.
1569: IF FND_API.to_Boolean( p_init_msg_list )
1570: THEN
1571: FND_MSG_PUB.initialize;
1572: END IF;
1573:
1572: END IF;
1573:
1574:
1575: -- Initialize API return status to SUCCESS
1576: x_return_status := FND_API.G_RET_STS_SUCCESS;
1577:
1578: -- validate NOT NULL column
1579: IF(p_ORGANIZATION_ID is NULL)
1580: THEN
1578: -- validate NOT NULL column
1579: IF(p_ORGANIZATION_ID is NULL)
1580: THEN
1581: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: END IF;
1584:
1585: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1586: THEN
1586: THEN
1587: -- Hint: Validate data
1588: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1589: -- verify if data is valid
1590: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1591: NULL;
1592: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1593: THEN
1594: -- Hint: Validate data
1593: THEN
1594: -- Hint: Validate data
1595: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
1596: -- verify if data is valid
1597: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1598: NULL;
1599: END IF;
1600:
1601: -- Standard call to get message count and if count is 1, get message info.
1607: END Validate_ORGANIZATION_ID;
1608:
1609:
1610: PROCEDURE Validate_QUANTITY (
1611: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1612: P_Validation_mode IN VARCHAR2,
1613: P_QUANTITY IN NUMBER,
1614: -- 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.
1615: X_Return_Status OUT NOCOPY VARCHAR2,
1619: IS
1620: BEGIN
1621:
1622: -- Initialize message list if p_init_msg_list is set to TRUE.
1623: IF FND_API.to_Boolean( p_init_msg_list )
1624: THEN
1625: FND_MSG_PUB.initialize;
1626: END IF;
1627:
1626: END IF;
1627:
1628:
1629: -- Initialize API return status to SUCCESS
1630: x_return_status := FND_API.G_RET_STS_SUCCESS;
1631:
1632: -- validate NOT NULL column
1633: IF(p_QUANTITY is NULL)
1634: THEN
1632: -- validate NOT NULL column
1633: IF(p_QUANTITY is NULL)
1634: THEN
1635: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(QUANTITY)');
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: END IF;
1638:
1639: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1640: THEN
1640: THEN
1641: -- Hint: Validate data
1642: -- IF p_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
1643: -- verify if data is valid
1644: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1645: NULL;
1646: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1647: THEN
1648: -- Hint: Validate data
1647: THEN
1648: -- Hint: Validate data
1649: -- IF p_QUANTITY <> G_MISS_CHAR
1650: -- verify if data is valid
1651: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1652: NULL;
1653: END IF;
1654:
1655: -- Standard call to get message count and if count is 1, get message info.
1661: END Validate_QUANTITY;
1662:
1663:
1664: PROCEDURE Validate_OBJECT_VERSION_NUMBER (
1665: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1666: P_Validation_mode IN VARCHAR2,
1667: P_OBJECT_VERSION_NUMBER IN NUMBER,
1668: P_REPAIR_JOB_XREF_ID IN NUMBER,
1669: -- 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.
1682: END IF;
1683:
1684:
1685: -- Initialize message list if p_init_msg_list is set to TRUE.
1686: IF FND_API.to_Boolean( p_init_msg_list )
1687: THEN
1688: FND_MSG_PUB.initialize;
1689: END IF;
1690:
1689: END IF;
1690:
1691:
1692: -- Initialize API return status to SUCCESS
1693: x_return_status := FND_API.G_RET_STS_SUCCESS;
1694:
1695: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1696: THEN
1697:
1708: --IF(p_OBJECT_VERSION_NUMBER is NULL) THEN
1709: -- set object_version_number to 1 for create
1710: -- p_OBJECT_VERSION_NUMBER := 1;
1711: --END IF;
1712: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1713: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1714: THEN
1715:
1716: IF (g_debug > 0 ) THEN
1734:
1735:
1736: if (l_OBJECT_VERSION_NUMBER <> p_OBJECT_VERSION_NUMBER) then
1737: -- data is not valid
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739:
1740: IF (g_debug > 0 ) THEN
1741: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');
1742: END IF;
1758: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1759: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1760: -- stored in database table.
1761: PROCEDURE Validate_REPJOBXREF_rec(
1762: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1763: P_Validation_mode IN VARCHAR2,
1764: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
1765: X_Return_Status OUT NOCOPY VARCHAR2,
1766: X_Msg_Count OUT NOCOPY NUMBER,
1769: IS
1770: BEGIN
1771:
1772: -- Initialize message list if p_init_msg_list is set to TRUE.
1773: IF FND_API.to_Boolean( p_init_msg_list )
1774: THEN
1775: FND_MSG_PUB.initialize;
1776: END IF;
1777:
1776: END IF;
1777:
1778:
1779: -- Initialize API return status to SUCCESS
1780: x_return_status := FND_API.G_RET_STS_SUCCESS;
1781:
1782: -- Hint: Validate data
1783: -- If data not valid
1784: -- THEN
1781:
1782: -- Hint: Validate data
1783: -- If data not valid
1784: -- THEN
1785: -- x_return_status := FND_API.G_RET_STS_ERROR;
1786:
1787: -- Debug Message
1788: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
1789:
1795:
1796: END Validate_REPJOBXREF_Rec;
1797:
1798: PROCEDURE Validate_repjobxref(
1799: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1800: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1801: P_Validation_mode IN VARCHAR2,
1802: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
1803: X_Return_Status OUT NOCOPY VARCHAR2,
1796: END Validate_REPJOBXREF_Rec;
1797:
1798: PROCEDURE Validate_repjobxref(
1799: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1800: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1801: P_Validation_mode IN VARCHAR2,
1802: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
1803: X_Return_Status OUT NOCOPY VARCHAR2,
1804: X_Msg_Count OUT NOCOPY NUMBER,
1812: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1813:
1814:
1815: -- Initialize API return status to SUCCESS
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;
1817:
1818: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1819: -- Hint: We provide validation procedure for every column. Developer should delete
1820: -- unnecessary validation procedures.
1818: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1819: -- Hint: We provide validation procedure for every column. Developer should delete
1820: -- unnecessary validation procedures.
1821: Validate_REPAIR_JOB_XREF_ID(
1822: p_init_msg_list => FND_API.G_FALSE,
1823: p_validation_mode => p_validation_mode,
1824: p_REPAIR_JOB_XREF_ID => P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID,
1825: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1826: x_return_status => x_return_status,
1825: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1826: x_return_status => x_return_status,
1827: x_msg_count => x_msg_count,
1828: x_msg_data => x_msg_data);
1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: raise FND_API.G_EXC_ERROR;
1831: END IF;
1832:
1833: Validate_REPAIR_LINE_ID(
1826: x_return_status => x_return_status,
1827: x_msg_count => x_msg_count,
1828: x_msg_data => x_msg_data);
1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: raise FND_API.G_EXC_ERROR;
1831: END IF;
1832:
1833: Validate_REPAIR_LINE_ID(
1834: p_init_msg_list => FND_API.G_FALSE,
1830: raise FND_API.G_EXC_ERROR;
1831: END IF;
1832:
1833: Validate_REPAIR_LINE_ID(
1834: p_init_msg_list => FND_API.G_FALSE,
1835: p_validation_mode => p_validation_mode,
1836: p_REPAIR_LINE_ID => P_REPJOBXREF_Rec.REPAIR_LINE_ID,
1837: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1838: x_return_status => x_return_status,
1837: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,
1840: x_msg_data => x_msg_data);
1841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1842: raise FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845: Validate_WIP_ENTITY_ID(
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,
1840: x_msg_data => x_msg_data);
1841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1842: raise FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845: Validate_WIP_ENTITY_ID(
1846: p_init_msg_list => FND_API.G_FALSE,
1842: raise FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845: Validate_WIP_ENTITY_ID(
1846: p_init_msg_list => FND_API.G_FALSE,
1847: p_validation_mode => p_validation_mode,
1848: p_WIP_ENTITY_ID => P_REPJOBXREF_Rec.WIP_ENTITY_ID,
1849: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1850: x_return_status => x_return_status,
1849: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1850: x_return_status => x_return_status,
1851: x_msg_count => x_msg_count,
1852: x_msg_data => x_msg_data);
1853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1854: raise FND_API.G_EXC_ERROR;
1855: END IF;
1856:
1857: Validate_GROUP_ID(
1850: x_return_status => x_return_status,
1851: x_msg_count => x_msg_count,
1852: x_msg_data => x_msg_data);
1853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1854: raise FND_API.G_EXC_ERROR;
1855: END IF;
1856:
1857: Validate_GROUP_ID(
1858: p_init_msg_list => FND_API.G_FALSE,
1854: raise FND_API.G_EXC_ERROR;
1855: END IF;
1856:
1857: Validate_GROUP_ID(
1858: p_init_msg_list => FND_API.G_FALSE,
1859: p_validation_mode => p_validation_mode,
1860: p_GROUP_ID => P_REPJOBXREF_Rec.GROUP_ID,
1861: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1862: x_return_status => x_return_status,
1861: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1862: x_return_status => x_return_status,
1863: x_msg_count => x_msg_count,
1864: x_msg_data => x_msg_data);
1865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1866: raise FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: Validate_ORGANIZATION_ID(
1862: x_return_status => x_return_status,
1863: x_msg_count => x_msg_count,
1864: x_msg_data => x_msg_data);
1865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1866: raise FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: Validate_ORGANIZATION_ID(
1870: p_init_msg_list => FND_API.G_FALSE,
1866: raise FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: Validate_ORGANIZATION_ID(
1870: p_init_msg_list => FND_API.G_FALSE,
1871: p_validation_mode => p_validation_mode,
1872: p_ORGANIZATION_ID => P_REPJOBXREF_Rec.ORGANIZATION_ID,
1873: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1874: x_return_status => x_return_status,
1873: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1874: x_return_status => x_return_status,
1875: x_msg_count => x_msg_count,
1876: x_msg_data => x_msg_data);
1877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1878: raise FND_API.G_EXC_ERROR;
1879: END IF;
1880:
1881: Validate_QUANTITY(
1874: x_return_status => x_return_status,
1875: x_msg_count => x_msg_count,
1876: x_msg_data => x_msg_data);
1877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1878: raise FND_API.G_EXC_ERROR;
1879: END IF;
1880:
1881: Validate_QUANTITY(
1882: p_init_msg_list => FND_API.G_FALSE,
1878: raise FND_API.G_EXC_ERROR;
1879: END IF;
1880:
1881: Validate_QUANTITY(
1882: p_init_msg_list => FND_API.G_FALSE,
1883: p_validation_mode => p_validation_mode,
1884: p_QUANTITY => P_REPJOBXREF_Rec.QUANTITY,
1885: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1886: x_return_status => x_return_status,
1885: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1886: x_return_status => x_return_status,
1887: x_msg_count => x_msg_count,
1888: x_msg_data => x_msg_data);
1889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1890: raise FND_API.G_EXC_ERROR;
1891: END IF;
1892:
1893: END IF;
1886: x_return_status => x_return_status,
1887: x_msg_count => x_msg_count,
1888: x_msg_data => x_msg_data);
1889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1890: raise FND_API.G_EXC_ERROR;
1891: END IF;
1892:
1893: END IF;
1894:
1893: END IF;
1894:
1895: -- travi OBJECT_VERSION_NUMBER validation
1896: Validate_OBJECT_VERSION_NUMBER(
1897: p_init_msg_list => FND_API.G_FALSE,
1898: p_validation_mode => p_validation_mode,
1899: p_OBJECT_VERSION_NUMBER => P_REPJOBXREF_Rec.OBJECT_VERSION_NUMBER,
1900: p_REPAIR_JOB_XREF_ID => P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID,
1901: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1901: -- Hint: You may add x_item_property_rec as one of your out parameter if you'd like to pass back item property.
1902: x_return_status => x_return_status,
1903: x_msg_count => x_msg_count,
1904: x_msg_data => x_msg_data);
1905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1906: raise FND_API.G_EXC_ERROR;
1907: END IF;
1908:
1909: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1902: x_return_status => x_return_status,
1903: x_msg_count => x_msg_count,
1904: x_msg_data => x_msg_data);
1905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1906: raise FND_API.G_EXC_ERROR;
1907: END IF;
1908:
1909: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1910: -- Hint: Inter-field level validation can be added here
1909: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1910: -- Hint: Inter-field level validation can be added here
1911: -- invoke record level validation procedures
1912: Validate_REPJOBXREF_Rec(
1913: p_init_msg_list => FND_API.G_FALSE,
1914: p_validation_mode => p_validation_mode,
1915: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
1916: x_return_status => x_return_status,
1917: x_msg_count => x_msg_count,
1916: x_return_status => x_return_status,
1917: x_msg_count => x_msg_count,
1918: x_msg_data => x_msg_data);
1919:
1920: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1921: raise FND_API.G_EXC_ERROR;
1922: END IF;
1923: END IF;
1924:
1917: x_msg_count => x_msg_count,
1918: x_msg_data => x_msg_data);
1919:
1920: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1921: raise FND_API.G_EXC_ERROR;
1922: END IF;
1923: END IF;
1924:
1925: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN