APPS.WIP_EAMWORKORDER_PVT dependencies on FND_API

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

4: G_PKG_NAME CONSTANT VARCHAR2(30):='WIP_EAMWORKORDER_PVT';
5:
6: PROCEDURE Create_EAM_Work_Order
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,

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

5:
6: PROCEDURE Create_EAM_Work_Order
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,

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

6: PROCEDURE Create_EAM_Work_Order
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_work_order_rec IN work_order_interface_rec_type,

Line 76: IF NOT FND_API.Compatible_API_Call (l_api_version,

72:
73: -- Standard Start of API savepoint
74: SAVEPOINT Create_EAM_Work_Order_PVT;
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call (l_api_version,
77: p_api_version,
78: l_api_name,
79: G_PKG_NAME )
80: THEN

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: p_api_version,
78: l_api_name,
79: G_PKG_NAME )
80: THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;

Line 84: IF FND_API.to_Boolean( p_init_msg_list ) THEN

80: THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: -- API body
90:
91: -- EAM Specific Validation
92: IF (NVL(p_work_order_rec.load_type,7) <> 7) THEN

Line 95: RAISE FND_API.G_EXC_ERROR;

91: -- EAM Specific Validation
92: IF (NVL(p_work_order_rec.load_type,7) <> 7) THEN
93: FND_MESSAGE.SET_NAME('EAM','Incorrect Value of Load Type: '||p_work_order_rec.load_type);
94: FND_MSG_PUB.ADD();
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
98: /*
99: For maintenance_object_type, use the following criteria

Line 213: p_init_msg_list => FND_API.G_FALSE,

209: WHERE department_code = p_work_order_rec.owning_department_code and organization_id= p_work_order_rec.organization_id;
210: ELSE
211: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
212: ( p_api_version => 1.0,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => FND_API.G_FALSE,
215: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
216: x_return_status => l_def_return_status,
217: x_msg_count => l_def_msg_count,

Line 214: p_commit => FND_API.G_FALSE,

210: ELSE
211: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
212: ( p_api_version => 1.0,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => FND_API.G_FALSE,
215: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
216: x_return_status => l_def_return_status,
217: x_msg_count => l_def_msg_count,
218: x_msg_data => l_def_msg_data,

Line 215: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

211: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
212: ( p_api_version => 1.0,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => FND_API.G_FALSE,
215: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
216: x_return_status => l_def_return_status,
217: x_msg_count => l_def_msg_count,
218: x_msg_data => l_def_msg_data,
219: p_primary_item_id => l_eam_wo_rec.asset_activity_id,

Line 346: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then

342: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
343: 'work order API returned status: '|| l_return_status);
344: end if;
345:
346: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
347: fnd_message.set_name('EAM','EAM_CANNOT_CREAT_WRK');
348: fnd_msg_pub.add();
349: RAISE FND_API.G_EXC_ERROR;
350: end if ;

Line 349: RAISE FND_API.G_EXC_ERROR;

345:
346: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
347: fnd_message.set_name('EAM','EAM_CANNOT_CREAT_WRK');
348: fnd_msg_pub.add();
349: RAISE FND_API.G_EXC_ERROR;
350: end if ;
351:
352: IF FND_API.To_Boolean( p_commit ) THEN
353: COMMIT WORK;

Line 352: IF FND_API.To_Boolean( p_commit ) THEN

348: fnd_msg_pub.add();
349: RAISE FND_API.G_EXC_ERROR;
350: end if ;
351:
352: IF FND_API.To_Boolean( p_commit ) THEN
353: COMMIT WORK;
354: END IF;
355:
356: -- End of API body.

Line 363: WHEN FND_API.G_EXC_ERROR THEN

359: (p_count => x_msg_count,
360: p_data => x_msg_data
361: );
362: EXCEPTION
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO Create_EAM_Work_Order_PVT;
365: x_return_status := FND_API.G_RET_STS_ERROR ;
366: x_request_id := l_request_id;
367: FND_MSG_PUB.Count_And_Get

Line 365: x_return_status := FND_API.G_RET_STS_ERROR ;

361: );
362: EXCEPTION
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO Create_EAM_Work_Order_PVT;
365: x_return_status := FND_API.G_RET_STS_ERROR ;
366: x_request_id := l_request_id;
367: FND_MSG_PUB.Count_And_Get
368: (p_count => x_msg_count,
369: p_data => x_msg_data

Line 371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

367: FND_MSG_PUB.Count_And_Get
368: (p_count => x_msg_count,
369: p_data => x_msg_data
370: );
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: ROLLBACK TO Create_EAM_Work_Order_PVT;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: x_request_id := l_request_id;
375: FND_MSG_PUB.Count_And_Get

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

369: p_data => x_msg_data
370: );
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: ROLLBACK TO Create_EAM_Work_Order_PVT;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: x_request_id := l_request_id;
375: FND_MSG_PUB.Count_And_Get
376: (p_count => x_msg_count,
377: p_data => x_msg_data

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: p_data => x_msg_data
378: );
379: WHEN OTHERS THEN
380: ROLLBACK TO Create_EAM_Work_Order_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: x_request_id := l_request_id;
383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
384: THEN
385: FND_MSG_PUB.Add_Exc_Msg

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

400:
401:
402: PROCEDURE Get_EAM_Act_Cause_Default
403: ( p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_commit IN VARCHAR2 := FND_API.G_FALSE,
406: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,

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

401:
402: PROCEDURE Get_EAM_Act_Cause_Default
403: ( p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_commit IN VARCHAR2 := FND_API.G_FALSE,
406: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,
409: x_msg_data OUT NOCOPY VARCHAR2,

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

402: PROCEDURE Get_EAM_Act_Cause_Default
403: ( p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_commit IN VARCHAR2 := FND_API.G_FALSE,
406: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,
409: x_msg_data OUT NOCOPY VARCHAR2,
410: p_primary_item_id IN NUMBER,

Line 426: IF NOT FND_API.Compatible_API_Call (l_api_version,

422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT Get_EAM_Act_Cause_Default_PVT;
425: -- Standard call to check for call compatibility.
426: IF NOT FND_API.Compatible_API_Call (l_api_version,
427: p_api_version,
428: l_api_name,
429: G_PKG_NAME )
430: THEN

Line 431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

427: p_api_version,
428: l_api_name,
429: G_PKG_NAME )
430: THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
435: FND_MSG_PUB.initialize;

Line 434: IF FND_API.to_Boolean( p_init_msg_list ) THEN

430: THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437: -- Initialize API return status to success
438: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437: -- Initialize API return status to success
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: -- API body
440:
441: -- Find the Activity Cause from the Association Table
442: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 493: IF FND_API.To_Boolean( p_commit ) THEN

489:
490:
491: -- End of API body.
492: -- Standard check of p_commit.
493: IF FND_API.To_Boolean( p_commit ) THEN
494: COMMIT WORK;
495: END IF;
496: -- Standard call to get message count and if count is 1, get message info.
497: FND_MSG_PUB.Count_And_Get

Line 502: WHEN FND_API.G_EXC_ERROR THEN

498: (p_count => x_msg_count,
499: p_data => x_msg_data
500: );
501: EXCEPTION
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505:
506: FND_MSG_PUB.Count_And_Get

Line 504: x_return_status := FND_API.G_RET_STS_ERROR ;

500: );
501: EXCEPTION
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505:
506: FND_MSG_PUB.Count_And_Get
507: (p_count => x_msg_count,
508: p_data => x_msg_data

Line 510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

506: FND_MSG_PUB.Count_And_Get
507: (p_count => x_msg_count,
508: p_data => x_msg_data
509: );
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513:
514: FND_MSG_PUB.Count_And_Get

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

508: p_data => x_msg_data
509: );
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513:
514: FND_MSG_PUB.Count_And_Get
515: (p_count => x_msg_count,
516: p_data => x_msg_data

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

516: p_data => x_msg_data
517: );
518: WHEN OTHERS THEN
519: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521:
522: IF FND_MSG_PUB.Check_Msg_Level
523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
524: THEN

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

616:
617:
618: PROCEDURE Get_EAM_Act_Type_Default
619: ( p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: x_return_status OUT NOCOPY VARCHAR2,
624: x_msg_count OUT NOCOPY NUMBER,

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

617:
618: PROCEDURE Get_EAM_Act_Type_Default
619: ( p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: x_return_status OUT NOCOPY VARCHAR2,
624: x_msg_count OUT NOCOPY NUMBER,
625: x_msg_data OUT NOCOPY VARCHAR2,

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

618: PROCEDURE Get_EAM_Act_Type_Default
619: ( p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
621: p_commit IN VARCHAR2 := FND_API.G_FALSE,
622: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
623: x_return_status OUT NOCOPY VARCHAR2,
624: x_msg_count OUT NOCOPY NUMBER,
625: x_msg_data OUT NOCOPY VARCHAR2,
626: p_primary_item_id IN NUMBER,

Line 642: IF NOT FND_API.Compatible_API_Call (l_api_version,

638: BEGIN
639: -- Standard Start of API savepoint
640: SAVEPOINT Get_EAM_Act_Type_Default_PVT;
641: -- Standard call to check for call compatibility.
642: IF NOT FND_API.Compatible_API_Call (l_api_version,
643: p_api_version,
644: l_api_name,
645: G_PKG_NAME)
646: THEN

Line 647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

643: p_api_version,
644: l_api_name,
645: G_PKG_NAME)
646: THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
651: FND_MSG_PUB.initialize;

Line 650: IF FND_API.to_Boolean( p_init_msg_list ) THEN

646: THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653: -- Initialize API return status to success
654: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 654: x_return_status := FND_API.G_RET_STS_SUCCESS;

650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653: -- Initialize API return status to success
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655: -- API body
656:
657: -- Find the Activity type from the Association Table
658: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 708: IF FND_API.To_Boolean( p_commit ) THEN

704: END IF;
705:
706: -- End of API body.
707: -- Standard check of p_commit.
708: IF FND_API.To_Boolean( p_commit ) THEN
709: COMMIT WORK;
710: END IF;
711: -- Standard call to get message count and if count is 1, get message info.
712: FND_MSG_PUB.Count_And_Get

Line 717: WHEN FND_API.G_EXC_ERROR THEN

713: (p_count => x_msg_count,
714: p_data => x_msg_data
715: );
716: EXCEPTION
717: WHEN FND_API.G_EXC_ERROR THEN
718: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
719: x_return_status := FND_API.G_RET_STS_ERROR ;
720:
721: FND_MSG_PUB.Count_And_Get

Line 719: x_return_status := FND_API.G_RET_STS_ERROR ;

715: );
716: EXCEPTION
717: WHEN FND_API.G_EXC_ERROR THEN
718: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
719: x_return_status := FND_API.G_RET_STS_ERROR ;
720:
721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count,
723: p_data => x_msg_data

Line 725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count,
723: p_data => x_msg_data
724: );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728:
729: FND_MSG_PUB.Count_And_Get

Line 727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

723: p_data => x_msg_data
724: );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728:
729: FND_MSG_PUB.Count_And_Get
730: (p_count => x_msg_count,
731: p_data => x_msg_data

Line 735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

731: p_data => x_msg_data
732: );
733: WHEN OTHERS THEN
734: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
736:
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN

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

756:
757:
758: PROCEDURE Get_EAM_Act_Source_Default
759: ( p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763: x_return_status OUT NOCOPY VARCHAR2,
764: x_msg_count OUT NOCOPY NUMBER,

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

757:
758: PROCEDURE Get_EAM_Act_Source_Default
759: ( p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763: x_return_status OUT NOCOPY VARCHAR2,
764: x_msg_count OUT NOCOPY NUMBER,
765: x_msg_data OUT NOCOPY VARCHAR2,

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

758: PROCEDURE Get_EAM_Act_Source_Default
759: ( p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763: x_return_status OUT NOCOPY VARCHAR2,
764: x_msg_count OUT NOCOPY NUMBER,
765: x_msg_data OUT NOCOPY VARCHAR2,
766: p_primary_item_id IN NUMBER,

Line 782: IF NOT FND_API.Compatible_API_Call (l_api_version,

778: BEGIN
779: -- Standard Start of API savepoint
780: SAVEPOINT Get_EAM_Act_Source_Default_PVT;
781: -- Standard call to check for call compatibility.
782: IF NOT FND_API.Compatible_API_Call (l_api_version,
783: p_api_version,
784: l_api_name,
785: G_PKG_NAME)
786: THEN

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

783: p_api_version,
784: l_api_name,
785: G_PKG_NAME)
786: THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789: -- Initialize message list if p_init_msg_list is set to TRUE.
790: IF FND_API.to_Boolean( p_init_msg_list ) THEN
791: FND_MSG_PUB.initialize;

Line 790: IF FND_API.to_Boolean( p_init_msg_list ) THEN

786: THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789: -- Initialize message list if p_init_msg_list is set to TRUE.
790: IF FND_API.to_Boolean( p_init_msg_list ) THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793: -- Initialize API return status to success
794: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS;

790: IF FND_API.to_Boolean( p_init_msg_list ) THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793: -- Initialize API return status to success
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795: -- API body
796:
797: -- Find the Activity Source from the Association Table
798: IF (p_maintenance_object_type IN (1, 2) ) THEN -- 'MSN', 'MSI'

Line 848: IF FND_API.To_Boolean( p_commit ) THEN

844: END IF;
845:
846: -- End of API body.
847: -- Standard check of p_commit.
848: IF FND_API.To_Boolean( p_commit ) THEN
849: COMMIT WORK;
850: END IF;
851: -- Standard call to get message count and if count is 1, get message info.
852: FND_MSG_PUB.Count_And_Get

Line 857: WHEN FND_API.G_EXC_ERROR THEN

853: (p_count => x_msg_count,
854: p_data => x_msg_data
855: );
856: EXCEPTION
857: WHEN FND_API.G_EXC_ERROR THEN
858: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
859: x_return_status := FND_API.G_RET_STS_ERROR ;
860:
861: FND_MSG_PUB.Count_And_Get

Line 859: x_return_status := FND_API.G_RET_STS_ERROR ;

855: );
856: EXCEPTION
857: WHEN FND_API.G_EXC_ERROR THEN
858: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
859: x_return_status := FND_API.G_RET_STS_ERROR ;
860:
861: FND_MSG_PUB.Count_And_Get
862: (p_count => x_msg_count,
863: p_data => x_msg_data

Line 865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

861: FND_MSG_PUB.Count_And_Get
862: (p_count => x_msg_count,
863: p_data => x_msg_data
864: );
865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
866: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
868:
869: FND_MSG_PUB.Count_And_Get

Line 867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

863: p_data => x_msg_data
864: );
865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
866: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
868:
869: FND_MSG_PUB.Count_And_Get
870: (p_count => x_msg_count,
871: p_data => x_msg_data

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

871: p_data => x_msg_data
872: );
873: WHEN OTHERS THEN
874: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
876:
877: IF FND_MSG_PUB.Check_Msg_Level
878: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN

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

896:
897:
898: PROCEDURE Get_EAM_Shutdown_Default
899: ( p_api_version IN NUMBER,
900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
903: x_return_status OUT NOCOPY VARCHAR2,
904: x_msg_count OUT NOCOPY NUMBER,

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

897:
898: PROCEDURE Get_EAM_Shutdown_Default
899: ( p_api_version IN NUMBER,
900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
903: x_return_status OUT NOCOPY VARCHAR2,
904: x_msg_count OUT NOCOPY NUMBER,
905: x_msg_data OUT NOCOPY VARCHAR2,

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

898: PROCEDURE Get_EAM_Shutdown_Default
899: ( p_api_version IN NUMBER,
900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
903: x_return_status OUT NOCOPY VARCHAR2,
904: x_msg_count OUT NOCOPY NUMBER,
905: x_msg_data OUT NOCOPY VARCHAR2,
906: p_primary_item_id IN NUMBER,

Line 921: IF NOT FND_API.Compatible_API_Call (l_api_version,

917: BEGIN
918: -- Standard Start of API savepoint
919: SAVEPOINT Get_EAM_Shutdown_Default_PVT;
920: -- Standard call to check for call compatibility.
921: IF NOT FND_API.Compatible_API_Call (l_api_version,
922: p_api_version,
923: l_api_name,
924: G_PKG_NAME)
925: THEN

Line 926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

922: p_api_version,
923: l_api_name,
924: G_PKG_NAME)
925: THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928: -- Initialize message list if p_init_msg_list is set to TRUE.
929: IF FND_API.to_Boolean( p_init_msg_list ) THEN
930: FND_MSG_PUB.initialize;

Line 929: IF FND_API.to_Boolean( p_init_msg_list ) THEN

925: THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928: -- Initialize message list if p_init_msg_list is set to TRUE.
929: IF FND_API.to_Boolean( p_init_msg_list ) THEN
930: FND_MSG_PUB.initialize;
931: END IF;
932: -- Initialize API return status to success
933: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

929: IF FND_API.to_Boolean( p_init_msg_list ) THEN
930: FND_MSG_PUB.initialize;
931: END IF;
932: -- Initialize API return status to success
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934: -- API body
935:
936: -- Find the Shutdown Type from the Association Table
937: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 987: IF FND_API.To_Boolean( p_commit ) THEN

983: END IF;
984:
985: -- End of API body.
986: -- Standard check of p_commit.
987: IF FND_API.To_Boolean( p_commit ) THEN
988: COMMIT WORK;
989: END IF;
990: -- Standard call to get message count and if count is 1, get message info.
991: FND_MSG_PUB.Count_And_Get

Line 996: WHEN FND_API.G_EXC_ERROR THEN

992: (p_count => x_msg_count,
993: p_data => x_msg_data
994: );
995: EXCEPTION
996: WHEN FND_API.G_EXC_ERROR THEN
997: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
998: x_return_status := FND_API.G_RET_STS_ERROR ;
999:
1000: FND_MSG_PUB.Count_And_Get

Line 998: x_return_status := FND_API.G_RET_STS_ERROR ;

994: );
995: EXCEPTION
996: WHEN FND_API.G_EXC_ERROR THEN
997: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
998: x_return_status := FND_API.G_RET_STS_ERROR ;
999:
1000: FND_MSG_PUB.Count_And_Get
1001: (p_count => x_msg_count,
1002: p_data => x_msg_data

Line 1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1000: FND_MSG_PUB.Count_And_Get
1001: (p_count => x_msg_count,
1002: p_data => x_msg_data
1003: );
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1007:
1008: FND_MSG_PUB.Count_And_Get

Line 1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1002: p_data => x_msg_data
1003: );
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1007:
1008: FND_MSG_PUB.Count_And_Get
1009: (p_count => x_msg_count,
1010: p_data => x_msg_data

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1010: p_data => x_msg_data
1011: );
1012: WHEN OTHERS THEN
1013: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015:
1016: IF FND_MSG_PUB.Check_Msg_Level
1017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN

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

1035:
1036:
1037: PROCEDURE Get_EAM_Notification_Default
1038: ( p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1040: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,

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

1036:
1037: PROCEDURE Get_EAM_Notification_Default
1038: ( p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1040: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,

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

1037: PROCEDURE Get_EAM_Notification_Default
1038: ( p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1040: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,
1045: p_primary_item_id IN NUMBER,

Line 1061: IF NOT FND_API.Compatible_API_Call (l_api_version,

1057: BEGIN
1058: -- Standard Start of API savepoint
1059: SAVEPOINT Get_EAM_Notification_Def_PVT;
1060: -- Standard call to check for call compatibility.
1061: IF NOT FND_API.Compatible_API_Call (l_api_version,
1062: p_api_version,
1063: l_api_name,
1064: G_PKG_NAME)
1065: THEN

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: p_api_version,
1063: l_api_name,
1064: G_PKG_NAME)
1065: THEN
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;
1068: -- Initialize message list if p_init_msg_list is set to TRUE.
1069: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1070: FND_MSG_PUB.initialize;

Line 1069: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1065: THEN
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;
1068: -- Initialize message list if p_init_msg_list is set to TRUE.
1069: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1070: FND_MSG_PUB.initialize;
1071: END IF;
1072: -- Initialize API return status to success
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1073: x_return_status := FND_API.G_RET_STS_SUCCESS;

1069: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1070: FND_MSG_PUB.initialize;
1071: END IF;
1072: -- Initialize API return status to success
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;
1074: -- API body
1075: /*
1076: -- Find the Shutdown Type from the Association Table
1077: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 1127: IF FND_API.To_Boolean( p_commit ) THEN

1123: END IF;
1124:
1125: -- End of API body.
1126: -- Standard check of p_commit.
1127: IF FND_API.To_Boolean( p_commit ) THEN
1128: COMMIT WORK;
1129: END IF;
1130: -- Standard call to get message count and if count is 1, get message info.
1131: FND_MSG_PUB.Count_And_Get

Line 1136: WHEN FND_API.G_EXC_ERROR THEN

1132: (p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139:
1140: FND_MSG_PUB.Count_And_Get

Line 1138: x_return_status := FND_API.G_RET_STS_ERROR ;

1134: );
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139:
1140: FND_MSG_PUB.Count_And_Get
1141: (p_count => x_msg_count,
1142: p_data => x_msg_data

Line 1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1140: FND_MSG_PUB.Count_And_Get
1141: (p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147:
1148: FND_MSG_PUB.Count_And_Get

Line 1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1142: p_data => x_msg_data
1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147:
1148: FND_MSG_PUB.Count_And_Get
1149: (p_count => x_msg_count,
1150: p_data => x_msg_data

Line 1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1150: p_data => x_msg_data
1151: );
1152: WHEN OTHERS THEN
1153: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1155:
1156: IF FND_MSG_PUB.Check_Msg_Level
1157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1158: THEN

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

1175:
1176:
1177: PROCEDURE Get_EAM_Tagout_Default
1178: ( p_api_version IN NUMBER,
1179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,

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

1176:
1177: PROCEDURE Get_EAM_Tagout_Default
1178: ( p_api_version IN NUMBER,
1179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,
1184: x_msg_data OUT NOCOPY VARCHAR2,

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

1177: PROCEDURE Get_EAM_Tagout_Default
1178: ( p_api_version IN NUMBER,
1179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,
1184: x_msg_data OUT NOCOPY VARCHAR2,
1185: p_primary_item_id IN NUMBER,

Line 1201: IF NOT FND_API.Compatible_API_Call (l_api_version,

1197: BEGIN
1198: -- Standard Start of API savepoint
1199: SAVEPOINT Get_EAM_Tagout_Default_PVT;
1200: -- Standard call to check for call compatibility.
1201: IF NOT FND_API.Compatible_API_Call (l_api_version,
1202: p_api_version,
1203: l_api_name,
1204: G_PKG_NAME)
1205: THEN

Line 1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1202: p_api_version,
1203: l_api_name,
1204: G_PKG_NAME)
1205: THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208: -- Initialize message list if p_init_msg_list is set to TRUE.
1209: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1210: FND_MSG_PUB.initialize;

Line 1209: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1205: THEN
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208: -- Initialize message list if p_init_msg_list is set to TRUE.
1209: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1210: FND_MSG_PUB.initialize;
1211: END IF;
1212: -- Initialize API return status to success
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1210: FND_MSG_PUB.initialize;
1211: END IF;
1212: -- Initialize API return status to success
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214: -- API body
1215:
1216: -- Find the Shutdown Type from the Association Table
1217: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 1251: IF FND_API.To_Boolean( p_commit ) THEN

1247: END IF;
1248:
1249: -- End of API body.
1250: -- Standard check of p_commit.
1251: IF FND_API.To_Boolean( p_commit ) THEN
1252: COMMIT WORK;
1253: END IF;
1254: -- Standard call to get message count and if count is 1, get message info.
1255: FND_MSG_PUB.Count_And_Get

Line 1260: WHEN FND_API.G_EXC_ERROR THEN

1256: (p_count => x_msg_count,
1257: p_data => x_msg_data
1258: );
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263:
1264: FND_MSG_PUB.Count_And_Get

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR ;

1258: );
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263:
1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count,
1266: p_data => x_msg_data

Line 1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271:
1272: FND_MSG_PUB.Count_And_Get

Line 1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1266: p_data => x_msg_data
1267: );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271:
1272: FND_MSG_PUB.Count_And_Get
1273: (p_count => x_msg_count,
1274: p_data => x_msg_data

Line 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1274: p_data => x_msg_data
1275: );
1276: WHEN OTHERS THEN
1277: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279:
1280: IF FND_MSG_PUB.Check_Msg_Level
1281: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1282: THEN

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

1300:
1301:
1302: PROCEDURE Get_EAM_Owning_Dept_Default
1303: ( p_api_version IN NUMBER,
1304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1305: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1306: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1307: x_return_status OUT NOCOPY VARCHAR2,
1308: x_msg_count OUT NOCOPY NUMBER,

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

1301:
1302: PROCEDURE Get_EAM_Owning_Dept_Default
1303: ( p_api_version IN NUMBER,
1304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1305: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1306: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1307: x_return_status OUT NOCOPY VARCHAR2,
1308: x_msg_count OUT NOCOPY NUMBER,
1309: x_msg_data OUT NOCOPY VARCHAR2,

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

1302: PROCEDURE Get_EAM_Owning_Dept_Default
1303: ( p_api_version IN NUMBER,
1304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1305: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1306: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1307: x_return_status OUT NOCOPY VARCHAR2,
1308: x_msg_count OUT NOCOPY NUMBER,
1309: x_msg_data OUT NOCOPY VARCHAR2,
1310: p_primary_item_id IN NUMBER,

Line 1326: IF NOT FND_API.Compatible_API_Call (l_api_version,

1322: BEGIN
1323: -- Standard Start of API savepoint
1324: SAVEPOINT Get_EAM_Owning_Dept_Def_PVT;
1325: -- Standard call to check for call compatibility.
1326: IF NOT FND_API.Compatible_API_Call (l_api_version,
1327: p_api_version,
1328: l_api_name,
1329: G_PKG_NAME)
1330: THEN

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327: p_api_version,
1328: l_api_name,
1329: G_PKG_NAME)
1330: THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: -- Initialize message list if p_init_msg_list is set to TRUE.
1334: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1335: FND_MSG_PUB.initialize;

Line 1334: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1330: THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: -- Initialize message list if p_init_msg_list is set to TRUE.
1334: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1335: FND_MSG_PUB.initialize;
1336: END IF;
1337: -- Initialize API return status to success
1338: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1338: x_return_status := FND_API.G_RET_STS_SUCCESS;

1334: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1335: FND_MSG_PUB.initialize;
1336: END IF;
1337: -- Initialize API return status to success
1338: x_return_status := FND_API.G_RET_STS_SUCCESS;
1339: -- API body
1340:
1341: -- Find the Shutdown Type from the Association Table
1342: IF (p_maintenance_object_type = 1 ) THEN -- 'MSN', 'MSI'

Line 1414: IF FND_API.To_Boolean( p_commit ) THEN

1410: END IF;
1411:
1412: -- End of API body.
1413: -- Standard check of p_commit.
1414: IF FND_API.To_Boolean( p_commit ) THEN
1415: COMMIT WORK;
1416: END IF;
1417: -- Standard call to get message count and if count is 1, get message info.
1418: FND_MSG_PUB.Count_And_Get

Line 1423: WHEN FND_API.G_EXC_ERROR THEN

1419: (p_count => x_msg_count,
1420: p_data => x_msg_data
1421: );
1422: EXCEPTION
1423: WHEN FND_API.G_EXC_ERROR THEN
1424: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1425: x_return_status := FND_API.G_RET_STS_ERROR ;
1426:
1427: FND_MSG_PUB.Count_And_Get

Line 1425: x_return_status := FND_API.G_RET_STS_ERROR ;

1421: );
1422: EXCEPTION
1423: WHEN FND_API.G_EXC_ERROR THEN
1424: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1425: x_return_status := FND_API.G_RET_STS_ERROR ;
1426:
1427: FND_MSG_PUB.Count_And_Get
1428: (p_count => x_msg_count,
1429: p_data => x_msg_data

Line 1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1427: FND_MSG_PUB.Count_And_Get
1428: (p_count => x_msg_count,
1429: p_data => x_msg_data
1430: );
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434:
1435: FND_MSG_PUB.Count_And_Get

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1429: p_data => x_msg_data
1430: );
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434:
1435: FND_MSG_PUB.Count_And_Get
1436: (p_count => x_msg_count,
1437: p_data => x_msg_data

Line 1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1437: p_data => x_msg_data
1438: );
1439: WHEN OTHERS THEN
1440: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1442:
1443: IF FND_MSG_PUB.Check_Msg_Level
1444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1445: THEN