[Home] [Help]
PACKAGE BODY: APPS.CSC_GROUP_CHECKS_PVT
Source
1 PACKAGE BODY CSC_GROUP_CHECKS_PVT as
2 /* $Header: cscvpgcb.pls 120.1 2005/08/03 23:01:50 mmadhavi noship $ */
3 -- Start of Comments
4 -- Package name : CSC_GROUP_CHECKS_PVT
5 -- Purpose :
6 -- History :
7 -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
8 -- NOTE :
9 -- End of Comments
10
11
12 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_GROUP_CHECKS_PVT';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvugcb.pls';
14
15 PROCEDURE Convert_Columns_to_Rec(
16 P_GROUP_ID IN NUMBER ,
17 P_CHECK_ID IN NUMBER ,
18 P_CHECK_SEQUENCE IN NUMBER ,
19 P_END_DATE_ACTIVE IN DATE ,
20 P_START_DATE_ACTIVE IN DATE ,
21 P_CATEGORY_CODE IN VARCHAR2,
22 P_CATEGORY_SEQUENCE IN NUMBER ,
23 P_THRESHOLD_FLAG IN VARCHAR2,
24 P_CRITICAL_FLAG IN VARCHAR2,
25 P_SEEDED_FLAG IN VARCHAR2,
26 P_CREATED_BY IN NUMBER,
27 P_CREATION_DATE IN DATE ,
28 P_LAST_UPDATED_BY IN NUMBER,
29 P_LAST_UPDATE_DATE IN DATE ,
30 P_LAST_UPDATE_LOGIN IN NUMBER,
31 X_GROUP_CHK_Rec OUT NOCOPY GROUP_CHK_Rec_Type
32 )
33 IS
34 BEGIN
35 X_GROUP_CHK_Rec.GROUP_ID := P_GROUP_ID;
36 X_GROUP_CHK_Rec.CHECK_ID := P_CHECK_ID;
37 X_GROUP_CHK_Rec.CHECK_SEQUENCE := P_CHECK_SEQUENCE;
38 X_GROUP_CHK_Rec.END_DATE_ACTIVE := P_END_DATE_ACTIVE;
39 X_GROUP_CHK_Rec.START_DATE_ACTIVE := P_START_DATE_ACTIVE;
40 X_GROUP_CHK_Rec.CATEGORY_CODE := P_CATEGORY_CODE;
41 X_GROUP_CHK_Rec.CATEGORY_SEQUENCE := P_CATEGORY_SEQUENCE;
42 X_GROUP_CHK_Rec.THRESHOLD_FLAG := P_THRESHOLD_FLAG;
43 X_GROUP_CHK_Rec.CRITICAL_FLAG := P_CRITICAL_FLAG;
44 X_GROUP_CHK_Rec.SEEDED_FLAG := P_SEEDED_FLAG;
45 X_GROUP_CHK_Rec.CREATED_BY := P_CREATED_BY;
46 X_GROUP_CHK_Rec.CREATION_DATE := P_CREATION_DATE;
47 X_GROUP_CHK_Rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;
48 X_GROUP_CHK_Rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;
49 X_GROUP_CHK_Rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;
50 END Convert_Columns_to_Rec;
51
52
53 PROCEDURE Create_group_checks(
54 P_Api_Version_Number IN NUMBER,
55 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
56 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
57 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
58 P_GROUP_ID IN NUMBER ,
59 P_CHECK_ID IN NUMBER ,
60 P_END_DATE_ACTIVE IN DATE ,
61 P_START_DATE_ACTIVE IN DATE ,
62 P_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL ,
63 P_CATEGORY_SEQUENCE IN NUMBER DEFAULT NULL,
64 P_THRESHOLD_FLAG IN VARCHAR2 ,
65 P_CRITICAL_FLAG IN VARCHAR2 ,
66 P_SEEDED_FLAG IN VARCHAR2 ,
67 P_CREATED_BY IN NUMBER ,
68 P_CREATION_DATE IN DATE ,
69 P_LAST_UPDATED_BY IN NUMBER,
70 P_LAST_UPDATE_DATE IN DATE,
71 P_LAST_UPDATE_LOGIN IN NUMBER ,
72 P_Check_Sequence IN NUMBER ,
73 X_Return_Status OUT NOCOPY VARCHAR2,
74 X_Msg_Count OUT NOCOPY NUMBER,
75 X_Msg_Data OUT NOCOPY VARCHAR2
76 )
77 IS
78 l_group_Chk_Rec Group_chk_Rec_Type;
79 BEGIN
80 Convert_Columns_to_Rec(
81 P_GROUP_ID => P_GROUP_ID,
82 P_CHECK_ID => P_CHECK_ID,
83 P_CHECK_SEQUENCE => P_CHECK_SEQUENCE,
84 P_END_DATE_ACTIVE => P_END_DATE_ACTIVE,
85 P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
86 P_CATEGORY_CODE => P_CATEGORY_CODE,
87 P_CATEGORY_SEQUENCE => P_CATEGORY_SEQUENCE,
88 P_THRESHOLD_FLAG => P_THRESHOLD_FLAG,
89 P_CRITICAL_FLAG => P_CRITICAL_FLAG,
90 P_SEEDED_FLAG => P_SEEDED_FLAG,
91 P_CREATED_BY => P_CREATED_BY,
92 P_CREATION_DATE => P_CREATION_DATE,
93 P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
94 P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
95 P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
96 X_GROUP_CHK_Rec => l_GROUP_CHK_Rec
97 );
98 Create_group_checks(
99 P_Api_Version_Number => P_Api_Version_Number,
100 P_Init_Msg_List => p_Init_Msg_List,
101 P_Commit => p_Commit,
102 P_Validation_Level => p_validation_level,
103 P_GROUP_CHK_Rec => l_Group_Chk_Rec,
104 --X_Check_Sequence => p_Check_Sequence,
105 X_Return_Status => x_return_status,
106 X_Msg_Count => x_msg_count,
107 X_Msg_Data => x_msg_data);
108
109
110 END Create_group_checks;
111
112
113 PROCEDURE Create_group_checks(
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119 -- X_Check_Sequence OUT NOCOPY NUMBER,
120 X_Return_Status OUT NOCOPY VARCHAR2,
121 X_Msg_Count OUT NOCOPY NUMBER,
122 X_Msg_Data OUT NOCOPY VARCHAR2
123 )
124 IS
125 l_api_name CONSTANT VARCHAR2(30) := 'Create_group_checks';
126 l_api_version_number CONSTANT NUMBER := 1.0;
127 l_return_status_full VARCHAR2(1);
128 BEGIN
129 -- Standard Start of API savepoint
130 SAVEPOINT CREATE_GROUP_CHECKS_PVT;
131
132 -- Standard call to check for call compatibility.
133 IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
134 p_api_version_number,
135 l_api_name,
136 G_PKG_NAME)
137 THEN
138 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139 END IF;
140
141
142 -- Initialize message list if p_init_msg_list is set to TRUE.
143 IF FND_API.to_Boolean( p_init_msg_list )
144 THEN
145 FND_MSG_PUB.initialize;
146 END IF;
147
148
149 -- Initialize API return status to SUCCESS
150 x_return_status := FND_API.G_RET_STS_SUCCESS;
151
152 --
153 -- API body
154 --
155
156 IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
157 THEN
158
159 -- Invoke validation procedures
160 Validate_group_checks(
161 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
162 p_validation_level => p_validation_level,
163 p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
164 P_GROUP_CHK_Rec => P_GROUP_CHK_Rec,
165 x_return_status => x_return_status,
166 x_msg_count => x_msg_count,
167 x_msg_data => x_msg_data);
168 END IF;
169
170 IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
171 RAISE FND_API.G_EXC_ERROR;
172 END IF;
173
174
175 -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Insert_Row)
176 CSC_PROF_GROUP_CHECKS_PKG.Insert_Row(
177 p_GROUP_ID => p_GROUP_CHK_rec.GROUP_ID,
178 p_CHECK_ID => p_GROUP_CHK_rec.CHECK_ID,
179 P_CHECK_SEQUENCE => p_GROUP_CHK_rec.CHECK_SEQUENCE,
180 p_END_DATE_ACTIVE => p_GROUP_CHK_rec.END_DATE_ACTIVE,
181 p_START_DATE_ACTIVE => p_GROUP_CHK_rec.START_DATE_ACTIVE,
182 p_CATEGORY_CODE => p_GROUP_CHK_rec.CATEGORY_CODE,
183 p_CATEGORY_SEQUENCE => p_GROUP_CHK_rec.CATEGORY_SEQUENCE,
184 p_THRESHOLD_FLAG => p_GROUP_CHK_rec.THRESHOLD_FLAG,
185 p_CRITICAL_FLAG => p_GROUP_CHK_rec.CRITICAL_FLAG,
186 p_SEEDED_FLAG => p_GROUP_CHK_rec.SEEDED_FLAG,
187 p_CREATED_BY => FND_GLOBAL.USER_ID,
188 p_CREATION_DATE => SYSDATE,
189 p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
190 p_LAST_UPDATE_DATE => SYSDATE,
191 p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
192
193 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
194 RAISE FND_API.G_EXC_ERROR;
195 END IF;
196
197 --
198 -- End of API body
199 --
200
201 -- Standard check for p_commit
202 IF FND_API.to_Boolean( p_commit )
203 THEN
204 COMMIT WORK;
205 END IF;
206
207 -- Standard call to get message count and if count is 1, get message info.
208 FND_MSG_PUB.Count_And_Get
209 ( p_count => x_msg_count,
210 p_data => x_msg_data
211 );
212
213 EXCEPTION
214 WHEN FND_API.G_EXC_ERROR THEN
215 ROLLBACK TO Create_group_checks_PVT;
216 x_return_status := FND_API.G_RET_STS_ERROR;
217 FND_MSG_PUB.Count_And_Get
218 ( p_count => x_msg_count,
219 p_data => x_msg_data
220 );
221 APP_EXCEPTION.RAISE_EXCEPTION;
222 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223 ROLLBACK TO Create_group_checks_PVT;
224 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225 FND_MSG_PUB.Count_And_Get
226 ( p_count => x_msg_count,
227 p_data => x_msg_data
228 );
229 APP_EXCEPTION.RAISE_EXCEPTION;
230 WHEN OTHERS THEN
231 ROLLBACK TO Create_group_checks_PVT;
232 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
234 FND_MSG_PUB.Count_And_Get
235 ( p_count => x_msg_count,
236 p_data => x_msg_data
237 );
238 APP_EXCEPTION.RAISE_EXCEPTION;
239 End Create_group_checks;
240
241
242 PROCEDURE Update_group_checks(
243 P_Api_Version_Number IN NUMBER,
244 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
245 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247 P_GROUP_ID IN NUMBER ,
248 P_CHECK_ID IN NUMBER ,
249 P_CHECK_SEQUENCE IN NUMBER ,
250 P_END_DATE_ACTIVE IN DATE ,
251 P_START_DATE_ACTIVE IN DATE ,
252 P_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL,
253 P_CATEGORY_SEQUENCE IN NUMBER DEFAULT NULL ,
254 P_THRESHOLD_FLAG IN VARCHAR2,
255 P_CRITICAL_FLAG IN VARCHAR2,
256 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
257 P_CREATED_BY IN NUMBER DEFAULT NULL,
258 P_CREATION_DATE IN DATE DEFAULT NULL,
259 P_LAST_UPDATED_BY IN NUMBER,
260 P_LAST_UPDATE_DATE IN DATE,
261 P_LAST_UPDATE_LOGIN IN NUMBER,
262 X_Return_Status OUT NOCOPY VARCHAR2,
263 X_Msg_Count OUT NOCOPY NUMBER,
264 X_Msg_Data OUT NOCOPY VARCHAR2
265 )
266 IS
267 l_GROUP_CHK_REC GROUP_CHK_REC_TYPE;
268 BEGIN
269
270 Convert_Columns_to_Rec(
271 P_GROUP_ID => P_GROUP_ID,
272 P_CHECK_ID => P_CHECK_ID,
273 P_CHECK_SEQUENCE => P_CHECK_SEQUENCE,
274 P_END_DATE_ACTIVE => P_END_DATE_ACTIVE,
275 P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
276 P_CATEGORY_CODE => P_CATEGORY_CODE,
277 P_CATEGORY_SEQUENCE => P_CATEGORY_SEQUENCE,
278 P_THRESHOLD_FLAG => P_THRESHOLD_FLAG,
279 P_CRITICAL_FLAG => P_CRITICAL_FLAG,
280 P_SEEDED_FLAG => P_SEEDED_FLAG,
281 P_CREATED_BY => P_CREATED_BY,
282 P_CREATION_DATE => P_CREATION_DATE,
283 P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
284 P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
285 P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
286 X_GROUP_CHK_Rec => l_GROUP_CHK_Rec
287 );
288 Update_group_checks(
289 P_Api_Version_Number => P_Api_Version_Number,
290 P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
291 P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
292 P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
293 P_GROUP_CHK_Rec => l_Group_Chk_Rec,
294 X_Return_Status => x_return_status,
295 X_Msg_Count => x_msg_count,
296 X_Msg_Data => x_msg_data);
297
298
299 END Update_group_checks;
300
301
302
303
304 PROCEDURE Update_group_checks(
305 P_Api_Version_Number IN NUMBER,
306 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
308 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
309 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
310 X_Return_Status OUT NOCOPY VARCHAR2,
311 X_Msg_Count OUT NOCOPY NUMBER,
312 X_Msg_Data OUT NOCOPY VARCHAR2
313 )
314
315 IS
316
317 Cursor C_Get_group_checks(c_GROUP_ID Number, C_CHECK_ID NUMBER) IS
318 Select rowid,
319 GROUP_ID,
320 CHECK_ID,
321 CHECK_SEQUENCE,
322 END_DATE_ACTIVE,
323 START_DATE_ACTIVE,
324 CATEGORY_CODE,
325 CATEGORY_SEQUENCE,
326 THRESHOLD_FLAG,
327 CRITICAL_FLAG,
328 SEEDED_FLAG,
329 CREATED_BY,
330 CREATION_DATE,
331 LAST_UPDATED_BY,
332 LAST_UPDATE_DATE,
333 LAST_UPDATE_LOGIN
334 From CSC_PROF_GROUP_CHECKS
335 Where GROUP_ID = c_GROUP_ID
336 And CHECK_ID = c_CHECK_ID
337 For Update NOWAIT;
338
339 l_api_name CONSTANT VARCHAR2(30) := 'Update_group_checks';
340 l_api_version_number CONSTANT NUMBER := 1.0;
341 -- Local Variables
342 l_old_GROUP_CHK_rec CSC_group_checks_PVT.GROUP_CHK_Rec_Type ;
343 l_rowid ROWID;
344 BEGIN
345 -- Standard Start of API savepoint
346 SAVEPOINT UPDATE_GROUP_CHECKS_PVT;
347
348 -- Standard call to check for call compatibility.
349 IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
350 p_api_version_number,
351 l_api_name,
352 G_PKG_NAME)
353 THEN
354 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355 END IF;
356
357
358 -- Initialize message list if p_init_msg_list is set to TRUE.
359 IF FND_API.to_Boolean( p_init_msg_list )
360 THEN
361 FND_MSG_PUB.initialize;
362 END IF;
363
364
365
366 -- Initialize API return status to SUCCESS
367 x_return_status := FND_API.G_RET_STS_SUCCESS;
368
369 --
370 -- Api body
371 --
372
373 Open C_Get_group_checks( p_group_chk_rec.GROUP_ID, p_group_chk_rec.CHECK_ID);
374
375 Fetch C_Get_group_checks into
376 l_rowid,
377 l_old_GROUP_CHK_rec.GROUP_ID,
378 l_old_GROUP_CHK_rec.CHECK_ID,
379 l_old_GROUP_CHK_rec.CHECK_SEQUENCE,
380 l_old_GROUP_CHK_rec.END_DATE_ACTIVE,
381 l_old_GROUP_CHK_rec.START_DATE_ACTIVE,
382 l_old_GROUP_CHK_rec.CATEGORY_CODE,
383 l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE,
384 l_old_GROUP_CHK_rec.THRESHOLD_FLAG,
385 l_old_GROUP_CHK_rec.CRITICAL_FLAG,
386 l_old_GROUP_CHK_rec.SEEDED_FLAG,
387 l_old_GROUP_CHK_rec.CREATED_BY,
388 l_old_GROUP_CHK_rec.CREATION_DATE,
389 l_old_GROUP_CHK_rec.LAST_UPDATED_BY,
390 l_old_GROUP_CHK_rec.LAST_UPDATE_DATE,
391 l_old_GROUP_CHK_rec.LAST_UPDATE_LOGIN;
392
393 If ( C_Get_group_checks%NOTFOUND) Then
394 IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
395 THEN
396 CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_api_name=>l_api_name);
397 --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
398 --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUP_CHECKS', FALSE);
399 --FND_MSG_PUB.Add;
400 END IF;
401 raise FND_API.G_EXC_ERROR;
402 END IF;
403
404 IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
405 THEN
406
407 -- Invoke validation procedures
408 Validate_group_checks(
409 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
410 p_validation_level => p_validation_level,
411 p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
412 P_GROUP_CHK_Rec => P_GROUP_CHK_rec,
413 x_return_status => x_return_status,
414 x_msg_count => x_msg_count,
415 x_msg_data => x_msg_data);
416 END IF;
417
418 IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
419 RAISE FND_API.G_EXC_ERROR;
420 END IF;
421 -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422 CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423 p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424 p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425 p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426 p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427 p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428 p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429 p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430 p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431 p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
432 p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),
433 p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
434 p_LAST_UPDATE_DATE => SYSDATE,
435 p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
436
437 --
438 -- End of API body.
439 --
440
441 -- Standard check for p_commit
442 IF FND_API.to_Boolean( p_commit )
443 THEN
444 COMMIT WORK;
445 END IF;
446
447
448 -- Standard call to get message count and if count is 1, get message info.
449 FND_MSG_PUB.Count_And_Get
450 ( p_count => x_msg_count,
451 p_data => x_msg_data
452 );
453
454 EXCEPTION
455 WHEN FND_API.G_EXC_ERROR THEN
456 ROLLBACK TO Update_group_checks_PVT;
457 x_return_status := FND_API.G_RET_STS_ERROR;
458 FND_MSG_PUB.Count_And_Get
459 ( p_count => x_msg_count,
460 p_data => x_msg_data
461 );
462 APP_EXCEPTION.RAISE_EXCEPTION;
463 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464 ROLLBACK TO Update_group_checks_PVT;
465 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466 FND_MSG_PUB.Count_And_Get
467 ( p_count => x_msg_count,
468 p_data => x_msg_data
469 );
470 APP_EXCEPTION.RAISE_EXCEPTION;
471 WHEN OTHERS THEN
472 ROLLBACK TO Update_group_checks_PVT;
473 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
475 FND_MSG_PUB.Count_And_Get
476 ( p_count => x_msg_count,
477 p_data => x_msg_data
478 );
479 APP_EXCEPTION.RAISE_EXCEPTION;
480 End Update_group_checks;
481
482
483 PROCEDURE Delete_group_checks(
484 P_Api_Version_Number IN NUMBER,
485 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
486 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
487 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
488 P_GROUP_ID IN NUMBER,
489 P_CHECK_ID IN NUMBER,
490 P_CHECK_SEQUENCE IN NUMBER,
491 X_Return_Status OUT NOCOPY VARCHAR2,
492 X_Msg_Count OUT NOCOPY NUMBER,
493 X_Msg_Data OUT NOCOPY VARCHAR2
494 )
495 IS
496 l_api_name CONSTANT VARCHAR2(30) := 'Delete_group_checks';
497 l_api_version_number CONSTANT NUMBER := 1.0;
498 BEGIN
499 -- Standard Start of API savepoint
500 SAVEPOINT DELETE_GROUP_CHECKS_PVT;
501
502 -- Standard call to check for call compatibility.
503 IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
504 p_api_version_number,
505 l_api_name,
506 G_PKG_NAME)
507 THEN
508 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509 END IF;
510
511
512 -- Initialize message list if p_init_msg_list is set to TRUE.
513 IF FND_API.to_Boolean( p_init_msg_list )
514 THEN
515 FND_MSG_PUB.initialize;
516 END IF;
517
518
519
520 -- Initialize API return status to SUCCESS
521 x_return_status := FND_API.G_RET_STS_SUCCESS;
522
523 --
524 -- Api body
525 --
526
527 -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Delete_Row)
528 CSC_PROF_GROUP_CHECKS_PKG.Delete_Row(
529 p_GROUP_ID => p_GROUP_ID,
530 P_CHECK_ID => P_CHECK_ID,
531 p_CHECK_SEQUENCE => p_CHECK_SEQUENCE );
532 --
533 -- End of API body
534 --
535
536 -- Standard check for p_commit
537 IF FND_API.to_Boolean( p_commit )
538 THEN
539 COMMIT WORK;
540 END IF;
541
542
543
544 -- Standard call to get message count and if count is 1, get message info.
545 FND_MSG_PUB.Count_And_Get
546 ( p_count => x_msg_count,
547 p_data => x_msg_data
548 );
549
550 EXCEPTION
551 WHEN FND_API.G_EXC_ERROR THEN
552 ROLLBACK TO Delete_group_checks_PVT;
553 x_return_status := FND_API.G_RET_STS_ERROR;
554 FND_MSG_PUB.Count_And_Get
555 ( p_count => x_msg_count,
556 p_data => x_msg_data
557 );
558 APP_EXCEPTION.RAISE_EXCEPTION;
559 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560 ROLLBACK TO Delete_group_checks_PVT;
561 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562 FND_MSG_PUB.Count_And_Get
563 ( p_count => x_msg_count,
564 p_data => x_msg_data
565 );
566 APP_EXCEPTION.RAISE_EXCEPTION;
567 WHEN OTHERS THEN
568 ROLLBACK TO Delete_group_checks_PVT;
569 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570 FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
571 FND_MSG_PUB.Count_And_Get
572 ( p_count => x_msg_count,
573 p_data => x_msg_data
574 );
575 APP_EXCEPTION.RAISE_EXCEPTION;
576 End Delete_group_checks;
577
578
579 -- Item-level validation procedures
580 PROCEDURE Validate_GROUP_ID (
581 P_Api_Name IN VARCHAR2,
582 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
583 P_Validation_mode IN VARCHAR2,
584 P_GROUP_ID IN NUMBER,
585 X_Return_Status OUT NOCOPY VARCHAR2,
586 X_Msg_Count OUT NOCOPY NUMBER,
587 X_Msg_Data OUT NOCOPY VARCHAR2
588 )
589 IS
590 CURSOR C1 IS SELECT NULL
591 FROM csc_prof_groups_b
592 WHERE group_id = p_GROUP_ID;
593 l_dummy number;
594 BEGIN
595
596 -- Initialize message list if p_init_msg_list is set to TRUE.
597 IF FND_API.to_Boolean( p_init_msg_list )
598 THEN
599 FND_MSG_PUB.initialize;
600 END IF;
601
602
603 -- Initialize API return status to SUCCESS
604 x_return_status := FND_API.G_RET_STS_SUCCESS;
605
606 -- validate NOT NULL column
607 IF(p_GROUP_ID is NULL)
608 THEN
609 x_return_status := FND_API.G_RET_STS_ERROR;
610 CSC_CORE_UTILS_PVT.mandatory_arg_error(
611 p_api_name => p_api_name,
612 p_argument => 'p_GROUP_ID',
613 p_argument_value => p_GROUP_ID);
614 END IF;
615 IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
616 THEN
617 -- Hint: Validate data
618 -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
619 -- verify if data is valid
620 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
621 IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
622 THEN
623 Open C1;
624 Fetch C1 into l_dummy;
625 IF C1%NOTFOUND THEN
626 x_return_status := FND_API.G_RET_STS_ERROR;
627 CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
628 p_api_name => p_api_name,
629 p_argument_value => p_GROUP_ID,
630 p_argument => p_GROUP_ID);
631 END IF;
632 Close C1;
633 END IF;
634 ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
635 THEN
636 -- Hint: Validate data
637 -- IF p_GROUP_ID <> G_MISS_CHAR
638 -- verify if data is valid
639 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
640 IF p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
641 Open C1;
642 Fetch C1 into l_dummy;
643 IF C1%NOTFOUND THEN
644 x_return_status := FND_API.G_RET_STS_ERROR;
645 CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
646 p_api_name => p_api_name,
647 p_argument_value => p_GROUP_ID,
648 p_argument => p_GROUP_ID);
649 END IF;
650 Close C1;
651 END IF;
652 END IF;
653
654 -- Standard call to get message count and if count is 1, get message info.
655 FND_MSG_PUB.Count_And_Get
656 ( p_count => x_msg_count,
657 p_data => x_msg_data
658 );
659
660 END Validate_GROUP_ID;
661
662
663 PROCEDURE Validate_CHECK_ID (
664 P_Api_Name IN VARCHAR2,
665 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
666 P_Validation_mode IN VARCHAR2,
667 P_CHECK_ID IN NUMBER,
668 X_Return_Status OUT NOCOPY VARCHAR2,
669 X_Msg_Count OUT NOCOPY NUMBER,
670 X_Msg_Data OUT NOCOPY VARCHAR2
671 )
672 IS
673 CURSOR C1 IS SELECT NULL
674 FROM csc_prof_checks_b
675 WHERE check_id = p_CHECK_ID;
676 l_dummy number;
677 BEGIN
678
679 -- Initialize message list if p_init_msg_list is set to TRUE.
680 IF FND_API.to_Boolean( p_init_msg_list )
681 THEN
682 FND_MSG_PUB.initialize;
683 END IF;
684
685
686 -- Initialize API return status to SUCCESS
687 x_return_status := FND_API.G_RET_STS_SUCCESS;
688
689 -- validate NOT NULL column
690 IF(p_CHECK_ID is NULL)
691 THEN
692 x_return_status := FND_API.G_RET_STS_ERROR;
693 CSC_CORE_UTILS_PVT.mandatory_arg_error(
694 p_api_name => p_api_name,
695 p_argument => 'p_CHECK_ID',
696 p_argument_value => p_CHECK_ID);
697 END IF;
698
699 IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
700 THEN
701 -- Hint: Validate data
702 -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
703 -- verify if data is valid
704 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
705 IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
706 THEN
707 Open C1;
708 Fetch C1 into l_dummy;
709 IF C1%NOTFOUND THEN
710 x_return_status := FND_API.G_RET_STS_ERROR;
711 CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
712 p_api_name => p_api_name,
713 p_argument_value => p_CHECK_ID,
714 p_argument => p_CHECK_ID);
715 END IF;
716 Close C1;
717 END IF;
718 ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
719 THEN
720 -- Hint: Validate data
721 -- IF p_CHECK_ID <> G_MISS_CHAR
722 -- verify if data is valid
723 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
724 IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
725 THEN
726 Open C1;
727 Fetch C1 into l_dummy;
728 IF C1%NOTFOUND THEN
729 x_return_status := FND_API.G_RET_STS_ERROR;
730 CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
731 p_api_name => p_api_name,
732 p_argument_value => p_CHECK_ID,
733 p_argument => p_CHECK_ID);
734 END IF;
735 Close C1;
736 END IF;
737 END IF;
738
739 -- Standard call to get message count and if count is 1, get message info.
740 FND_MSG_PUB.Count_And_Get
741 ( p_count => x_msg_count,
742 p_data => x_msg_data
743 );
744
745 END Validate_CHECK_ID;
746
747
748 PROCEDURE Validate_CHECK_SEQUENCE (
749 P_Api_Name IN VARCHAR2,
750 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
751 P_Validation_mode IN VARCHAR2,
752 P_CHECK_SEQUENCE IN NUMBER,
753 X_Return_Status OUT NOCOPY VARCHAR2,
754 X_Msg_Count OUT NOCOPY NUMBER,
755 X_Msg_Data OUT NOCOPY VARCHAR2
756 )
757 IS
758 BEGIN
759
760 -- Initialize message list if p_init_msg_list is set to TRUE.
761 IF FND_API.to_Boolean( p_init_msg_list )
762 THEN
763 FND_MSG_PUB.initialize;
764 END IF;
765
766
767 -- Initialize API return status to SUCCESS
768 x_return_status := FND_API.G_RET_STS_SUCCESS;
769
770 -- validate NOT NULL column
771 IF(p_CHECK_SEQUENCE is NULL)
772 THEN
773 x_return_status := FND_API.G_RET_STS_ERROR;
774 CSC_CORE_UTILS_PVT.mandatory_arg_error(
775 p_api_name => p_api_name,
776 p_argument => 'p_CHECK_SEQUENCE',
777 p_argument_value => p_CHECK_SEQUENCE);
778 END IF;
779
780 IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
781 THEN
782 -- Hint: Validate data
783 -- IF p_CHECK_SEQUENCE is not NULL and p_CHECK_SEQUENCE <> G_MISS_CHAR
784 -- verify if data is valid
785 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
786 NULL;
787 ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
788 THEN
789 -- Hint: Validate data
790 -- IF p_CHECK_SEQUENCE <> G_MISS_CHAR
791 -- verify if data is valid
792 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
793 NULL;
794 END IF;
795
796 -- Standard call to get message count and if count is 1, get message info.
797 FND_MSG_PUB.Count_And_Get
798 ( p_count => x_msg_count,
799 p_data => x_msg_data
800 );
801
802 END Validate_CHECK_SEQUENCE;
803
804
805
806 PROCEDURE Validate_CATEGORY_CODE (
807 P_Api_Name IN VARCHAR2,
808 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
809 P_Validation_mode IN VARCHAR2,
810 P_CATEGORY_CODE IN VARCHAR2,
811 X_Return_Status OUT NOCOPY VARCHAR2,
812 X_Msg_Count OUT NOCOPY NUMBER,
813 X_Msg_Data OUT NOCOPY VARCHAR2
814 )
815 IS
816 BEGIN
817
818 -- Initialize message list if p_init_msg_list is set to TRUE.
819 IF FND_API.to_Boolean( p_init_msg_list )
820 THEN
821 FND_MSG_PUB.initialize;
822 END IF;
823
824
825 -- Initialize API return status to SUCCESS
826 x_return_status := FND_API.G_RET_STS_SUCCESS;
827
828 NULL;
829
830 -- Standard call to get message count and if count is 1, get message info.
831 FND_MSG_PUB.Count_And_Get
832 ( p_count => x_msg_count,
833 p_data => x_msg_data
834 );
835
836 END Validate_CATEGORY_CODE;
837
838
839 PROCEDURE Validate_CATEGORY_SEQUENCE (
840 P_Api_Name IN VARCHAR2,
841 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
842 P_Validation_mode IN VARCHAR2,
843 P_CHECK_ID IN NUMBER,
844 P_CATEGORY_SEQUENCE IN NUMBER,
845 X_Return_Status OUT NOCOPY VARCHAR2,
846 X_Msg_Count OUT NOCOPY NUMBER,
847 X_Msg_Data OUT NOCOPY VARCHAR2
848 )
849 IS
850 CURSOR C1 IS SELECT NULL
851 FROM csc_prof_group_Checks
852 WHERE check_id = p_CHECK_ID
853 AND category_sequence = p_CATEGORY_SEQUENCE;
854 l_dummy number;
855 BEGIN
856
857 -- Initialize message list if p_init_msg_list is set to TRUE.
858 IF FND_API.to_Boolean( p_init_msg_list )
859 THEN
860 FND_MSG_PUB.initialize;
861 END IF;
862
863
864 -- Initialize API return status to SUCCESS
865 x_return_status := FND_API.G_RET_STS_SUCCESS;
866
867 IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
868 THEN
869 -- Hint: Validate data
870 -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
871 -- verify if data is valid
872 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
873 NULL;
874 ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
875 THEN
876 -- Hint: Validate data
877 -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
878 -- verify if data is valid
879 -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
880 IF p_CATEGORY_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
881 Open C1;
882 Fetch C1 into l_dummy;
883 IF C1%FOUND THEN
884 x_return_status := FND_API.G_RET_STS_ERROR;
885 CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
886 p_api_name => p_api_name,
887 p_argument => 'p_CATEGORY_SEQUENCE' ,
888 p_argument_value => p_CATEGORY_SEQUENCE);
889
890 END IF;
891 Close C1;
892 END IF;
893 END IF;
894
895 -- Standard call to get message count and if count is 1, get message info.
896 FND_MSG_PUB.Count_And_Get
897 ( p_count => x_msg_count,
898 p_data => x_msg_data
899 );
900
901 END Validate_CATEGORY_SEQUENCE;
902
903
904 PROCEDURE Validate_THRESHOLD_FLAG (
905 P_Api_Name IN VARCHAR2,
906 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
907 P_Validation_mode IN VARCHAR2,
908 P_THRESHOLD_FLAG IN VARCHAR2,
909 X_Return_Status OUT NOCOPY VARCHAR2,
910 X_Msg_Count OUT NOCOPY NUMBER,
911 X_Msg_Data OUT NOCOPY VARCHAR2
912 )
913 IS
914 BEGIN
915
916 -- Initialize message list if p_init_msg_list is set to TRUE.
917 IF FND_API.to_Boolean( p_init_msg_list )
918 THEN
919 FND_MSG_PUB.initialize;
920 END IF;
921
922
923 -- Initialize API return status to SUCCESS
924 x_return_status := FND_API.G_RET_STS_SUCCESS;
925
926 IF (p_THRESHOLD_FLAG IS NOT NULL) AND
927 (p_THRESHOLD_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
928 THEN
929 IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
930 p_effective_date => trunc(sysdate),
931 p_lookup_type => 'YES_NO',
932 p_lookup_code => p_THRESHOLD_FLAG ) <> FND_API.G_RET_STS_SUCCESS
933 THEN
934 x_return_status := FND_API.G_RET_STS_ERROR;
935 CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
936 p_api_name => p_api_name,
937 p_argument_value => p_THRESHOLD_FLAG,
938 p_argument => 'p_THRESHOLD_FLAG');
939 END IF;
940 END IF;
941
942 -- Standard call to get message count and if count is 1, get message info.
943 FND_MSG_PUB.Count_And_Get
944 ( p_count => x_msg_count,
945 p_data => x_msg_data
946 );
947
948 END Validate_THRESHOLD_FLAG;
949
950
951 PROCEDURE Validate_group_checks(
952 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
953 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
954 P_Validation_mode IN VARCHAR2,
955 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
956 X_Return_Status OUT NOCOPY VARCHAR2,
957 X_Msg_Count OUT NOCOPY NUMBER,
958 X_Msg_Data OUT NOCOPY VARCHAR2
959 )
960 IS
961 p_api_name CONSTANT VARCHAR2(30) := 'Validate_group_checks';
962 BEGIN
963
964
965 -- Initialize API return status to SUCCESS
966 x_return_status := FND_API.G_RET_STS_SUCCESS;
967 Validate_GROUP_ID(
968 p_api_name => p_api_name,
969 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
970 p_validation_mode => p_validation_mode,
971 p_GROUP_ID => P_GROUP_CHK_REC.GROUP_ID,
972 x_return_status => x_return_status,
973 x_msg_count => x_msg_count,
974 x_msg_data => x_msg_data);
975 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
976 raise FND_API.G_EXC_ERROR;
977 END IF;
978 /*
979 Validate_CHECK_ID(
980 p_api_name => p_api_name,
981 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
982 p_validation_mode => p_validation_mode,
983 p_CHECK_ID => P_GROUP_CHK_Rec.CHECK_ID,
984 x_return_status => x_return_status,
985 x_msg_count => x_msg_count,
986 x_msg_data => x_msg_data);
987 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
988 raise FND_API.G_EXC_ERROR;
989 END IF;
990 */
991
992 Validate_CHECK_SEQUENCE(
993 p_api_name => p_api_name,
994 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
995 p_validation_mode => p_validation_mode,
996 -- p_CHECK_ID => P_GROUP_CHK_Rec.CHECK_ID,
997 p_CHECK_SEQUENCE => P_GROUP_CHK_Rec.CHECK_SEQUENCE,
998 x_return_status => x_return_status,
999 x_msg_count => x_msg_count,
1000 x_msg_data => x_msg_data);
1001 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1002 raise FND_API.G_EXC_ERROR;
1003 END IF;
1004
1005 CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1006 p_api_name =>'CSC_PROF_GROUP_CHECKS_PVT.VALIDATE_SEEDED_FLAG',
1007 p_seeded_flag => P_GROUP_CHK_Rec.seeded_flag,
1008 x_return_status => x_return_status );
1009
1010 IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011 RAISE FND_API.G_EXC_ERROR;
1012 END IF;
1013 /*
1014 Validate_CATEGORY_CODE(
1015 p_api_name => p_api_name,
1016 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1017 p_validation_mode => p_validation_mode,
1018 p_CATEGORY_CODE => P_GROUP_CHK_Rec.CATEGORY_CODE,
1019 x_return_status => x_return_status,
1020 x_msg_count => x_msg_count,
1021 x_msg_data => x_msg_data);
1022 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023 raise FND_API.G_EXC_ERROR;
1024 END IF;
1025
1026 CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
1027 p_api_name => p_Api_name,
1028 p_start_date => P_GROUP_CHK_Rec.start_date_active,
1029 p_end_date => P_GROUP_CHK_Rec.end_date_active,
1030 x_return_status => x_return_status );
1031 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032 raise FND_API.G_EXC_ERROR;
1033 END IF;
1034
1035 Validate_CATEGORY_SEQUENCE(
1036 p_api_name => p_api_name,
1037 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1038 p_validation_mode => p_validation_mode,
1039 p_CATEGORY_SEQUENCE => P_GROUP_CHK_Rec.CATEGORY_SEQUENCE,
1040 x_return_status => x_return_status,
1041 x_msg_count => x_msg_count,
1042 x_msg_data => x_msg_data);
1043 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044 raise FND_API.G_EXC_ERROR;
1045 END IF;
1046
1047 Validate_THRESHOLD_FLAG(
1048 p_api_name => p_api_name,
1049 p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1050 p_validation_mode => p_validation_mode,
1051 p_THRESHOLD_FLAG => P_GROUP_CHK_Rec.THRESHOLD_FLAG,
1052 x_return_status => x_return_status,
1053 x_msg_count => x_msg_count,
1054 x_msg_data => x_msg_data);
1055 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1056 raise FND_API.G_EXC_ERROR;
1057 END IF;
1058 */
1059
1060
1061 END Validate_group_checks;
1062
1063 End CSC_GROUP_CHECKS_PVT;