eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ACTCATEGORY_PVT dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

31: -- End of Comments
32:
33: PROCEDURE Create_Act_Category
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,

Line 36: p_commit IN VARCHAR2 := FND_API.G_FALSE,

32:
33: PROCEDURE Create_Act_Category
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,

Line 37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

33: PROCEDURE Create_Act_Category
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:

Line 66: IF NOT FND_API.Compatible_API_Call ( l_api_version,

62: -- Standard Start of API savepoint
63: SAVEPOINT Create_Act_Category_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call ( l_api_version,
67: p_api_version,
68: l_api_name,
69: G_PACKAGE_NAME)
70: THEN

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: p_api_version,
68: l_api_name,
69: G_PACKAGE_NAME)
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize message list IF p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list )

Line 75: IF FND_API.to_Boolean( p_init_msg_list )

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73:
74: -- Initialize message list IF p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list )
76: THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: FND_MSG_PUB.initialize;
78: END IF;
79:
80: -- Initialize API return status to success
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: --
84: -- API body
85: --

Line 101: IF l_return_status = FND_API.G_RET_STS_ERROR

97: ,p_act_category_rec => l_act_category_rec
98: );
99:
100: -- If any errors happen abort API.
101: IF l_return_status = FND_API.G_RET_STS_ERROR
102: THEN
103: RAISE FND_API.G_EXC_ERROR;
104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
105: THEN

Line 103: RAISE FND_API.G_EXC_ERROR;

99:
100: -- If any errors happen abort API.
101: IF l_return_status = FND_API.G_RET_STS_ERROR
102: THEN
103: RAISE FND_API.G_EXC_ERROR;
104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;

Line 104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

100: -- If any errors happen abort API.
101: IF l_return_status = FND_API.G_RET_STS_ERROR
102: THEN
103: RAISE FND_API.G_EXC_ERROR;
104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: THEN
103: RAISE FND_API.G_EXC_ERROR;
104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: --
110: -- Get ID for activity category from sequence.

Line 193: IF FND_API.To_Boolean ( p_commit )

189: -- END of API body.
190: --
191:
192: -- Standard check of p_commit.
193: IF FND_API.To_Boolean ( p_commit )
194: THEN
195: COMMIT WORK;
196: END IF;
197:

Line 202: p_encoded => FND_API.G_FALSE

198: -- Standard call to get message count AND IF count is 1, get message info.
199: FND_MSG_PUB.Count_AND_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data,
202: p_encoded => FND_API.G_FALSE
203: );
204:
205: EXCEPTION
206:

Line 207: WHEN FND_API.G_EXC_ERROR THEN

203: );
204:
205: EXCEPTION
206:
207: WHEN FND_API.G_EXC_ERROR THEN
208:
209: ROLLBACK TO Create_Act_Category_PVT;
210: x_return_status := FND_API.G_RET_STS_ERROR ;
211:

Line 210: x_return_status := FND_API.G_RET_STS_ERROR ;

206:
207: WHEN FND_API.G_EXC_ERROR THEN
208:
209: ROLLBACK TO Create_Act_Category_PVT;
210: x_return_status := FND_API.G_RET_STS_ERROR ;
211:
212: FND_MSG_PUB.Count_AND_Get
213: ( p_count => x_msg_count,
214: p_data => x_msg_data,

Line 215: p_encoded => FND_API.G_FALSE

211:
212: FND_MSG_PUB.Count_AND_Get
213: ( p_count => x_msg_count,
214: p_data => x_msg_data,
215: p_encoded => FND_API.G_FALSE
216: );
217:
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: p_encoded => FND_API.G_FALSE
216: );
217:
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220:
221: ROLLBACK TO Create_Act_Category_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220:
221: ROLLBACK TO Create_Act_Category_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: FND_MSG_PUB.Count_AND_Get
225: ( p_count => x_msg_count,
226: p_data => x_msg_data,

Line 227: p_encoded => FND_API.G_FALSE

223:
224: FND_MSG_PUB.Count_AND_Get
225: ( p_count => x_msg_count,
226: p_data => x_msg_data,
227: p_encoded => FND_API.G_FALSE
228: );
229:
230:
231: WHEN OTHERS THEN

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

230:
231: WHEN OTHERS THEN
232:
233: ROLLBACK TO Create_Act_Category_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
235:
236: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 244: p_encoded => FND_API.G_FALSE

240:
241: FND_MSG_PUB.Count_AND_Get
242: ( p_count => x_msg_count,
243: p_data => x_msg_data,
244: p_encoded => FND_API.G_FALSE
245: );
246:
247: END Create_Act_Category;
248:

Line 264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

260: -- End of Comments
261:
262: PROCEDURE Update_Act_Category
263: ( p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
265: p_commit IN VARCHAR2 := FND_API.G_FALSE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,

Line 265: p_commit IN VARCHAR2 := FND_API.G_FALSE,

261:
262: PROCEDURE Update_Act_Category
263: ( p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
265: p_commit IN VARCHAR2 := FND_API.G_FALSE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,

Line 266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

262: PROCEDURE Update_Act_Category
263: ( p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
265: p_commit IN VARCHAR2 := FND_API.G_FALSE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270:

Line 286: IF NOT FND_API.Compatible_API_Call ( l_api_version,

282: -- Standard Start of API savepoint
283: SAVEPOINT Update_Act_Category_PVT;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version,
287: p_api_version,
288: l_api_name,
289: G_PACKAGE_NAME)
290: THEN

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: p_api_version,
288: l_api_name,
289: G_PACKAGE_NAME)
290: THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: -- Initialize message list IF p_init_msg_list is set to TRUE.
295: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 295: IF FND_API.to_Boolean( p_init_msg_list ) THEN

291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: -- Initialize message list IF p_init_msg_list is set to TRUE.
295: IF FND_API.to_Boolean( p_init_msg_list ) THEN
296: FND_MSG_PUB.initialize;
297: END IF;
298:
299: -- Initialize API return status to success

Line 300: x_return_status := FND_API.G_RET_STS_SUCCESS;

296: FND_MSG_PUB.initialize;
297: END IF;
298:
299: -- Initialize API return status to success
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: --
303: -- API body
304: --

Line 323: IF l_return_status = FND_API.G_RET_STS_ERROR

319: ,p_act_category_rec => l_act_category_rec
320: );
321:
322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR
324: THEN
325: RAISE FND_API.G_EXC_ERROR;
326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
327: THEN

Line 325: RAISE FND_API.G_EXC_ERROR;

321:
322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR
324: THEN
325: RAISE FND_API.G_EXC_ERROR;
326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;

Line 326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR
324: THEN
325: RAISE FND_API.G_EXC_ERROR;
326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324: THEN
325: RAISE FND_API.G_EXC_ERROR;
326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: update AMS_ACT_CATEGORIES
332: set

Line 371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

367: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
368: FND_MSG_PUB.Add;
369: END IF;
370:
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF;
373:
374: --
375: -- END of API body.

Line 379: IF FND_API.To_Boolean ( p_commit )

375: -- END of API body.
376: --
377:
378: -- Standard check of p_commit.
379: IF FND_API.To_Boolean ( p_commit )
380: THEN
381: COMMIT WORK;
382: END IF;
383:

Line 388: p_encoded => FND_API.G_FALSE

384: -- Standard call to get message count AND IF count is 1, get message info.
385: FND_MSG_PUB.Count_AND_Get
386: ( p_count => x_msg_count,
387: p_data => x_msg_data,
388: p_encoded => FND_API.G_FALSE
389: );
390:
391: EXCEPTION
392:

Line 393: WHEN FND_API.G_EXC_ERROR THEN

389: );
390:
391: EXCEPTION
392:
393: WHEN FND_API.G_EXC_ERROR THEN
394:
395: ROLLBACK TO Update_Act_Category_PVT;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397:

Line 396: x_return_status := FND_API.G_RET_STS_ERROR ;

392:
393: WHEN FND_API.G_EXC_ERROR THEN
394:
395: ROLLBACK TO Update_Act_Category_PVT;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397:
398: FND_MSG_PUB.Count_AND_Get
399: ( p_count => x_msg_count,
400: p_data => x_msg_data,

Line 401: p_encoded => FND_API.G_FALSE

397:
398: FND_MSG_PUB.Count_AND_Get
399: ( p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE
402: );
403:
404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

401: p_encoded => FND_API.G_FALSE
402: );
403:
404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406:
407: ROLLBACK TO Update_Act_Category_PVT;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409:

Line 408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406:
407: ROLLBACK TO Update_Act_Category_PVT;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409:
410: FND_MSG_PUB.Count_AND_Get
411: ( p_count => x_msg_count,
412: p_data => x_msg_data,

Line 413: p_encoded => FND_API.G_FALSE

409:
410: FND_MSG_PUB.Count_AND_Get
411: ( p_count => x_msg_count,
412: p_data => x_msg_data,
413: p_encoded => FND_API.G_FALSE
414: );
415:
416:
417: WHEN OTHERS THEN

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

416:
417: WHEN OTHERS THEN
418:
419: ROLLBACK TO Update_Act_Category_PVT;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
421:
422: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
423: THEN
424: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 430: p_encoded => FND_API.G_FALSE

426:
427: FND_MSG_PUB.Count_AND_Get
428: ( p_count => x_msg_count,
429: p_data => x_msg_data,
430: p_encoded => FND_API.G_FALSE
431: );
432:
433: END Update_Act_Category;
434:

Line 450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

446: -- End of Comments
447:
448: PROCEDURE Delete_Act_Category
449: ( p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,

Line 451: p_commit IN VARCHAR2 := FND_API.G_FALSE,

447:
448: PROCEDURE Delete_Act_Category
449: ( p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,

Line 452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

448: PROCEDURE Delete_Act_Category
449: ( p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456:

Line 473: IF NOT FND_API.Compatible_API_Call ( l_api_version,

469: -- Standard Start of API savepoint
470: SAVEPOINT Delete_Act_Category_PVT;
471:
472: -- Standard call to check for call compatibility.
473: IF NOT FND_API.Compatible_API_Call ( l_api_version,
474: p_api_version,
475: l_api_name,
476: G_PACKAGE_NAME)
477: THEN

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

474: p_api_version,
475: l_api_name,
476: G_PACKAGE_NAME)
477: THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: -- Initialize message list IF p_init_msg_list is set to TRUE.
482: IF FND_API.to_Boolean( p_init_msg_list )

Line 482: IF FND_API.to_Boolean( p_init_msg_list )

478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: -- Initialize message list IF p_init_msg_list is set to TRUE.
482: IF FND_API.to_Boolean( p_init_msg_list )
483: THEN
484: FND_MSG_PUB.initialize;
485: END IF;
486:

Line 488: x_return_status := FND_API.G_RET_STS_SUCCESS;

484: FND_MSG_PUB.initialize;
485: END IF;
486:
487: -- Initialize API return status to success
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: --
491: -- API body
492: --

Line 511: RAISE FND_API.G_EXC_ERROR;

507: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
508: FND_MSG_PUB.add;
509: END IF;
510:
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:
514: --
515: -- END of API body.

Line 519: IF FND_API.To_Boolean ( p_commit )

515: -- END of API body.
516: --
517:
518: -- Standard check of p_commit.
519: IF FND_API.To_Boolean ( p_commit )
520: THEN
521: COMMIT WORK;
522: END IF;
523:

Line 528: p_encoded => FND_API.G_FALSE

524: -- Standard call to get message count AND IF count is 1, get message info.
525: FND_MSG_PUB.Count_AND_Get
526: ( p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => FND_API.G_FALSE
529: );
530:
531: EXCEPTION
532:

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: );
530:
531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534:
535: ROLLBACK TO Delete_Act_Category_PVT;
536: x_return_status := FND_API.G_RET_STS_ERROR ;
537:

Line 536: x_return_status := FND_API.G_RET_STS_ERROR ;

532:
533: WHEN FND_API.G_EXC_ERROR THEN
534:
535: ROLLBACK TO Delete_Act_Category_PVT;
536: x_return_status := FND_API.G_RET_STS_ERROR ;
537:
538: FND_MSG_PUB.Count_AND_Get
539: ( p_count => x_msg_count,
540: p_data => x_msg_data,

Line 541: p_encoded => FND_API.G_FALSE

537:
538: FND_MSG_PUB.Count_AND_Get
539: ( p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => FND_API.G_FALSE
542: );
543:
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: p_encoded => FND_API.G_FALSE
542: );
543:
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546:
547: ROLLBACK TO Delete_Act_Category_PVT;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549:

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546:
547: ROLLBACK TO Delete_Act_Category_PVT;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549:
550: FND_MSG_PUB.Count_AND_Get
551: ( p_count => x_msg_count,
552: p_data => x_msg_data,

Line 553: p_encoded => FND_API.G_FALSE

549:
550: FND_MSG_PUB.Count_AND_Get
551: ( p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE
554: );
555:
556:
557: WHEN OTHERS THEN

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

556:
557: WHEN OTHERS THEN
558:
559: ROLLBACK TO Delete_Act_Category_PVT;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561:
562: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 570: p_encoded => FND_API.G_FALSE

566:
567: FND_MSG_PUB.Count_AND_Get
568: ( p_count => x_msg_count,
569: p_data => x_msg_data,
570: p_encoded => FND_API.G_FALSE
571: );
572:
573: END Delete_Act_Category;
574:

Line 590: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

586: -- End of Comments
587:
588: PROCEDURE Lock_Act_Category
589: ( p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
592: x_return_status OUT NOCOPY VARCHAR2,
593: x_msg_count OUT NOCOPY NUMBER,
594: x_msg_data OUT NOCOPY VARCHAR2,

Line 591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

587:
588: PROCEDURE Lock_Act_Category
589: ( p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
592: x_return_status OUT NOCOPY VARCHAR2,
593: x_msg_count OUT NOCOPY NUMBER,
594: x_msg_data OUT NOCOPY VARCHAR2,
595:

Line 617: IF NOT FND_API.Compatible_API_Call ( l_api_version,

613:
614: BEGIN
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version,
618: p_api_version,
619: l_api_name,
620: G_PACKAGE_NAME)
621: THEN

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618: p_api_version,
619: l_api_name,
620: G_PACKAGE_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )

Line 626: IF FND_API.to_Boolean( p_init_msg_list )

622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )
627: THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630:

Line 632: x_return_status := FND_API.G_RET_STS_SUCCESS;

628: FND_MSG_PUB.initialize;
629: END IF;
630:
631: -- Initialize API return status to success
632: x_return_status := FND_API.G_RET_STS_SUCCESS;
633:
634: --
635: -- API body
636: --

Line 652: RAISE FND_API.G_EXC_ERROR;

648: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
649: FND_MSG_PUB.Add;
650: END IF;
651:
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: CLOSE c_act_category;
656:

Line 665: p_encoded => FND_API.G_FALSE

661: -- Standard call to get message count AND IF count is 1, get message info.
662: FND_MSG_PUB.Count_AND_Get
663: ( p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => FND_API.G_FALSE
666: );
667:
668: EXCEPTION
669:

Line 670: WHEN FND_API.G_EXC_ERROR THEN

666: );
667:
668: EXCEPTION
669:
670: WHEN FND_API.G_EXC_ERROR THEN
671:
672: x_return_status := FND_API.G_RET_STS_ERROR ;
673:
674: FND_MSG_PUB.Count_AND_Get

Line 672: x_return_status := FND_API.G_RET_STS_ERROR ;

668: EXCEPTION
669:
670: WHEN FND_API.G_EXC_ERROR THEN
671:
672: x_return_status := FND_API.G_RET_STS_ERROR ;
673:
674: FND_MSG_PUB.Count_AND_Get
675: ( p_count => x_msg_count,
676: p_data => x_msg_data,

Line 677: p_encoded => FND_API.G_FALSE

673:
674: FND_MSG_PUB.Count_AND_Get
675: ( p_count => x_msg_count,
676: p_data => x_msg_data,
677: p_encoded => FND_API.G_FALSE
678: );
679:
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: p_encoded => FND_API.G_FALSE
678: );
679:
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684:
685: FND_MSG_PUB.Count_AND_Get

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

679:
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684:
685: FND_MSG_PUB.Count_AND_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data,

Line 688: p_encoded => FND_API.G_FALSE

684:
685: FND_MSG_PUB.Count_AND_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data,
688: p_encoded => FND_API.G_FALSE
689: );
690:
691: WHEN AMS_Utility_PVT.resource_locked THEN
692: x_return_status := FND_API.g_ret_sts_error;

Line 692: x_return_status := FND_API.g_ret_sts_error;

688: p_encoded => FND_API.G_FALSE
689: );
690:
691: WHEN AMS_Utility_PVT.resource_locked THEN
692: x_return_status := FND_API.g_ret_sts_error;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
694: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
695: FND_MSG_PUB.add;
696: END IF;

Line 701: p_encoded => FND_API.G_FALSE

697:
698: FND_MSG_PUB.Count_AND_Get
699: ( p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => FND_API.G_FALSE
702: );
703:
704: WHEN OTHERS THEN
705:

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

702: );
703:
704: WHEN OTHERS THEN
705:
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
707:
708: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
709: THEN
710: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 716: p_encoded => FND_API.G_FALSE

712:
713: FND_MSG_PUB.Count_AND_Get
714: ( p_count => x_msg_count,
715: p_data => x_msg_data,
716: p_encoded => FND_API.G_FALSE
717: );
718:
719: END Lock_Act_Category;
720:

Line 737: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

733: -- End of Comments
734:
735: PROCEDURE Validate_Act_Category
736: ( p_api_version IN NUMBER,
737: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
738: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,
741: x_msg_data OUT NOCOPY VARCHAR2,

Line 738: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

734:
735: PROCEDURE Validate_Act_Category
736: ( p_api_version IN NUMBER,
737: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
738: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,
741: x_msg_data OUT NOCOPY VARCHAR2,
742:

Line 769: IF NOT FND_API.Compatible_API_Call ( l_api_version,

765:
766: BEGIN
767:
768: -- Standard call to check for call compatibility.
769: IF NOT FND_API.Compatible_API_Call ( l_api_version,
770: p_api_version,
771: l_api_name,
772: G_PACKAGE_NAME)
773: THEN

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

770: p_api_version,
771: l_api_name,
772: G_PACKAGE_NAME)
773: THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776:
777: -- Initialize message list if p_init_msg_list is set to TRUE.
778: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 778: IF FND_API.to_Boolean( p_init_msg_list ) THEN

774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776:
777: -- Initialize message list if p_init_msg_list is set to TRUE.
778: IF FND_API.to_Boolean( p_init_msg_list ) THEN
779: FND_MSG_PUB.initialize;
780: END IF;
781:
782:

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: END IF;
781:
782:
783: -- Initialize API return status to success
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: --
787: -- API body
788: --

Line 801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

797: x_return_status => l_return_status
798: );
799:
800: -- If any errors happen abort API.
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
802: THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
805: THEN

Line 803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

799:
800: -- If any errors happen abort API.
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
802: THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
805: THEN
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;

Line 804: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

800: -- If any errors happen abort API.
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
802: THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
805: THEN
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808: END IF;

Line 806: RAISE FND_API.G_EXC_ERROR;

802: THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
805: THEN
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808: END IF;
809:
810: -- Perform cross attribute validation and missing attribute checks. Record

Line 825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

821: x_return_status => l_return_status
822: );
823:
824: -- If any errors happen abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;

Line 826: RAISE FND_API.G_EXC_ERROR;

822: );
823:
824: -- If any errors happen abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;

Line 827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

823:
824: -- If any errors happen abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831:

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824: -- If any errors happen abort API.
825: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831:
832: --

Line 847: x_return_status := FND_API.g_ret_sts_error;

843: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
844: FND_MESSAGE.set_name ('AMS', 'AMS_CTG_ACT_DUP');
845: FND_MSG_PUB.add;
846: END IF;
847: x_return_status := FND_API.g_ret_sts_error;
848: RETURN;
849: END IF;
850: -------------------- finish --------------------------
851: FND_MSG_PUB.count_and_get(

Line 852: p_encoded => FND_API.g_false,

848: RETURN;
849: END IF;
850: -------------------- finish --------------------------
851: FND_MSG_PUB.count_and_get(
852: p_encoded => FND_API.g_false,
853: p_count => x_msg_count,
854: p_data => x_msg_data
855: );
856:

Line 859: WHEN FND_API.G_EXC_ERROR THEN

855: );
856:
857: EXCEPTION
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860:
861: x_return_status := FND_API.G_RET_STS_ERROR ;
862:
863: FND_MSG_PUB.Count_AND_Get

Line 861: x_return_status := FND_API.G_RET_STS_ERROR ;

857: EXCEPTION
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860:
861: x_return_status := FND_API.G_RET_STS_ERROR ;
862:
863: FND_MSG_PUB.Count_AND_Get
864: ( p_count => x_msg_count,
865: p_data => x_msg_data,

Line 866: p_encoded => FND_API.G_FALSE

862:
863: FND_MSG_PUB.Count_AND_Get
864: ( p_count => x_msg_count,
865: p_data => x_msg_data,
866: p_encoded => FND_API.G_FALSE
867: );
868:
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

866: p_encoded => FND_API.G_FALSE
867: );
868:
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873:
874: FND_MSG_PUB.Count_AND_Get

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

868:
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873:
874: FND_MSG_PUB.Count_AND_Get
875: ( p_count => x_msg_count,
876: p_data => x_msg_data,

Line 877: p_encoded => FND_API.G_FALSE

873:
874: FND_MSG_PUB.Count_AND_Get
875: ( p_count => x_msg_count,
876: p_data => x_msg_data,
877: p_encoded => FND_API.G_FALSE
878: );
879:
880:
881: WHEN OTHERS THEN

Line 883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

879:
880:
881: WHEN OTHERS THEN
882:
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
884:
885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

Line 893: p_encoded => FND_API.G_FALSE

889:
890: FND_MSG_PUB.Count_AND_Get
891: ( p_count => x_msg_count,
892: p_data => x_msg_data,
893: p_encoded => FND_API.G_FALSE
894: );
895:
896: END Validate_Act_Category;
897:

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927: and ACT_CATEGORY_USED_BY_ID = arc_used_id_in);
928:
929: BEGIN
930: -- Initialize API/Procedure return status to success
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: -- Check required parameters
934:
935: IF (p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.G_MISS_NUM OR

Line 935: IF (p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.G_MISS_NUM OR

931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: -- Check required parameters
934:
935: IF (p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.G_MISS_NUM OR
936: p_act_category_rec.ACT_CATEGORY_USED_BY_ID IS NULL)
937: THEN
938: -- missing required fields
939: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 945: x_return_status := FND_API.G_RET_STS_ERROR;

941: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_USEDBYID');
942: FND_MSG_PUB.add;
943: END IF;
944:
945: x_return_status := FND_API.G_RET_STS_ERROR;
946:
947: -- If any error happens abort API.
948: RETURN;
949: END IF;

Line 953: IF (p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = FND_API.G_MISS_CHAR OR

949: END IF;
950:
951: -- ARC_ACT_CATEGORY_USED_BY
952:
953: IF (p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = FND_API.G_MISS_CHAR OR
954: p_act_category_rec.ARC_ACT_CATEGORY_USED_BY IS NULL)
955: THEN
956: -- missing required fields
957: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 963: x_return_status := FND_API.G_RET_STS_ERROR;

959: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_USEDBY');
960: FND_MSG_PUB.add;
961: END IF;
962:
963: x_return_status := FND_API.G_RET_STS_ERROR;
964:
965: -- If any error happens abort API.
966: RETURN;
967: END IF;

Line 969: IF (p_act_category_rec.CATEGORY_ID = FND_API.G_MISS_NUM OR

965: -- If any error happens abort API.
966: RETURN;
967: END IF;
968:
969: IF (p_act_category_rec.CATEGORY_ID = FND_API.G_MISS_NUM OR
970: p_act_category_rec.CATEGORY_ID IS NULL)
971: THEN
972:
973: -- missing required fields

Line 980: x_return_status := FND_API.G_RET_STS_ERROR;

976: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_CATEGORY_ID');
977: FND_MSG_PUB.add;
978: END IF;
979:
980: x_return_status := FND_API.G_RET_STS_ERROR;
981:
982: -- If any error happens abort API.
983: RETURN;
984: END IF;

Line 993: ) = FND_API.g_false

989: THEN
990: IF AMS_Utility_PVT.check_uniqueness(
991: 'ams_act_categories',
992: 'activity_category_id = ' || p_act_category_rec.activity_category_id
993: ) = FND_API.g_false
994: THEN
995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
996: THEN
997: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_DUPLICATE_ID');

Line 1000: x_return_status := FND_API.g_ret_sts_error;

996: THEN
997: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_DUPLICATE_ID');
998: FND_MSG_PUB.add;
999: END IF;
1000: x_return_status := FND_API.g_ret_sts_error;
1001: RETURN;
1002: END IF;
1003: END IF;
1004:

Line 1011: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num

1007: --
1008: /* code for chenging ACT_CATEGORY_USED_BY_ID is wrong rewritten by mukumar
1009: on 04/10/2001
1010: -- Check FK parameter: ACT_CATEGORY_USED_BY_ID #1
1011: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num
1012: THEN
1013: l_table_name := 'AMS_ACT_CATEGORIES';
1014: l_pk_name := 'ACT_CATEGORY_USED_BY_ID';
1015: l_pk_value := p_act_category_rec.ACT_CATEGORY_USED_BY_ID;

Line 1021: ) = FND_API.G_FALSE

1017: IF AMS_Utility_PVT.Check_FK_Exists (
1018: p_table_name => l_table_name
1019: ,p_pk_name => l_pk_name
1020: ,p_pk_value => l_pk_value
1021: ) = FND_API.G_FALSE
1022: THEN
1023: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1024: THEN
1025: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_EVEH_REF');

Line 1028: x_return_status := FND_API.G_RET_STS_ERROR;

1024: THEN
1025: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_EVEH_REF');
1026: FND_MSG_PUB.add;
1027: END IF;
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: -- If any errors happen abort API/Procedure.
1030: RETURN;
1031:
1032: END IF; -- check_fk_exists

Line 1036: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num

1032: END IF; -- check_fk_exists
1033: END IF;
1034:
1035: -- Check FK parameter: ACT_CATEGORY_USED_BY_ID #3
1036: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num
1037: THEN
1038: l_table_name := 'AMS_ACT_CATEGORIES';
1039: l_pk_name := 'ACT_CATEGORY_USED_BY_ID';
1040: l_pk_value := p_act_category_rec.ACT_CATEGORY_USED_BY_ID;

Line 1046: ) = FND_API.G_FALSE

1042: IF AMS_Utility_PVT.Check_FK_Exists (
1043: p_table_name => l_table_name
1044: ,p_pk_name => l_pk_name
1045: ,p_pk_value => l_pk_value
1046: ) = FND_API.G_FALSE
1047: THEN
1048: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1049: THEN
1050: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_EVEO_REF');

Line 1053: x_return_status := FND_API.G_RET_STS_ERROR;

1049: THEN
1050: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_EVEO_REF');
1051: FND_MSG_PUB.add;
1052: END IF;
1053: x_return_status := FND_API.G_RET_STS_ERROR;
1054: -- If any errors happen abort API/Procedure.
1055: RETURN;
1056:
1057: END IF; -- check_fk_exists

Line 1060: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num

1056:
1057: END IF; -- check_fk_exists
1058: END IF;
1059: */
1060: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num
1061: THEN
1062: if(p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = 'EVEH') THEN
1063: l_table_name := 'AMS_EVENT_HEADERS_ALL_B';
1064: l_pk_name := 'EVENT_HEADER_ID';

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR;

1072: THEN
1073: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_BAD_USEDBY');
1074: FND_MSG_PUB.add;
1075: END IF;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: -- If any errors happen abort API/Procedure.
1078: RETURN;
1079: end if;
1080: IF AMS_Utility_PVT.Check_FK_Exists (

Line 1084: ) = FND_API.G_FALSE

1080: IF AMS_Utility_PVT.Check_FK_Exists (
1081: p_table_name => l_table_name
1082: ,p_pk_name => l_pk_name
1083: ,p_pk_value => l_pk_value
1084: ) = FND_API.G_FALSE
1085: THEN
1086: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1087: THEN
1088: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_EVEH_REF');

Line 1091: x_return_status := FND_API.G_RET_STS_ERROR;

1087: THEN
1088: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_EVEH_REF');
1089: FND_MSG_PUB.add;
1090: END IF;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: -- If any errors happen abort API/Procedure.
1093: RETURN;
1094:
1095: END IF; -- check_fk_exists

Line 1098: IF p_act_category_rec.CATEGORY_ID <> FND_API.g_miss_num

1094:
1095: END IF; -- check_fk_exists
1096: END IF;
1097: -- Check FK parameter: CATEGORY_ID
1098: IF p_act_category_rec.CATEGORY_ID <> FND_API.g_miss_num
1099: THEN
1100: l_table_name := 'AMS_CATEGORIES_B';
1101: l_pk_name := 'CATEGORY_ID';
1102: l_pk_value := p_act_category_rec.CATEGORY_ID;

Line 1108: ) = FND_API.G_FALSE

1104: IF AMS_Utility_PVT.Check_FK_Exists (
1105: p_table_name => l_table_name
1106: ,p_pk_name => l_pk_name
1107: ,p_pk_value => l_pk_value
1108: ) = FND_API.G_FALSE
1109: THEN
1110: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1111: THEN
1112: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_CAT_REF');

Line 1115: x_return_status := FND_API.G_RET_STS_ERROR;

1111: THEN
1112: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_INVALID_CAT_REF');
1113: FND_MSG_PUB.add;
1114: END IF;
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: -- If any errors happen abort API/Procedure.
1117: RETURN;
1118:
1119: END IF; -- check_fk_exists

Line 1124: IF p_act_category_rec.arc_act_category_used_by <> FND_API.g_miss_char THEN

1120: END IF;
1121:
1122: -- check for lookups....
1123:
1124: IF p_act_category_rec.arc_act_category_used_by <> FND_API.g_miss_char THEN
1125: IF AMS_Utility_PVT.check_lookup_exists(
1126: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1127: p_lookup_code => p_act_category_rec.arc_act_category_used_by
1128: ) = FND_API.g_false

Line 1128: ) = FND_API.g_false

1124: IF p_act_category_rec.arc_act_category_used_by <> FND_API.g_miss_char THEN
1125: IF AMS_Utility_PVT.check_lookup_exists(
1126: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1127: p_lookup_code => p_act_category_rec.arc_act_category_used_by
1128: ) = FND_API.g_false
1129: THEN
1130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1131: THEN
1132: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_BAD_USEDBY');

Line 1136: x_return_status := FND_API.g_ret_sts_error;

1132: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_BAD_USEDBY');
1133: FND_MSG_PUB.add;
1134: END IF;
1135:
1136: x_return_status := FND_API.g_ret_sts_error;
1137: RETURN;
1138: END IF;
1139: END IF;
1140:

Line 1154: x_return_status := FND_API.g_ret_sts_error;

1150: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name ('AMS', 'AMS_CTG_ACT_DUP');
1152: FND_MSG_PUB.add;
1153: END IF;
1154: x_return_status := FND_API.g_ret_sts_error;
1155: RETURN;
1156: END IF;
1157: END Validate_Act_Cty_Items;
1158:

Line 1183: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1179: l_return_status VARCHAR2(1); -- Return value from procedures
1180: BEGIN
1181:
1182: -- Standard call to check for call compatibility.
1183: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1184: l_api_version,
1185: l_api_name,
1186: G_PACKAGE_NAME)
1187: THEN

Line 1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1184: l_api_version,
1185: l_api_name,
1186: G_PACKAGE_NAME)
1187: THEN
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191:
1192: -- Initialize API return status to success

Line 1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

1189: END IF;
1190:
1191:
1192: -- Initialize API return status to success
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194:
1195: --
1196: -- API body
1197:

Line 1229: RAISE FND_API.g_exc_error;

1225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1226: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1227: FND_MSG_PUB.add;
1228: END IF;
1229: RAISE FND_API.g_exc_error;
1230: END IF;
1231: CLOSE c_cat;
1232:
1233: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.g_miss_num THEN

Line 1233: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.g_miss_num THEN

1229: RAISE FND_API.g_exc_error;
1230: END IF;
1231: CLOSE c_cat;
1232:
1233: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.g_miss_num THEN
1234: x_act_category_rec.ACT_CATEGORY_USED_BY_ID := l_act_category_rec.ACT_CATEGORY_USED_BY_ID;
1235: END IF;
1236: IF p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = FND_API.g_miss_char THEN
1237: x_act_category_rec.ARC_ACT_CATEGORY_USED_BY := l_act_category_rec.ARC_ACT_CATEGORY_USED_BY;

Line 1236: IF p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = FND_API.g_miss_char THEN

1232:
1233: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID = FND_API.g_miss_num THEN
1234: x_act_category_rec.ACT_CATEGORY_USED_BY_ID := l_act_category_rec.ACT_CATEGORY_USED_BY_ID;
1235: END IF;
1236: IF p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = FND_API.g_miss_char THEN
1237: x_act_category_rec.ARC_ACT_CATEGORY_USED_BY := l_act_category_rec.ARC_ACT_CATEGORY_USED_BY;
1238: END IF;
1239: IF p_act_category_rec.CATEGORY_ID = FND_API.g_miss_num THEN
1240: x_act_category_rec.CATEGORY_ID := l_act_category_rec.CATEGORY_ID;

Line 1239: IF p_act_category_rec.CATEGORY_ID = FND_API.g_miss_num THEN

1235: END IF;
1236: IF p_act_category_rec.ARC_ACT_CATEGORY_USED_BY = FND_API.g_miss_char THEN
1237: x_act_category_rec.ARC_ACT_CATEGORY_USED_BY := l_act_category_rec.ARC_ACT_CATEGORY_USED_BY;
1238: END IF;
1239: IF p_act_category_rec.CATEGORY_ID = FND_API.g_miss_num THEN
1240: x_act_category_rec.CATEGORY_ID := l_act_category_rec.CATEGORY_ID;
1241: END IF;
1242: IF p_act_category_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN
1243: x_act_category_rec.ATTRIBUTE_CATEGORY := l_act_category_rec.ATTRIBUTE_CATEGORY;

Line 1242: IF p_act_category_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN

1238: END IF;
1239: IF p_act_category_rec.CATEGORY_ID = FND_API.g_miss_num THEN
1240: x_act_category_rec.CATEGORY_ID := l_act_category_rec.CATEGORY_ID;
1241: END IF;
1242: IF p_act_category_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN
1243: x_act_category_rec.ATTRIBUTE_CATEGORY := l_act_category_rec.ATTRIBUTE_CATEGORY;
1244: END IF;
1245: IF p_act_category_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN
1246: x_act_category_rec.ATTRIBUTE1 := l_act_category_rec.ATTRIBUTE1;

Line 1245: IF p_act_category_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN

1241: END IF;
1242: IF p_act_category_rec.ATTRIBUTE_CATEGORY = FND_API.g_miss_char THEN
1243: x_act_category_rec.ATTRIBUTE_CATEGORY := l_act_category_rec.ATTRIBUTE_CATEGORY;
1244: END IF;
1245: IF p_act_category_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN
1246: x_act_category_rec.ATTRIBUTE1 := l_act_category_rec.ATTRIBUTE1;
1247: END IF;
1248: IF p_act_category_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN
1249: x_act_category_rec.ATTRIBUTE2 := l_act_category_rec.ATTRIBUTE2;

Line 1248: IF p_act_category_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN

1244: END IF;
1245: IF p_act_category_rec.ATTRIBUTE1 = FND_API.g_miss_char THEN
1246: x_act_category_rec.ATTRIBUTE1 := l_act_category_rec.ATTRIBUTE1;
1247: END IF;
1248: IF p_act_category_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN
1249: x_act_category_rec.ATTRIBUTE2 := l_act_category_rec.ATTRIBUTE2;
1250: END IF;
1251: IF p_act_category_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN
1252: x_act_category_rec.ATTRIBUTE3 := l_act_category_rec.ATTRIBUTE3;

Line 1251: IF p_act_category_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN

1247: END IF;
1248: IF p_act_category_rec.ATTRIBUTE2 = FND_API.g_miss_char THEN
1249: x_act_category_rec.ATTRIBUTE2 := l_act_category_rec.ATTRIBUTE2;
1250: END IF;
1251: IF p_act_category_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN
1252: x_act_category_rec.ATTRIBUTE3 := l_act_category_rec.ATTRIBUTE3;
1253: END IF;
1254: IF p_act_category_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN
1255: x_act_category_rec.ATTRIBUTE4 := l_act_category_rec.ATTRIBUTE4;

Line 1254: IF p_act_category_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN

1250: END IF;
1251: IF p_act_category_rec.ATTRIBUTE3 = FND_API.g_miss_char THEN
1252: x_act_category_rec.ATTRIBUTE3 := l_act_category_rec.ATTRIBUTE3;
1253: END IF;
1254: IF p_act_category_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN
1255: x_act_category_rec.ATTRIBUTE4 := l_act_category_rec.ATTRIBUTE4;
1256: END IF;
1257: IF p_act_category_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN
1258: x_act_category_rec.ATTRIBUTE5 := l_act_category_rec.ATTRIBUTE5;

Line 1257: IF p_act_category_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN

1253: END IF;
1254: IF p_act_category_rec.ATTRIBUTE4 = FND_API.g_miss_char THEN
1255: x_act_category_rec.ATTRIBUTE4 := l_act_category_rec.ATTRIBUTE4;
1256: END IF;
1257: IF p_act_category_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN
1258: x_act_category_rec.ATTRIBUTE5 := l_act_category_rec.ATTRIBUTE5;
1259: END IF;
1260: IF p_act_category_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN
1261: x_act_category_rec.ATTRIBUTE6 := l_act_category_rec.ATTRIBUTE6;

Line 1260: IF p_act_category_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN

1256: END IF;
1257: IF p_act_category_rec.ATTRIBUTE5 = FND_API.g_miss_char THEN
1258: x_act_category_rec.ATTRIBUTE5 := l_act_category_rec.ATTRIBUTE5;
1259: END IF;
1260: IF p_act_category_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN
1261: x_act_category_rec.ATTRIBUTE6 := l_act_category_rec.ATTRIBUTE6;
1262: END IF;
1263: IF p_act_category_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN
1264: x_act_category_rec.ATTRIBUTE7 := l_act_category_rec.ATTRIBUTE7;

Line 1263: IF p_act_category_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN

1259: END IF;
1260: IF p_act_category_rec.ATTRIBUTE6 = FND_API.g_miss_char THEN
1261: x_act_category_rec.ATTRIBUTE6 := l_act_category_rec.ATTRIBUTE6;
1262: END IF;
1263: IF p_act_category_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN
1264: x_act_category_rec.ATTRIBUTE7 := l_act_category_rec.ATTRIBUTE7;
1265: END IF;
1266: IF p_act_category_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN
1267: x_act_category_rec.ATTRIBUTE8 := l_act_category_rec.ATTRIBUTE8;

Line 1266: IF p_act_category_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN

1262: END IF;
1263: IF p_act_category_rec.ATTRIBUTE7 = FND_API.g_miss_char THEN
1264: x_act_category_rec.ATTRIBUTE7 := l_act_category_rec.ATTRIBUTE7;
1265: END IF;
1266: IF p_act_category_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN
1267: x_act_category_rec.ATTRIBUTE8 := l_act_category_rec.ATTRIBUTE8;
1268: END IF;
1269: IF p_act_category_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN
1270: x_act_category_rec.ATTRIBUTE9 := l_act_category_rec.ATTRIBUTE9;

Line 1269: IF p_act_category_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN

1265: END IF;
1266: IF p_act_category_rec.ATTRIBUTE8 = FND_API.g_miss_char THEN
1267: x_act_category_rec.ATTRIBUTE8 := l_act_category_rec.ATTRIBUTE8;
1268: END IF;
1269: IF p_act_category_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN
1270: x_act_category_rec.ATTRIBUTE9 := l_act_category_rec.ATTRIBUTE9;
1271: END IF;
1272: IF p_act_category_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN
1273: x_act_category_rec.ATTRIBUTE10 := l_act_category_rec.ATTRIBUTE10;

Line 1272: IF p_act_category_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN

1268: END IF;
1269: IF p_act_category_rec.ATTRIBUTE9 = FND_API.g_miss_char THEN
1270: x_act_category_rec.ATTRIBUTE9 := l_act_category_rec.ATTRIBUTE9;
1271: END IF;
1272: IF p_act_category_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN
1273: x_act_category_rec.ATTRIBUTE10 := l_act_category_rec.ATTRIBUTE10;
1274: END IF;
1275:
1276: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

Line 1276: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

1272: IF p_act_category_rec.ATTRIBUTE10 = FND_API.g_miss_char THEN
1273: x_act_category_rec.ATTRIBUTE10 := l_act_category_rec.ATTRIBUTE10;
1274: END IF;
1275:
1276: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
1277: x_act_category_rec.ATTRIBUTE11 := l_act_category_rec.ATTRIBUTE11;
1278: END IF;
1279: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
1280: x_act_category_rec.ATTRIBUTE11 := l_act_category_rec.ATTRIBUTE11;

Line 1279: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN

1275:
1276: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
1277: x_act_category_rec.ATTRIBUTE11 := l_act_category_rec.ATTRIBUTE11;
1278: END IF;
1279: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
1280: x_act_category_rec.ATTRIBUTE11 := l_act_category_rec.ATTRIBUTE11;
1281: END IF;
1282: IF p_act_category_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN
1283: x_act_category_rec.ATTRIBUTE12 := l_act_category_rec.ATTRIBUTE12;

Line 1282: IF p_act_category_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN

1278: END IF;
1279: IF p_act_category_rec.ATTRIBUTE11 = FND_API.g_miss_char THEN
1280: x_act_category_rec.ATTRIBUTE11 := l_act_category_rec.ATTRIBUTE11;
1281: END IF;
1282: IF p_act_category_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN
1283: x_act_category_rec.ATTRIBUTE12 := l_act_category_rec.ATTRIBUTE12;
1284: END IF;
1285: IF p_act_category_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN
1286: x_act_category_rec.ATTRIBUTE13 := l_act_category_rec.ATTRIBUTE13;

Line 1285: IF p_act_category_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN

1281: END IF;
1282: IF p_act_category_rec.ATTRIBUTE12 = FND_API.g_miss_char THEN
1283: x_act_category_rec.ATTRIBUTE12 := l_act_category_rec.ATTRIBUTE12;
1284: END IF;
1285: IF p_act_category_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN
1286: x_act_category_rec.ATTRIBUTE13 := l_act_category_rec.ATTRIBUTE13;
1287: END IF;
1288: IF p_act_category_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN
1289: x_act_category_rec.ATTRIBUTE14 := l_act_category_rec.ATTRIBUTE14;

Line 1288: IF p_act_category_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN

1284: END IF;
1285: IF p_act_category_rec.ATTRIBUTE13 = FND_API.g_miss_char THEN
1286: x_act_category_rec.ATTRIBUTE13 := l_act_category_rec.ATTRIBUTE13;
1287: END IF;
1288: IF p_act_category_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN
1289: x_act_category_rec.ATTRIBUTE14 := l_act_category_rec.ATTRIBUTE14;
1290: END IF;
1291: IF p_act_category_rec.ATTRIBUTE15 = FND_API.g_miss_char THEN
1292: x_act_category_rec.ATTRIBUTE15 := l_act_category_rec.ATTRIBUTE15;

Line 1291: IF p_act_category_rec.ATTRIBUTE15 = FND_API.g_miss_char THEN

1287: END IF;
1288: IF p_act_category_rec.ATTRIBUTE14 = FND_API.g_miss_char THEN
1289: x_act_category_rec.ATTRIBUTE14 := l_act_category_rec.ATTRIBUTE14;
1290: END IF;
1291: IF p_act_category_rec.ATTRIBUTE15 = FND_API.g_miss_char THEN
1292: x_act_category_rec.ATTRIBUTE15 := l_act_category_rec.ATTRIBUTE15;
1293: END IF;
1294:
1295: END complete_act_category_rec;

Line 1346: ,p_init_msg_list => FND_API.G_FALSE

1342:
1343:
1344: AMS_ActCategory_PVT.Create_Category (
1345: p_api_version => 1.0 -- p_api_version
1346: ,p_init_msg_list => FND_API.G_FALSE
1347: ,p_commit => FND_API.G_FALSE
1348: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1349: ,x_return_status => l_return_status
1350: ,x_msg_count => l_msg_count

Line 1347: ,p_commit => FND_API.G_FALSE

1343:
1344: AMS_ActCategory_PVT.Create_Category (
1345: p_api_version => 1.0 -- p_api_version
1346: ,p_init_msg_list => FND_API.G_FALSE
1347: ,p_commit => FND_API.G_FALSE
1348: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1349: ,x_return_status => l_return_status
1350: ,x_msg_count => l_msg_count
1351: ,x_msg_data => l_msg_data

Line 1348: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1344: AMS_ActCategory_PVT.Create_Category (
1345: p_api_version => 1.0 -- p_api_version
1346: ,p_init_msg_list => FND_API.G_FALSE
1347: ,p_commit => FND_API.G_FALSE
1348: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1349: ,x_return_status => l_return_status
1350: ,x_msg_count => l_msg_count
1351: ,x_msg_data => l_msg_data
1352:

Line 1353: ,p_PK => FND_API.G_TRUE

1349: ,x_return_status => l_return_status
1350: ,x_msg_count => l_msg_count
1351: ,x_msg_data => l_msg_data
1352:
1353: ,p_PK => FND_API.G_TRUE
1354: ,p_default => FND_API.G_TRUE
1355: ,p_Category_req_item_rec => l_Category_req_item_rec
1356: ,p_Category_validate_item_rec => l_Category_validate_item_rec
1357: ,p_Category_default_item_rec => l_Category_default_item_rec

Line 1354: ,p_default => FND_API.G_TRUE

1350: ,x_msg_count => l_msg_count
1351: ,x_msg_data => l_msg_data
1352:
1353: ,p_PK => FND_API.G_TRUE
1354: ,p_default => FND_API.G_TRUE
1355: ,p_Category_req_item_rec => l_Category_req_item_rec
1356: ,p_Category_validate_item_rec => l_Category_validate_item_rec
1357: ,p_Category_default_item_rec => l_Category_default_item_rec
1358: ,p_Category_validate_row_rec => l_Category_validate_row_rec

Line 1363: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1359: ,p_category_rec => l_category_rec
1360: ,x_category_id => l_category_id
1361: );
1362:
1363: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1364: ELSE
1365: commit work;
1366: END IF;
1367:

Line 1404: ,p_init_msg_list => FND_API.G_FALSE

1400:
1401:
1402: AMS_ActCategory_PVT.Delete_Category (
1403: p_api_version => 1.0 -- p_api_version
1404: ,p_init_msg_list => FND_API.G_FALSE
1405: ,p_commit => FND_API.G_FALSE
1406: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1407: ,p_category_rec => l_category_rec
1408:

Line 1405: ,p_commit => FND_API.G_FALSE

1401:
1402: AMS_ActCategory_PVT.Delete_Category (
1403: p_api_version => 1.0 -- p_api_version
1404: ,p_init_msg_list => FND_API.G_FALSE
1405: ,p_commit => FND_API.G_FALSE
1406: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1407: ,p_category_rec => l_category_rec
1408:
1409: ,x_return_status => l_return_status

Line 1406: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1402: AMS_ActCategory_PVT.Delete_Category (
1403: p_api_version => 1.0 -- p_api_version
1404: ,p_init_msg_list => FND_API.G_FALSE
1405: ,p_commit => FND_API.G_FALSE
1406: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1407: ,p_category_rec => l_category_rec
1408:
1409: ,x_return_status => l_return_status
1410: ,x_msg_count => l_msg_count

Line 1414: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1410: ,x_msg_count => l_msg_count
1411: ,x_msg_data => l_msg_data
1412: );
1413:
1414: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1415: ELSE
1416: commit work;
1417: END IF;
1418:

Line 1463: ,p_init_msg_list => FND_API.G_FALSE

1459: l_category_rec.NOTES := 'NOTES UPDATED1';
1460:
1461: AMS_ActCategory_PVT.Update_Category (
1462: p_api_version => 1.0 -- p_api_version
1463: ,p_init_msg_list => FND_API.G_FALSE
1464: ,p_commit => FND_API.G_FALSE
1465: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1466: ,p_category_rec => l_category_rec
1467:

Line 1464: ,p_commit => FND_API.G_FALSE

1460:
1461: AMS_ActCategory_PVT.Update_Category (
1462: p_api_version => 1.0 -- p_api_version
1463: ,p_init_msg_list => FND_API.G_FALSE
1464: ,p_commit => FND_API.G_FALSE
1465: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1466: ,p_category_rec => l_category_rec
1467:
1468: ,x_return_status => l_return_status

Line 1465: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1461: AMS_ActCategory_PVT.Update_Category (
1462: p_api_version => 1.0 -- p_api_version
1463: ,p_init_msg_list => FND_API.G_FALSE
1464: ,p_commit => FND_API.G_FALSE
1465: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1466: ,p_category_rec => l_category_rec
1467:
1468: ,x_return_status => l_return_status
1469: ,x_msg_count => l_msg_count

Line 1473: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1469: ,x_msg_count => l_msg_count
1470: ,x_msg_data => l_msg_data
1471: );
1472:
1473: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1474: THEN
1475: ELSE
1476: commit work;
1477: END IF;

Line 1520: ,p_init_msg_list => FND_API.G_FALSE

1516: l_category_rec.NOTES := 'server side test';
1517:
1518: AMS_ActCategory_PVT.Lock_Category (
1519: p_api_version => 1.0 -- p_api_version
1520: ,p_init_msg_list => FND_API.G_FALSE
1521: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1522: ,p_category_rec => l_category_rec
1523:
1524: ,x_return_status => l_return_status

Line 1521: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1517:
1518: AMS_ActCategory_PVT.Lock_Category (
1519: p_api_version => 1.0 -- p_api_version
1520: ,p_init_msg_list => FND_API.G_FALSE
1521: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1522: ,p_category_rec => l_category_rec
1523:
1524: ,x_return_status => l_return_status
1525: ,x_msg_count => l_msg_count

Line 1529: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1525: ,x_msg_count => l_msg_count
1526: ,x_msg_data => l_msg_data
1527: );
1528:
1529: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1530: --RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:
1533: NULL;

Line 1530: --RAISE FND_API.G_EXC_ERROR;

1526: ,x_msg_data => l_msg_data
1527: );
1528:
1529: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1530: --RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:
1533: NULL;
1534:

Line 1590: ,p_init_msg_list => FND_API.G_FALSE

1586:
1587:
1588: AMS_ActCategory_PVT.Create_Act_Category (
1589: p_api_version => 1.0 -- p_api_version
1590: ,p_init_msg_list => FND_API.G_FALSE
1591: ,p_commit => FND_API.G_FALSE
1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1593: ,x_return_status => l_return_status
1594: ,x_msg_count => l_msg_count

Line 1591: ,p_commit => FND_API.G_FALSE

1587:
1588: AMS_ActCategory_PVT.Create_Act_Category (
1589: p_api_version => 1.0 -- p_api_version
1590: ,p_init_msg_list => FND_API.G_FALSE
1591: ,p_commit => FND_API.G_FALSE
1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1593: ,x_return_status => l_return_status
1594: ,x_msg_count => l_msg_count
1595: ,x_msg_data => l_msg_data

Line 1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1588: AMS_ActCategory_PVT.Create_Act_Category (
1589: p_api_version => 1.0 -- p_api_version
1590: ,p_init_msg_list => FND_API.G_FALSE
1591: ,p_commit => FND_API.G_FALSE
1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1593: ,x_return_status => l_return_status
1594: ,x_msg_count => l_msg_count
1595: ,x_msg_data => l_msg_data
1596:

Line 1597: ,p_PK => FND_API.G_TRUE

1593: ,x_return_status => l_return_status
1594: ,x_msg_count => l_msg_count
1595: ,x_msg_data => l_msg_data
1596:
1597: ,p_PK => FND_API.G_TRUE
1598: ,p_default => FND_API.G_TRUE
1599: ,p_Category_req_item_rec => l_act_category_req_item_rec
1600: ,p_Category_validate_item_rec => l_act_cty_validate_item_rec
1601: ,p_Category_default_item_rec => l_act_cty_default_item_rec

Line 1598: ,p_default => FND_API.G_TRUE

1594: ,x_msg_count => l_msg_count
1595: ,x_msg_data => l_msg_data
1596:
1597: ,p_PK => FND_API.G_TRUE
1598: ,p_default => FND_API.G_TRUE
1599: ,p_Category_req_item_rec => l_act_category_req_item_rec
1600: ,p_Category_validate_item_rec => l_act_cty_validate_item_rec
1601: ,p_Category_default_item_rec => l_act_cty_default_item_rec
1602: ,p_Category_validate_row_rec => l_act_cty_validate_row_rec

Line 1607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1603: ,p_category_rec => l_act_category_rec
1604: ,x_act_category_id => l_act_category_id
1605: );
1606:
1607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1608: THEN
1609: ELSE
1610: commit work;
1611: END IF;

Line 1646: ,p_init_msg_list => FND_API.G_FALSE

1642: -- Delete test case 1
1643: l_act_category_rec.activity_category_id := 1234;
1644: AMS_ActCategory_PVT.Delete_Act_Category (
1645: p_api_version => 1.0 -- p_api_version
1646: ,p_init_msg_list => FND_API.G_FALSE
1647: ,p_commit => FND_API.G_FALSE
1648: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1649: ,p_category_rec => l_act_category_rec
1650:

Line 1647: ,p_commit => FND_API.G_FALSE

1643: l_act_category_rec.activity_category_id := 1234;
1644: AMS_ActCategory_PVT.Delete_Act_Category (
1645: p_api_version => 1.0 -- p_api_version
1646: ,p_init_msg_list => FND_API.G_FALSE
1647: ,p_commit => FND_API.G_FALSE
1648: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1649: ,p_category_rec => l_act_category_rec
1650:
1651: ,x_return_status => l_return_status

Line 1648: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1644: AMS_ActCategory_PVT.Delete_Act_Category (
1645: p_api_version => 1.0 -- p_api_version
1646: ,p_init_msg_list => FND_API.G_FALSE
1647: ,p_commit => FND_API.G_FALSE
1648: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1649: ,p_category_rec => l_act_category_rec
1650:
1651: ,x_return_status => l_return_status
1652: ,x_msg_count => l_msg_count

Line 1656: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1652: ,x_msg_count => l_msg_count
1653: ,x_msg_data => l_msg_data
1654: );
1655:
1656: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1657: ELSE
1658: commit work;
1659: end if;
1660:

Line 1706: ,p_init_msg_list => FND_API.G_FALSE

1702: l_act_category_rec.ATTRIBUTE1 := 'ATTRIBUTE1 UPDATED1';
1703:
1704: AMS_ActCategory_PVT.Update_Act_Category (
1705: p_api_version => 1.0 -- p_api_version
1706: ,p_init_msg_list => FND_API.G_FALSE
1707: ,p_commit => FND_API.G_FALSE
1708: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1709: ,p_category_rec => l_act_category_rec
1710:

Line 1707: ,p_commit => FND_API.G_FALSE

1703:
1704: AMS_ActCategory_PVT.Update_Act_Category (
1705: p_api_version => 1.0 -- p_api_version
1706: ,p_init_msg_list => FND_API.G_FALSE
1707: ,p_commit => FND_API.G_FALSE
1708: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1709: ,p_category_rec => l_act_category_rec
1710:
1711: ,x_return_status => l_return_status

Line 1708: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1704: AMS_ActCategory_PVT.Update_Act_Category (
1705: p_api_version => 1.0 -- p_api_version
1706: ,p_init_msg_list => FND_API.G_FALSE
1707: ,p_commit => FND_API.G_FALSE
1708: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1709: ,p_category_rec => l_act_category_rec
1710:
1711: ,x_return_status => l_return_status
1712: ,x_msg_count => l_msg_count

Line 1716: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1712: ,x_msg_count => l_msg_count
1713: ,x_msg_data => l_msg_data
1714: );
1715:
1716: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1717: THEN
1718: ELSE
1719: commit work;
1720: END IF;

Line 1758: ,p_init_msg_list => FND_API.G_FALSE

1754: l_act_category_rec.activity_category_id := 1234;
1755:
1756: AMS_ActCategory_PVT.Lock_Act_Category (
1757: p_api_version => 1.0 -- p_api_version
1758: ,p_init_msg_list => FND_API.G_FALSE
1759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1760: ,p_category_rec => l_act_category_rec
1761:
1762: ,x_return_status => l_return_status

Line 1759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1755:
1756: AMS_ActCategory_PVT.Lock_Act_Category (
1757: p_api_version => 1.0 -- p_api_version
1758: ,p_init_msg_list => FND_API.G_FALSE
1759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1760: ,p_category_rec => l_act_category_rec
1761:
1762: ,x_return_status => l_return_status
1763: ,x_msg_count => l_msg_count

Line 1767: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1763: ,x_msg_count => l_msg_count
1764: ,x_msg_data => l_msg_data
1765: );
1766:
1767: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1768: THEN
1769: --RAISE FND_API.G_EXC_ERROR;
1770: END IF;
1771:

Line 1769: --RAISE FND_API.G_EXC_ERROR;

1765: );
1766:
1767: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1768: THEN
1769: --RAISE FND_API.G_EXC_ERROR;
1770: END IF;
1771:
1772:
1773: null;