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.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 79: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 87: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 98: RAISE FND_API.G_EXC_ERROR;

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

Line 256: p_init_msg_list => FND_API.G_FALSE,

252: WHERE department_code = p_work_order_rec.owning_department_code and organization_id= p_work_order_rec.organization_id;
253: ELSE
254: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
255: ( p_api_version => 1.0,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
259: x_return_status => l_def_return_status,
260: x_msg_count => l_def_msg_count,

Line 257: p_commit => FND_API.G_FALSE,

253: ELSE
254: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
255: ( p_api_version => 1.0,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
259: x_return_status => l_def_return_status,
260: x_msg_count => l_def_msg_count,
261: x_msg_data => l_def_msg_data,

Line 258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

254: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
255: ( p_api_version => 1.0,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
259: x_return_status => l_def_return_status,
260: x_msg_count => l_def_msg_count,
261: x_msg_data => l_def_msg_data,
262: p_primary_item_id => l_eam_wo_rec.asset_activity_id,

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

385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
386: 'work order API returned status: '|| l_return_status);
387: end if;
388:
389: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
390: fnd_message.set_name('EAM','EAM_CANNOT_CREAT_WRK');
391: fnd_msg_pub.add();
392: RAISE FND_API.G_EXC_ERROR;
393: end if ;

Line 392: RAISE FND_API.G_EXC_ERROR;

388:
389: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
390: fnd_message.set_name('EAM','EAM_CANNOT_CREAT_WRK');
391: fnd_msg_pub.add();
392: RAISE FND_API.G_EXC_ERROR;
393: end if ;
394:
395: IF FND_API.To_Boolean( p_commit ) THEN
396: COMMIT WORK;

Line 395: IF FND_API.To_Boolean( p_commit ) THEN

391: fnd_msg_pub.add();
392: RAISE FND_API.G_EXC_ERROR;
393: end if ;
394:
395: IF FND_API.To_Boolean( p_commit ) THEN
396: COMMIT WORK;
397: END IF;
398:
399: -- End of API body.

Line 406: WHEN FND_API.G_EXC_ERROR THEN

402: (p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO Create_EAM_Work_Order_PVT;
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: x_request_id := l_request_id;
410: FND_MSG_PUB.Count_And_Get

Line 408: x_return_status := FND_API.G_RET_STS_ERROR ;

404: );
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO Create_EAM_Work_Order_PVT;
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: x_request_id := l_request_id;
410: FND_MSG_PUB.Count_And_Get
411: (p_count => x_msg_count,
412: p_data => x_msg_data

Line 414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

410: FND_MSG_PUB.Count_And_Get
411: (p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: ROLLBACK TO Create_EAM_Work_Order_PVT;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: x_request_id := l_request_id;
418: FND_MSG_PUB.Count_And_Get

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

412: p_data => x_msg_data
413: );
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: ROLLBACK TO Create_EAM_Work_Order_PVT;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: x_request_id := l_request_id;
418: FND_MSG_PUB.Count_And_Get
419: (p_count => x_msg_count,
420: p_data => x_msg_data

Line 424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

420: p_data => x_msg_data
421: );
422: WHEN OTHERS THEN
423: ROLLBACK TO Create_EAM_Work_Order_PVT;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425: x_request_id := l_request_id;
426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg

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

443:
444:
445: PROCEDURE Get_EAM_Act_Cause_Default
446: ( p_api_version IN NUMBER,
447: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
448: p_commit IN VARCHAR2 := FND_API.G_FALSE,
449: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,

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

444:
445: PROCEDURE Get_EAM_Act_Cause_Default
446: ( p_api_version IN NUMBER,
447: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
448: p_commit IN VARCHAR2 := FND_API.G_FALSE,
449: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,

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

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

Line 469: IF NOT FND_API.Compatible_API_Call (l_api_version,

465: BEGIN
466: -- Standard Start of API savepoint
467: SAVEPOINT Get_EAM_Act_Cause_Default_PVT;
468: -- Standard call to check for call compatibility.
469: IF NOT FND_API.Compatible_API_Call (l_api_version,
470: p_api_version,
471: l_api_name,
472: G_PKG_NAME )
473: THEN

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: p_api_version,
471: l_api_name,
472: G_PKG_NAME )
473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list ) THEN
478: FND_MSG_PUB.initialize;

Line 477: IF FND_API.to_Boolean( p_init_msg_list ) THEN

473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list ) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480: -- Initialize API return status to success
481: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: IF FND_API.to_Boolean( p_init_msg_list ) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480: -- Initialize API return status to success
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482: -- API body
483:
484: -- Find the Activity Cause from the Association Table
485: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 547: IF FND_API.To_Boolean( p_commit ) THEN

543:
544:
545: -- End of API body.
546: -- Standard check of p_commit.
547: IF FND_API.To_Boolean( p_commit ) THEN
548: COMMIT WORK;
549: END IF;
550: -- Standard call to get message count and if count is 1, get message info.
551: FND_MSG_PUB.Count_And_Get

Line 556: WHEN FND_API.G_EXC_ERROR THEN

552: (p_count => x_msg_count,
553: p_data => x_msg_data
554: );
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559:
560: FND_MSG_PUB.Count_And_Get

Line 558: x_return_status := FND_API.G_RET_STS_ERROR ;

554: );
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559:
560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data
563: );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567:
568: FND_MSG_PUB.Count_And_Get

Line 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

562: p_data => x_msg_data
563: );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567:
568: FND_MSG_PUB.Count_And_Get
569: (p_count => x_msg_count,
570: p_data => x_msg_data

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

570: p_data => x_msg_data
571: );
572: WHEN OTHERS THEN
573: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575:
576: IF FND_MSG_PUB.Check_Msg_Level
577: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
578: THEN

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

670:
671:
672: PROCEDURE Get_EAM_Act_Type_Default
673: ( p_api_version IN NUMBER,
674: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
675: p_commit IN VARCHAR2 := FND_API.G_FALSE,
676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
677: x_return_status OUT NOCOPY VARCHAR2,
678: x_msg_count OUT NOCOPY NUMBER,

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

671:
672: PROCEDURE Get_EAM_Act_Type_Default
673: ( p_api_version IN NUMBER,
674: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
675: p_commit IN VARCHAR2 := FND_API.G_FALSE,
676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
677: x_return_status OUT NOCOPY VARCHAR2,
678: x_msg_count OUT NOCOPY NUMBER,
679: x_msg_data OUT NOCOPY VARCHAR2,

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

672: PROCEDURE Get_EAM_Act_Type_Default
673: ( p_api_version IN NUMBER,
674: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
675: p_commit IN VARCHAR2 := FND_API.G_FALSE,
676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
677: x_return_status OUT NOCOPY VARCHAR2,
678: x_msg_count OUT NOCOPY NUMBER,
679: x_msg_data OUT NOCOPY VARCHAR2,
680: p_primary_item_id IN NUMBER,

Line 696: IF NOT FND_API.Compatible_API_Call (l_api_version,

692: BEGIN
693: -- Standard Start of API savepoint
694: SAVEPOINT Get_EAM_Act_Type_Default_PVT;
695: -- Standard call to check for call compatibility.
696: IF NOT FND_API.Compatible_API_Call (l_api_version,
697: p_api_version,
698: l_api_name,
699: G_PKG_NAME)
700: THEN

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: p_api_version,
698: l_api_name,
699: G_PKG_NAME)
700: THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;

Line 704: IF FND_API.to_Boolean( p_init_msg_list ) THEN

700: THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: -- API body
710:
711: -- Find the Activity type from the Association Table
712: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 773: IF FND_API.To_Boolean( p_commit ) THEN

769: END IF;
770:
771: -- End of API body.
772: -- Standard check of p_commit.
773: IF FND_API.To_Boolean( p_commit ) THEN
774: COMMIT WORK;
775: END IF;
776: -- Standard call to get message count and if count is 1, get message info.
777: FND_MSG_PUB.Count_And_Get

Line 782: WHEN FND_API.G_EXC_ERROR THEN

778: (p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781: EXCEPTION
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR ;
785:
786: FND_MSG_PUB.Count_And_Get

Line 784: x_return_status := FND_API.G_RET_STS_ERROR ;

780: );
781: EXCEPTION
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR ;
785:
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count,
788: p_data => x_msg_data

Line 790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
793:
794: FND_MSG_PUB.Count_And_Get

Line 792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

788: p_data => x_msg_data
789: );
790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
793:
794: FND_MSG_PUB.Count_And_Get
795: (p_count => x_msg_count,
796: p_data => x_msg_data

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

796: p_data => x_msg_data
797: );
798: WHEN OTHERS THEN
799: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801:
802: IF FND_MSG_PUB.Check_Msg_Level
803: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN

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

821:
822:
823: PROCEDURE Get_EAM_Act_Source_Default
824: ( p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
826: p_commit IN VARCHAR2 := FND_API.G_FALSE,
827: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
828: x_return_status OUT NOCOPY VARCHAR2,
829: x_msg_count OUT NOCOPY NUMBER,

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

822:
823: PROCEDURE Get_EAM_Act_Source_Default
824: ( p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
826: p_commit IN VARCHAR2 := FND_API.G_FALSE,
827: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
828: x_return_status OUT NOCOPY VARCHAR2,
829: x_msg_count OUT NOCOPY NUMBER,
830: x_msg_data OUT NOCOPY VARCHAR2,

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

823: PROCEDURE Get_EAM_Act_Source_Default
824: ( p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
826: p_commit IN VARCHAR2 := FND_API.G_FALSE,
827: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
828: x_return_status OUT NOCOPY VARCHAR2,
829: x_msg_count OUT NOCOPY NUMBER,
830: x_msg_data OUT NOCOPY VARCHAR2,
831: p_primary_item_id IN NUMBER,

Line 847: IF NOT FND_API.Compatible_API_Call (l_api_version,

843: BEGIN
844: -- Standard Start of API savepoint
845: SAVEPOINT Get_EAM_Act_Source_Default_PVT;
846: -- Standard call to check for call compatibility.
847: IF NOT FND_API.Compatible_API_Call (l_api_version,
848: p_api_version,
849: l_api_name,
850: G_PKG_NAME)
851: THEN

Line 852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

848: p_api_version,
849: l_api_name,
850: G_PKG_NAME)
851: THEN
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF FND_API.to_Boolean( p_init_msg_list ) THEN
856: FND_MSG_PUB.initialize;

Line 855: IF FND_API.to_Boolean( p_init_msg_list ) THEN

851: THEN
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF FND_API.to_Boolean( p_init_msg_list ) THEN
856: FND_MSG_PUB.initialize;
857: END IF;
858: -- Initialize API return status to success
859: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 859: x_return_status := FND_API.G_RET_STS_SUCCESS;

855: IF FND_API.to_Boolean( p_init_msg_list ) THEN
856: FND_MSG_PUB.initialize;
857: END IF;
858: -- Initialize API return status to success
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860: -- API body
861:
862: -- Find the Activity Source from the Association Table
863: IF (p_maintenance_object_type IN (1, 2) ) THEN -- 'MSN', 'MSI'

Line 924: IF FND_API.To_Boolean( p_commit ) THEN

920: END IF;
921:
922: -- End of API body.
923: -- Standard check of p_commit.
924: IF FND_API.To_Boolean( p_commit ) THEN
925: COMMIT WORK;
926: END IF;
927: -- Standard call to get message count and if count is 1, get message info.
928: FND_MSG_PUB.Count_And_Get

Line 933: WHEN FND_API.G_EXC_ERROR THEN

929: (p_count => x_msg_count,
930: p_data => x_msg_data
931: );
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936:
937: FND_MSG_PUB.Count_And_Get

Line 935: x_return_status := FND_API.G_RET_STS_ERROR ;

931: );
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936:
937: FND_MSG_PUB.Count_And_Get
938: (p_count => x_msg_count,
939: p_data => x_msg_data

Line 941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

937: FND_MSG_PUB.Count_And_Get
938: (p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
942: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
944:
945: FND_MSG_PUB.Count_And_Get

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

939: p_data => x_msg_data
940: );
941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
942: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
944:
945: FND_MSG_PUB.Count_And_Get
946: (p_count => x_msg_count,
947: p_data => x_msg_data

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

947: p_data => x_msg_data
948: );
949: WHEN OTHERS THEN
950: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952:
953: IF FND_MSG_PUB.Check_Msg_Level
954: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
955: THEN

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

972:
973:
974: PROCEDURE Get_EAM_Shutdown_Default
975: ( p_api_version IN NUMBER,
976: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
977: p_commit IN VARCHAR2 := FND_API.G_FALSE,
978: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,

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

973:
974: PROCEDURE Get_EAM_Shutdown_Default
975: ( p_api_version IN NUMBER,
976: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
977: p_commit IN VARCHAR2 := FND_API.G_FALSE,
978: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,
981: x_msg_data OUT NOCOPY VARCHAR2,

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

974: PROCEDURE Get_EAM_Shutdown_Default
975: ( p_api_version IN NUMBER,
976: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
977: p_commit IN VARCHAR2 := FND_API.G_FALSE,
978: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,
981: x_msg_data OUT NOCOPY VARCHAR2,
982: p_primary_item_id IN NUMBER,

Line 997: IF NOT FND_API.Compatible_API_Call (l_api_version,

993: BEGIN
994: -- Standard Start of API savepoint
995: SAVEPOINT Get_EAM_Shutdown_Default_PVT;
996: -- Standard call to check for call compatibility.
997: IF NOT FND_API.Compatible_API_Call (l_api_version,
998: p_api_version,
999: l_api_name,
1000: G_PKG_NAME)
1001: THEN

Line 1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

998: p_api_version,
999: l_api_name,
1000: G_PKG_NAME)
1001: THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: -- Initialize message list if p_init_msg_list is set to TRUE.
1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1006: FND_MSG_PUB.initialize;

Line 1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1001: THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: -- Initialize message list if p_init_msg_list is set to TRUE.
1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008: -- Initialize API return status to success
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008: -- Initialize API return status to success
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: -- API body
1011:
1012: -- Find the Shutdown Type from the Association Table
1013: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 1076: IF FND_API.To_Boolean( p_commit ) THEN

1072: END IF;
1073:
1074: -- End of API body.
1075: -- Standard check of p_commit.
1076: IF FND_API.To_Boolean( p_commit ) THEN
1077: COMMIT WORK;
1078: END IF;
1079: -- Standard call to get message count and if count is 1, get message info.
1080: FND_MSG_PUB.Count_And_Get

Line 1085: WHEN FND_API.G_EXC_ERROR THEN

1081: (p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1087: x_return_status := FND_API.G_RET_STS_ERROR ;
1088:
1089: FND_MSG_PUB.Count_And_Get

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR ;

1083: );
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1087: x_return_status := FND_API.G_RET_STS_ERROR ;
1088:
1089: FND_MSG_PUB.Count_And_Get
1090: (p_count => x_msg_count,
1091: p_data => x_msg_data

Line 1093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1089: FND_MSG_PUB.Count_And_Get
1090: (p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1094: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096:
1097: FND_MSG_PUB.Count_And_Get

Line 1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1091: p_data => x_msg_data
1092: );
1093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1094: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096:
1097: FND_MSG_PUB.Count_And_Get
1098: (p_count => x_msg_count,
1099: p_data => x_msg_data

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1099: p_data => x_msg_data
1100: );
1101: WHEN OTHERS THEN
1102: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN

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

1124:
1125:
1126: PROCEDURE Get_EAM_Notification_Default
1127: ( p_api_version IN NUMBER,
1128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1129: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1130: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1131: x_return_status OUT NOCOPY VARCHAR2,
1132: x_msg_count OUT NOCOPY NUMBER,

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

1125:
1126: PROCEDURE Get_EAM_Notification_Default
1127: ( p_api_version IN NUMBER,
1128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1129: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1130: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1131: x_return_status OUT NOCOPY VARCHAR2,
1132: x_msg_count OUT NOCOPY NUMBER,
1133: x_msg_data OUT NOCOPY VARCHAR2,

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

1126: PROCEDURE Get_EAM_Notification_Default
1127: ( p_api_version IN NUMBER,
1128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1129: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1130: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1131: x_return_status OUT NOCOPY VARCHAR2,
1132: x_msg_count OUT NOCOPY NUMBER,
1133: x_msg_data OUT NOCOPY VARCHAR2,
1134: p_primary_item_id IN NUMBER,

Line 1150: IF NOT FND_API.Compatible_API_Call (l_api_version,

1146: BEGIN
1147: -- Standard Start of API savepoint
1148: SAVEPOINT Get_EAM_Notification_Def_PVT;
1149: -- Standard call to check for call compatibility.
1150: IF NOT FND_API.Compatible_API_Call (l_api_version,
1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME)
1154: THEN

Line 1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME)
1154: THEN
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END IF;
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;

Line 1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1154: THEN
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END IF;
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161: -- Initialize API return status to success
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161: -- Initialize API return status to success
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163: -- API body
1164: /*
1165: -- Find the Shutdown Type from the Association Table
1166: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 1234: IF FND_API.To_Boolean( p_commit ) THEN

1230: END IF;
1231:
1232: -- End of API body.
1233: -- Standard check of p_commit.
1234: IF FND_API.To_Boolean( p_commit ) THEN
1235: COMMIT WORK;
1236: END IF;
1237: -- Standard call to get message count and if count is 1, get message info.
1238: FND_MSG_PUB.Count_And_Get

Line 1243: WHEN FND_API.G_EXC_ERROR THEN

1239: (p_count => x_msg_count,
1240: p_data => x_msg_data
1241: );
1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1245: x_return_status := FND_API.G_RET_STS_ERROR ;
1246:
1247: FND_MSG_PUB.Count_And_Get

Line 1245: x_return_status := FND_API.G_RET_STS_ERROR ;

1241: );
1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1245: x_return_status := FND_API.G_RET_STS_ERROR ;
1246:
1247: FND_MSG_PUB.Count_And_Get
1248: (p_count => x_msg_count,
1249: p_data => x_msg_data

Line 1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1247: FND_MSG_PUB.Count_And_Get
1248: (p_count => x_msg_count,
1249: p_data => x_msg_data
1250: );
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1254:
1255: FND_MSG_PUB.Count_And_Get

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1249: p_data => x_msg_data
1250: );
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1254:
1255: FND_MSG_PUB.Count_And_Get
1256: (p_count => x_msg_count,
1257: p_data => x_msg_data

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1257: p_data => x_msg_data
1258: );
1259: WHEN OTHERS THEN
1260: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1262:
1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN

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

1282:
1283:
1284: PROCEDURE Get_EAM_Tagout_Default
1285: ( p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1289: x_return_status OUT NOCOPY VARCHAR2,
1290: x_msg_count OUT NOCOPY NUMBER,

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

1283:
1284: PROCEDURE Get_EAM_Tagout_Default
1285: ( p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1289: x_return_status OUT NOCOPY VARCHAR2,
1290: x_msg_count OUT NOCOPY NUMBER,
1291: x_msg_data OUT NOCOPY VARCHAR2,

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

1284: PROCEDURE Get_EAM_Tagout_Default
1285: ( p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1289: x_return_status OUT NOCOPY VARCHAR2,
1290: x_msg_count OUT NOCOPY NUMBER,
1291: x_msg_data OUT NOCOPY VARCHAR2,
1292: p_primary_item_id IN NUMBER,

Line 1308: IF NOT FND_API.Compatible_API_Call (l_api_version,

1304: BEGIN
1305: -- Standard Start of API savepoint
1306: SAVEPOINT Get_EAM_Tagout_Default_PVT;
1307: -- Standard call to check for call compatibility.
1308: IF NOT FND_API.Compatible_API_Call (l_api_version,
1309: p_api_version,
1310: l_api_name,
1311: G_PKG_NAME)
1312: THEN

Line 1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1309: p_api_version,
1310: l_api_name,
1311: G_PKG_NAME)
1312: THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315: -- Initialize message list if p_init_msg_list is set to TRUE.
1316: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1317: FND_MSG_PUB.initialize;

Line 1316: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1312: THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315: -- Initialize message list if p_init_msg_list is set to TRUE.
1316: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1317: FND_MSG_PUB.initialize;
1318: END IF;
1319: -- Initialize API return status to success
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

1316: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1317: FND_MSG_PUB.initialize;
1318: END IF;
1319: -- Initialize API return status to success
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321: -- API body
1322:
1323: -- Find the Shutdown Type from the Association Table
1324: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'

Line 1371: IF FND_API.To_Boolean( p_commit ) THEN

1367: END IF;
1368:
1369: -- End of API body.
1370: -- Standard check of p_commit.
1371: IF FND_API.To_Boolean( p_commit ) THEN
1372: COMMIT WORK;
1373: END IF;
1374: -- Standard call to get message count and if count is 1, get message info.
1375: FND_MSG_PUB.Count_And_Get

Line 1380: WHEN FND_API.G_EXC_ERROR THEN

1376: (p_count => x_msg_count,
1377: p_data => x_msg_data
1378: );
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1382: x_return_status := FND_API.G_RET_STS_ERROR ;
1383:
1384: FND_MSG_PUB.Count_And_Get

Line 1382: x_return_status := FND_API.G_RET_STS_ERROR ;

1378: );
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1382: x_return_status := FND_API.G_RET_STS_ERROR ;
1383:
1384: FND_MSG_PUB.Count_And_Get
1385: (p_count => x_msg_count,
1386: p_data => x_msg_data

Line 1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1384: FND_MSG_PUB.Count_And_Get
1385: (p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1391:
1392: FND_MSG_PUB.Count_And_Get

Line 1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1386: p_data => x_msg_data
1387: );
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1391:
1392: FND_MSG_PUB.Count_And_Get
1393: (p_count => x_msg_count,
1394: p_data => x_msg_data

Line 1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1394: p_data => x_msg_data
1395: );
1396: WHEN OTHERS THEN
1397: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1399:
1400: IF FND_MSG_PUB.Check_Msg_Level
1401: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN

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

1420:
1421:
1422: PROCEDURE Get_EAM_Owning_Dept_Default
1423: ( p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,

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

1421:
1422: PROCEDURE Get_EAM_Owning_Dept_Default
1423: ( p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,
1429: x_msg_data OUT NOCOPY VARCHAR2,

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

1422: PROCEDURE Get_EAM_Owning_Dept_Default
1423: ( p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,
1429: x_msg_data OUT NOCOPY VARCHAR2,
1430: p_primary_item_id IN NUMBER,

Line 1446: IF NOT FND_API.Compatible_API_Call (l_api_version,

1442: BEGIN
1443: -- Standard Start of API savepoint
1444: SAVEPOINT Get_EAM_Owning_Dept_Def_PVT;
1445: -- Standard call to check for call compatibility.
1446: IF NOT FND_API.Compatible_API_Call (l_api_version,
1447: p_api_version,
1448: l_api_name,
1449: G_PKG_NAME)
1450: THEN

Line 1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1447: p_api_version,
1448: l_api_name,
1449: G_PKG_NAME)
1450: THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END IF;
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.initialize;

Line 1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1450: THEN
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END IF;
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.initialize;
1456: END IF;
1457: -- Initialize API return status to success
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1458: x_return_status := FND_API.G_RET_STS_SUCCESS;

1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.initialize;
1456: END IF;
1457: -- Initialize API return status to success
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459: -- API body
1460:
1461: -- Find the Shutdown Type from the Association Table
1462: IF (p_maintenance_object_type = 1 ) THEN -- 'MSN', 'MSI'

Line 1534: IF FND_API.To_Boolean( p_commit ) THEN

1530: END IF;
1531:
1532: -- End of API body.
1533: -- Standard check of p_commit.
1534: IF FND_API.To_Boolean( p_commit ) THEN
1535: COMMIT WORK;
1536: END IF;
1537: -- Standard call to get message count and if count is 1, get message info.
1538: FND_MSG_PUB.Count_And_Get

Line 1543: WHEN FND_API.G_EXC_ERROR THEN

1539: (p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1545: x_return_status := FND_API.G_RET_STS_ERROR ;
1546:
1547: FND_MSG_PUB.Count_And_Get

Line 1545: x_return_status := FND_API.G_RET_STS_ERROR ;

1541: );
1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1545: x_return_status := FND_API.G_RET_STS_ERROR ;
1546:
1547: FND_MSG_PUB.Count_And_Get
1548: (p_count => x_msg_count,
1549: p_data => x_msg_data

Line 1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1547: FND_MSG_PUB.Count_And_Get
1548: (p_count => x_msg_count,
1549: p_data => x_msg_data
1550: );
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1554:
1555: FND_MSG_PUB.Count_And_Get

Line 1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1549: p_data => x_msg_data
1550: );
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1554:
1555: FND_MSG_PUB.Count_And_Get
1556: (p_count => x_msg_count,
1557: p_data => x_msg_data

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1557: p_data => x_msg_data
1558: );
1559: WHEN OTHERS THEN
1560: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level
1564: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN

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

1580:
1581:
1582: PROCEDURE Get_EAM_ACT_WO_Type_Default
1583: ( p_api_version IN NUMBER,
1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,

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

1581:
1582: PROCEDURE Get_EAM_ACT_WO_Type_Default
1583: ( p_api_version IN NUMBER,
1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2,

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

1582: PROCEDURE Get_EAM_ACT_WO_Type_Default
1583: ( p_api_version IN NUMBER,
1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2,
1590: p_primary_item_id IN NUMBER,

Line 1606: IF NOT FND_API.Compatible_API_Call (l_api_version,

1602: BEGIN
1603: -- Standard Start of API savepoint
1604: SAVEPOINT Get_EAM_ACT_WO_Type_Def_PVT;
1605: -- Standard call to check for call compatibility.
1606: IF NOT FND_API.Compatible_API_Call (l_api_version,
1607: p_api_version,
1608: l_api_name,
1609: G_PKG_NAME)
1610: THEN

Line 1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1607: p_api_version,
1608: l_api_name,
1609: G_PKG_NAME)
1610: THEN
1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1612: END IF;
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1615: FND_MSG_PUB.initialize;

Line 1614: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1610: THEN
1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1612: END IF;
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1615: FND_MSG_PUB.initialize;
1616: END IF;
1617: -- Initialize API return status to success
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1618: x_return_status := FND_API.G_RET_STS_SUCCESS;

1614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1615: FND_MSG_PUB.initialize;
1616: END IF;
1617: -- Initialize API return status to success
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619: -- API body
1620:
1621: -- IF (p_maintenance_object_type IN( 2,3) ) THEN -- 'CII'
1622: BEGIN

Line 1641: IF FND_API.To_Boolean( p_commit ) THEN

1637:
1638: -- END IF;
1639: -- End of API body.
1640: -- Standard check of p_commit.
1641: IF FND_API.To_Boolean( p_commit ) THEN
1642: COMMIT WORK;
1643: END IF;
1644: -- Standard call to get message count and if count is 1, get message info.
1645: FND_MSG_PUB.Count_And_Get

Line 1650: WHEN FND_API.G_EXC_ERROR THEN

1646: (p_count => x_msg_count,
1647: p_data => x_msg_data
1648: );
1649: EXCEPTION
1650: WHEN FND_API.G_EXC_ERROR THEN
1651: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1652: x_return_status := FND_API.G_RET_STS_ERROR ;
1653:
1654: FND_MSG_PUB.Count_And_Get

Line 1652: x_return_status := FND_API.G_RET_STS_ERROR ;

1648: );
1649: EXCEPTION
1650: WHEN FND_API.G_EXC_ERROR THEN
1651: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1652: x_return_status := FND_API.G_RET_STS_ERROR ;
1653:
1654: FND_MSG_PUB.Count_And_Get
1655: (p_count => x_msg_count,
1656: p_data => x_msg_data

Line 1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1654: FND_MSG_PUB.Count_And_Get
1655: (p_count => x_msg_count,
1656: p_data => x_msg_data
1657: );
1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1659: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1661:
1662: FND_MSG_PUB.Count_And_Get

Line 1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1656: p_data => x_msg_data
1657: );
1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1659: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1661:
1662: FND_MSG_PUB.Count_And_Get
1663: (p_count => x_msg_count,
1664: p_data => x_msg_data

Line 1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1664: p_data => x_msg_data
1665: );
1666: WHEN OTHERS THEN
1667: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669:
1670: IF FND_MSG_PUB.Check_Msg_Level
1671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1672: THEN

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

1683: END Get_EAM_ACT_WO_Type_Default;
1684:
1685: PROCEDURE Get_EAM_ACT_Planner_Default
1686: ( p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,

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

1684:
1685: PROCEDURE Get_EAM_ACT_Planner_Default
1686: ( p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,
1692: x_msg_data OUT NOCOPY VARCHAR2,

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

1685: PROCEDURE Get_EAM_ACT_Planner_Default
1686: ( p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690: x_return_status OUT NOCOPY VARCHAR2,
1691: x_msg_count OUT NOCOPY NUMBER,
1692: x_msg_data OUT NOCOPY VARCHAR2,
1693: p_primary_item_id IN NUMBER,

Line 1709: IF NOT FND_API.Compatible_API_Call (l_api_version,

1705: BEGIN
1706: -- Standard Start of API savepoint
1707: SAVEPOINT Get_EAM_ACT_Planner_Def_PVT;
1708: -- Standard call to check for call compatibility.
1709: IF NOT FND_API.Compatible_API_Call (l_api_version,
1710: p_api_version,
1711: l_api_name,
1712: G_PKG_NAME)
1713: THEN

Line 1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1710: p_api_version,
1711: l_api_name,
1712: G_PKG_NAME)
1713: THEN
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: END IF;
1716: -- Initialize message list if p_init_msg_list is set to TRUE.
1717: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1718: FND_MSG_PUB.initialize;

Line 1717: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1713: THEN
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: END IF;
1716: -- Initialize message list if p_init_msg_list is set to TRUE.
1717: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1718: FND_MSG_PUB.initialize;
1719: END IF;
1720: -- Initialize API return status to success
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1721: x_return_status := FND_API.G_RET_STS_SUCCESS;

1717: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1718: FND_MSG_PUB.initialize;
1719: END IF;
1720: -- Initialize API return status to success
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722: -- API body
1723:
1724: BEGIN
1725: SELECT eomd.planner_maintenance

Line 1743: IF FND_API.To_Boolean( p_commit ) THEN

1739:
1740: -- END IF;
1741: -- End of API body.
1742: -- Standard check of p_commit.
1743: IF FND_API.To_Boolean( p_commit ) THEN
1744: COMMIT WORK;
1745: END IF;
1746: -- Standard call to get message count and if count is 1, get message info.
1747: FND_MSG_PUB.Count_And_Get

Line 1752: WHEN FND_API.G_EXC_ERROR THEN

1748: (p_count => x_msg_count,
1749: p_data => x_msg_data
1750: );
1751: EXCEPTION
1752: WHEN FND_API.G_EXC_ERROR THEN
1753: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1754: x_return_status := FND_API.G_RET_STS_ERROR ;
1755:
1756: FND_MSG_PUB.Count_And_Get

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR ;

1750: );
1751: EXCEPTION
1752: WHEN FND_API.G_EXC_ERROR THEN
1753: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1754: x_return_status := FND_API.G_RET_STS_ERROR ;
1755:
1756: FND_MSG_PUB.Count_And_Get
1757: (p_count => x_msg_count,
1758: p_data => x_msg_data

Line 1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1756: FND_MSG_PUB.Count_And_Get
1757: (p_count => x_msg_count,
1758: p_data => x_msg_data
1759: );
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763:
1764: FND_MSG_PUB.Count_And_Get

Line 1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1758: p_data => x_msg_data
1759: );
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763:
1764: FND_MSG_PUB.Count_And_Get
1765: (p_count => x_msg_count,
1766: p_data => x_msg_data

Line 1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1766: p_data => x_msg_data
1767: );
1768: WHEN OTHERS THEN
1769: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1771:
1772: IF FND_MSG_PUB.Check_Msg_Level
1773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1774: THEN

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

1784: END Get_EAM_ACT_Planner_Default;
1785:
1786: PROCEDURE Get_EAM_ACT_Firm_Default
1787: ( p_api_version IN NUMBER,
1788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1789: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1790: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1791: x_return_status OUT NOCOPY VARCHAR2,
1792: x_msg_count OUT NOCOPY NUMBER,

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

1785:
1786: PROCEDURE Get_EAM_ACT_Firm_Default
1787: ( p_api_version IN NUMBER,
1788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1789: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1790: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1791: x_return_status OUT NOCOPY VARCHAR2,
1792: x_msg_count OUT NOCOPY NUMBER,
1793: x_msg_data OUT NOCOPY VARCHAR2,

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

1786: PROCEDURE Get_EAM_ACT_Firm_Default
1787: ( p_api_version IN NUMBER,
1788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1789: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1790: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1791: x_return_status OUT NOCOPY VARCHAR2,
1792: x_msg_count OUT NOCOPY NUMBER,
1793: x_msg_data OUT NOCOPY VARCHAR2,
1794: p_primary_item_id IN NUMBER,

Line 1810: IF NOT FND_API.Compatible_API_Call (l_api_version,

1806: BEGIN
1807: -- Standard Start of API savepoint
1808: SAVEPOINT Get_EAM_ACT_Firm_Def_PVT;
1809: -- Standard call to check for call compatibility.
1810: IF NOT FND_API.Compatible_API_Call (l_api_version,
1811: p_api_version,
1812: l_api_name,
1813: G_PKG_NAME)
1814: THEN

Line 1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1811: p_api_version,
1812: l_api_name,
1813: G_PKG_NAME)
1814: THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: END IF;
1817: -- Initialize message list if p_init_msg_list is set to TRUE.
1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1819: FND_MSG_PUB.initialize;

Line 1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1814: THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: END IF;
1817: -- Initialize message list if p_init_msg_list is set to TRUE.
1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1819: FND_MSG_PUB.initialize;
1820: END IF;
1821: -- Initialize API return status to success
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1822: x_return_status := FND_API.G_RET_STS_SUCCESS;

1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1819: FND_MSG_PUB.initialize;
1820: END IF;
1821: -- Initialize API return status to success
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823: -- API body
1824:
1825: BEGIN
1826: SELECT eomd.firm_planned_flag

Line 1844: IF FND_API.To_Boolean( p_commit ) THEN

1840:
1841: -- END IF;
1842: -- End of API body.
1843: -- Standard check of p_commit.
1844: IF FND_API.To_Boolean( p_commit ) THEN
1845: COMMIT WORK;
1846: END IF;
1847: -- Standard call to get message count and if count is 1, get message info.
1848: FND_MSG_PUB.Count_And_Get

Line 1853: WHEN FND_API.G_EXC_ERROR THEN

1849: (p_count => x_msg_count,
1850: p_data => x_msg_data
1851: );
1852: EXCEPTION
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1855: x_return_status := FND_API.G_RET_STS_ERROR ;
1856:
1857: FND_MSG_PUB.Count_And_Get

Line 1855: x_return_status := FND_API.G_RET_STS_ERROR ;

1851: );
1852: EXCEPTION
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1855: x_return_status := FND_API.G_RET_STS_ERROR ;
1856:
1857: FND_MSG_PUB.Count_And_Get
1858: (p_count => x_msg_count,
1859: p_data => x_msg_data

Line 1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1857: FND_MSG_PUB.Count_And_Get
1858: (p_count => x_msg_count,
1859: p_data => x_msg_data
1860: );
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864:
1865: FND_MSG_PUB.Count_And_Get

Line 1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1859: p_data => x_msg_data
1860: );
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864:
1865: FND_MSG_PUB.Count_And_Get
1866: (p_count => x_msg_count,
1867: p_data => x_msg_data

Line 1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1867: p_data => x_msg_data
1868: );
1869: WHEN OTHERS THEN
1870: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1872:
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN

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

1885: END Get_EAM_ACT_Firm_Default;
1886:
1887: PROCEDURE Get_EAM_ACT_Planned_Default
1888: ( p_api_version IN NUMBER,
1889: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1890: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1891: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1892: x_return_status OUT NOCOPY VARCHAR2,
1893: x_msg_count OUT NOCOPY NUMBER,

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

1886:
1887: PROCEDURE Get_EAM_ACT_Planned_Default
1888: ( p_api_version IN NUMBER,
1889: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1890: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1891: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1892: x_return_status OUT NOCOPY VARCHAR2,
1893: x_msg_count OUT NOCOPY NUMBER,
1894: x_msg_data OUT NOCOPY VARCHAR2,

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

1887: PROCEDURE Get_EAM_ACT_Planned_Default
1888: ( p_api_version IN NUMBER,
1889: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1890: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1891: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1892: x_return_status OUT NOCOPY VARCHAR2,
1893: x_msg_count OUT NOCOPY NUMBER,
1894: x_msg_data OUT NOCOPY VARCHAR2,
1895: p_primary_item_id IN NUMBER,

Line 1911: IF NOT FND_API.Compatible_API_Call (l_api_version,

1907: BEGIN
1908: -- Standard Start of API savepoint
1909: SAVEPOINT Get_EAM_ACT_Planned_Def_PVT;
1910: -- Standard call to check for call compatibility.
1911: IF NOT FND_API.Compatible_API_Call (l_api_version,
1912: p_api_version,
1913: l_api_name,
1914: G_PKG_NAME)
1915: THEN

Line 1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1912: p_api_version,
1913: l_api_name,
1914: G_PKG_NAME)
1915: THEN
1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918: -- Initialize message list if p_init_msg_list is set to TRUE.
1919: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1920: FND_MSG_PUB.initialize;

Line 1919: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1915: THEN
1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918: -- Initialize message list if p_init_msg_list is set to TRUE.
1919: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1920: FND_MSG_PUB.initialize;
1921: END IF;
1922: -- Initialize API return status to success
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

1919: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1920: FND_MSG_PUB.initialize;
1921: END IF;
1922: -- Initialize API return status to success
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: -- API body
1925:
1926: BEGIN
1927: SELECT eomd.plan_maintenance

Line 1945: IF FND_API.To_Boolean( p_commit ) THEN

1941:
1942: -- END IF;
1943: -- End of API body.
1944: -- Standard check of p_commit.
1945: IF FND_API.To_Boolean( p_commit ) THEN
1946: COMMIT WORK;
1947: END IF;
1948: -- Standard call to get message count and if count is 1, get message info.
1949: FND_MSG_PUB.Count_And_Get

Line 1954: WHEN FND_API.G_EXC_ERROR THEN

1950: (p_count => x_msg_count,
1951: p_data => x_msg_data
1952: );
1953: EXCEPTION
1954: WHEN FND_API.G_EXC_ERROR THEN
1955: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957:
1958: FND_MSG_PUB.Count_And_Get

Line 1956: x_return_status := FND_API.G_RET_STS_ERROR ;

1952: );
1953: EXCEPTION
1954: WHEN FND_API.G_EXC_ERROR THEN
1955: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957:
1958: FND_MSG_PUB.Count_And_Get
1959: (p_count => x_msg_count,
1960: p_data => x_msg_data

Line 1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1958: FND_MSG_PUB.Count_And_Get
1959: (p_count => x_msg_count,
1960: p_data => x_msg_data
1961: );
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1965:
1966: FND_MSG_PUB.Count_And_Get

Line 1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1960: p_data => x_msg_data
1961: );
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1965:
1966: FND_MSG_PUB.Count_And_Get
1967: (p_count => x_msg_count,
1968: p_data => x_msg_data

Line 1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1968: p_data => x_msg_data
1969: );
1970: WHEN OTHERS THEN
1971: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1973:
1974: IF FND_MSG_PUB.Check_Msg_Level
1975: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1976: THEN