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.EAM_ACTIVITYASSOCIATION_PVT dependencies on FND_API

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

9: G_ACT_PRIORITY VARCHAR2(30) := EAM_CONSTANTS.G_ACT_PRIORITY;
10:
11: PROCEDURE Create_Association
12: ( p_api_version IN NUMBER ,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
16: x_return_status OUT NOCOPY VARCHAR2 ,
17: x_msg_count OUT NOCOPY NUMBER ,

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

10:
11: PROCEDURE Create_Association
12: ( p_api_version IN NUMBER ,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
16: x_return_status OUT NOCOPY VARCHAR2 ,
17: x_msg_count OUT NOCOPY NUMBER ,
18: x_msg_data OUT NOCOPY VARCHAR2 ,

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

11: PROCEDURE Create_Association
12: ( p_api_version IN NUMBER ,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
16: x_return_status OUT NOCOPY VARCHAR2 ,
17: x_msg_count OUT NOCOPY NUMBER ,
18: x_msg_data OUT NOCOPY VARCHAR2 ,
19:

Line 120: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

116: -- Standard Start of API savepoint
117: SAVEPOINT Create_Association_PVT;
118:
119: -- Standard call to check for call compatibility.
120: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
121: p_api_version ,
122: l_api_name ,
123: G_PKG_NAME )
124: THEN

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: p_api_version ,
122: l_api_name ,
123: G_PKG_NAME )
124: THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 129: IF FND_API.to_Boolean( p_init_msg_list ) THEN

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean( p_init_msg_list ) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: -- Initialize API return status to success

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: -- Initialize API return status to success
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: -- API body
137:
138: -- ============================================================

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172:
173: -- Validate l_source_org_id should not be Null
174: IF l_source_org_id IS NULL THEN
175: EAM_ActivityUtilities_PVT.Write_Debug('l_source_ord_id should not be NULL');
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178:
179: -- After this point l_source_activity_id and l_source_org_id are defined,
180: -- should use them instead of p_source_activity_id and p_source_org_id.

Line 232: RAISE FND_API.G_EXC_ERROR;

228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
229: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_PROPERTIES');
230: FND_MSG_PUB.ADD;
231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233: END;
234:
235: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
236: 'l_activity_cause_code=' || l_activity_cause_code

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
318: 'Copy CURRENT: unexpected Work Order Item/Serial Number inputs.');
319: end if;
320:
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: ELSIF p_association_copy_option = 3 THEN
325: -- copy option = 3 (ALL)

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

365: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
366: 'Copy ALL: unexpected Work Order Item/Serial Number inputs.');
367: end if;
368:
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372: ELSE
373: -- copy option outside of valid range, shouldn't be here.

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
375: 'Create_Association: unexpected Association Copy Option');
376: end if;
377:
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: END IF;
381:
382:

Line 476: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN

472: -- assign outputs
473: x_activity_association_tbl := l_x_activity_association_tbl;
474:
475: -- Handle errors
476: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
477: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_AN_ASSOC_FAILED');
478: -- FND_MESSAGE.SET_ENCODED('Failed to create Asset Number Associations.');
479: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
480: RAISE FND_API.G_EXC_ERROR;

Line 480: RAISE FND_API.G_EXC_ERROR;

476: IF l_x_assoc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
477: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_AN_ASSOC_FAILED');
478: -- FND_MESSAGE.SET_ENCODED('Failed to create Asset Number Associations.');
479: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482:
483: -- Bug # 4089189 : Need to default WAC and dept from WO to the Activity Association with the Asset in WO.
484: IF p_wip_entity_id IS NOT NULL THEN

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: 'EAM_ActivityAssociation_PVT.Create_Association: unexpected error.'
511: || 'p_wip_entity_id=' || p_wip_entity_id);
512: end if;
513:
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END;
516:
517: END IF;
518:

Line 527: IF FND_API.To_Boolean( p_commit ) THEN

523: -- ============================================================
524:
525: -- End of API body.
526: -- Standard check of p_commit.
527: IF FND_API.To_Boolean( p_commit ) THEN
528: COMMIT WORK;
529: END IF;
530: -- Standard call to get message count and if count is 1, get message info.
531: FND_MSG_PUB.Count_And_Get

Line 537: WHEN FND_API.G_EXC_ERROR THEN

533: p_data => x_msg_data
534: );
535: x_msg_data := substr(x_msg_data,1,4000);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Create_Association_PVT;
539: x_return_status := FND_API.G_RET_STS_ERROR ;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count ,

Line 539: x_return_status := FND_API.G_RET_STS_ERROR ;

535: x_msg_data := substr(x_msg_data,1,4000);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Create_Association_PVT;
539: x_return_status := FND_API.G_RET_STS_ERROR ;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count ,
542: p_data => x_msg_data
543: );

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: ( p_count => x_msg_count ,
542: p_data => x_msg_data
543: );
544: x_msg_data := substr(x_msg_data,1,4000);
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO Create_Association_PVT;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count ,

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

543: );
544: x_msg_data := substr(x_msg_data,1,4000);
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO Create_Association_PVT;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count ,
550: p_data => x_msg_data
551: );

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

551: );
552: x_msg_data := substr(x_msg_data,1,4000);
553: WHEN OTHERS THEN
554: ROLLBACK TO Create_Association_PVT;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: IF FND_MSG_PUB.Check_Msg_Level
557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
558: THEN
559: FND_MSG_PUB.Add_Exc_Msg

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

570:
571:
572: PROCEDURE Create_AssetNumberAssoc
573: ( p_api_version IN NUMBER ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validation_level IN NUMBER :=
577: FND_API.G_VALID_LEVEL_FULL ,
578: x_return_status OUT NOCOPY VARCHAR2 ,

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

571:
572: PROCEDURE Create_AssetNumberAssoc
573: ( p_api_version IN NUMBER ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validation_level IN NUMBER :=
577: FND_API.G_VALID_LEVEL_FULL ,
578: x_return_status OUT NOCOPY VARCHAR2 ,
579: x_msg_count OUT NOCOPY NUMBER ,

Line 577: FND_API.G_VALID_LEVEL_FULL ,

573: ( p_api_version IN NUMBER ,
574: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
575: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
576: p_validation_level IN NUMBER :=
577: FND_API.G_VALID_LEVEL_FULL ,
578: x_return_status OUT NOCOPY VARCHAR2 ,
579: x_msg_count OUT NOCOPY NUMBER ,
580: x_msg_data OUT NOCOPY VARCHAR2 ,
581:

Line 619: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

615: -- Standard Start of API savepoint
616: SAVEPOINT Create_AssetNumberAssoc_PVT;
617:
618: -- Standard call to check for call compatibility.
619: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
620: p_api_version ,
621: l_api_name ,
622: G_PKG_NAME )
623: THEN

Line 624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 628: IF FND_API.to_Boolean( p_init_msg_list ) THEN

624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626:
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631: -- Initialize API return status to success
632:

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: FND_MSG_PUB.initialize;
630: END IF;
631: -- Initialize API return status to success
632:
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- API body
636: -- ============================================================
637: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 671: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

667: FROM wip_eam_parameters
668: WHERE organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id;
669:
670: IF l_count <> 1 THEN
671: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
673: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
674:
675: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 695: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

691: AND inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id
692: AND eam_item_type = 2;
693:
694: IF l_count <> 1 THEN
695: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
696: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACTIVITY_ID');
697: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Id.');
698: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
699:

Line 720: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

716: -- Start Date and End Date
717: IF l_act_assoc_tbl(l_act_assoc_tbl_index).End_Date_Active <
718: l_act_assoc_tbl(l_act_assoc_tbl_index).Start_Date_Active
719: THEN
720: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
721: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_START_END_DATE');
722: -- FND_MESSAGE.SET_ENCODED('End Date cannot be before Start Date.');
723: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
724:

Line 753: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

749: and nvl(enabled_flag, 'N') = 'Y'
750: and lookup_code = l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code;
751:
752: IF l_count <> 1 THEN
753: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
754: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_PRI_CODE');
755: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Priority Code.');
756: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
757:

Line 780: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

776: and (disable_date IS NULL
777: or disable_date > sysdate);
778:
779: IF l_count <> 1 THEN
780: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
781: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_OWN_DEPT_ID');
782: -- FND_MESSAGE.SET_ENCODED('Invalid Owning Department Id.');
783: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
784:

Line 809: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

805: and nvl(enabled_flag, 'N') = 'Y'
806: and lookup_code = l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code;
807:
808: IF l_count <> 1 THEN
809: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
810: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_TYPE_CODE');
811: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Type Code.');
812: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
813:

Line 837: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

833: and nvl(enabled_flag, 'N') = 'Y'
834: and lookup_code = l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code;
835:
836: IF l_count <> 1 THEN
837: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
838: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_CAUSE_CODE');
839: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Cause Code.');
840: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
841:

Line 865: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

861: and nvl(enabled_flag, 'N') = 'Y'
862: and lookup_code = l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code;
863:
864: IF l_count <> 1 THEN
865: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
866: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_SRC_CODE');
867: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Source Code.');
868: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
869:

Line 893: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

889: and nvl(enabled_flag, 'N') = 'Y'
890: and lookup_code = l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code;
891:
892: IF l_count <> 1 THEN
893: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
894: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_SHUTDOWN_CODE');
895: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Shutdown Type Code.');
896: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
897:

Line 919: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

915: and class_type = 6
916: and (disable_date is null or sysdate < disable_date);
917:
918: IF l_count <> 1 THEN
919: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
920: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
921: -- FND_MESSAGE.SET_ENCODED('Invalid Wip Accounting Class Code.');
922: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
923:

Line 941: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

937: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag IS NOT NULL AND
938: l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag <> 'Y' AND
939: l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag <> 'N'
940: THEN
941: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
942: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_TAG_REQ_FLAG');
943: -- FND_MESSAGE.SET_ENCODED('Tagging Required Flag should be either Y, N, or NULL.');
944: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
945:

Line 978: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

974:
975: l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_id := l_maintenance_object_id;
976: l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_type := l_maintenance_object_type;
977:
978: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
979:
980: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
981: 'Failed Validate Serial Number: Instance_number, or Inventory_Item_Id + Serial_Number'
982: || 'Return_Status=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status ||

Line 998: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

994: -- Validate Maintenance Object Type
995: -- Can only be 3 or 2.
996: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type NOT IN (3, 2)
997: THEN
998: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
999: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
1000: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Type should be 1 or 2.');
1001: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1002:

Line 1031: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1027: AND nvl(cii.active_start_date, sysdate-1) <= sysdate
1028: AND nvl(cii.active_end_date, sysdate+1) >= sysdate;
1029:
1030: IF l_count <> 1 THEN
1031: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1032: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_GEN_OBJ_ID');
1033: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Id should be a valid gen_object_id.');
1034: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1035:

Line 1059: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1055: AND mp.organization_id = msi.organization_id
1056: AND msi.eam_item_type in (1,3);
1057:
1058: IF l_count < 1 THEN
1059: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1060: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_ITM_OBJ_ID');
1061: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Id should be a valid inventory_item_id.');
1062: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1063:

Line 1077: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1073: GOTO next_in_loop;
1074: END IF;
1075: ELSE
1076: -- Shouldn't be here
1077: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1078:
1079: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1080: 'Maintenance_Object_Type is neither 1 nor 2');
1081: end if;

Line 1093: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1089: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag IS NOT NULL
1090: THEN
1091: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag NOT IN ('Y', 'N')
1092: THEN
1093: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1094: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_TMPL_FLAG');
1095: -- FND_MESSAGE.SET_ENCODED('Tmpl Flag should be Y, N, or NULL.');
1096: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1097:

Line 1115: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1111:
1112:
1113: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag = 'Y' THEN
1114: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type <> 2 THEN
1115: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1116: FND_MESSAGE.SET_NAME('EAM', 'EAM_IAA_INV_TEML_FLAG');
1117: -- FND_MESSAGE.SET_ENCODED(' Invalid Template flag value.');
1118: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1119:

Line 1136: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1132: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1133: AND rownum = 1;
1134:
1135: IF l_count = 1 THEN
1136: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1137: FND_MESSAGE.SET_NAME('EAM', 'EAM_NON_SERIAL_REBUILD_ASSOC');
1138: -- FND_MESSAGE.SET_ENCODED('Cannot assoicate Non-Serialized Rebuildables to Templates.');
1139: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1140:

Line 1161: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1157: WHERE msi.inventory_item_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id
1158: AND rownum = 1;
1159:
1160: IF l_count <> 1 THEN
1161: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1162: FND_MESSAGE.SET_NAME('EAM', 'EAM_IAA_INV_TEML_FLAG');
1163: -- FND_MESSAGE.SET_ENCODED(' Invalid Template flag value.');
1164: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1165:

Line 1210: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1206: );
1207: */
1208:
1209: if l_count >= 1 then
1210: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1211: fnd_message.set_name('EAM','EAM_DUPLICATE_ASSET_ACTIVITIES');
1212: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1213:
1214:

Line 1238: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1234: FROM dual;
1235: EXCEPTION
1236: WHEN OTHERS THEN
1237:
1238: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1239: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_ASSOC_ID');
1240: -- FND_MESSAGE.SET_ENCODED('Error creating Activity_Association_Id.');
1241: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1242:

Line 1319: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;

1315:
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318:
1319: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1320: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INSERT_ASSOC');
1321: -- FND_MESSAGE.SET_ENCODED('Error inserting Activity Association record.');
1322: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1323:

Line 1359: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1355: ,x_msg_data => l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg
1356: );
1357:
1358:
1359: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1360:
1361: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1362: 'Failed during insert in EOMD' ||
1363: 'Return_Status=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status ||

Line 1373: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_SUCCESS;

1369: END IF;
1370:
1371: -- ----------------------------------------------------------------------
1372: -- If reach here, successful
1373: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_SUCCESS;
1374:
1375:
1376: <>
1377: l_act_assoc_tbl_index := l_act_assoc_tbl.NEXT(l_act_assoc_tbl_index);

Line 1383: l_x_return_status := FND_API.G_RET_STS_ERROR;

1379:
1380: -- Assign outputs
1381: x_activity_association_tbl := l_act_assoc_tbl;
1382: IF l_failed THEN
1383: l_x_return_status := FND_API.G_RET_STS_ERROR;
1384: ELSE
1385: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1386: END IF;
1387:

Line 1385: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1381: x_activity_association_tbl := l_act_assoc_tbl;
1382: IF l_failed THEN
1383: l_x_return_status := FND_API.G_RET_STS_ERROR;
1384: ELSE
1385: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1386: END IF;
1387:
1388: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1389: 'l_x_return_status=' || l_x_return_status ||

Line 1399: IF FND_API.To_Boolean( p_commit ) THEN

1395: -- ============================================================
1396:
1397: -- End of API body.
1398: -- Standard check of p_commit.
1399: IF FND_API.To_Boolean( p_commit ) THEN
1400: COMMIT WORK;
1401: END IF;
1402: -- Standard call to get message count and if count is 1, get message info.
1403: FND_MSG_PUB.Count_And_Get

Line 1409: WHEN FND_API.G_EXC_ERROR THEN

1405: p_data => x_msg_data
1406: );
1407: x_msg_data := substr(x_msg_data,1,4000);
1408: EXCEPTION
1409: WHEN FND_API.G_EXC_ERROR THEN
1410: ROLLBACK TO Create_AssetNumberAssoc_PVT;
1411: x_return_status := FND_API.G_RET_STS_ERROR ;
1412: FND_MSG_PUB.Count_And_Get
1413: ( p_count => x_msg_count ,

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR ;

1407: x_msg_data := substr(x_msg_data,1,4000);
1408: EXCEPTION
1409: WHEN FND_API.G_EXC_ERROR THEN
1410: ROLLBACK TO Create_AssetNumberAssoc_PVT;
1411: x_return_status := FND_API.G_RET_STS_ERROR ;
1412: FND_MSG_PUB.Count_And_Get
1413: ( p_count => x_msg_count ,
1414: p_data => x_msg_data
1415: );

Line 1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1413: ( p_count => x_msg_count ,
1414: p_data => x_msg_data
1415: );
1416: x_msg_data := substr(x_msg_data,1,4000);
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1418: ROLLBACK TO Create_AssetNumberAssoc_PVT;
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: FND_MSG_PUB.Count_And_Get
1421: ( p_count => x_msg_count ,

Line 1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1415: );
1416: x_msg_data := substr(x_msg_data,1,4000);
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1418: ROLLBACK TO Create_AssetNumberAssoc_PVT;
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: FND_MSG_PUB.Count_And_Get
1421: ( p_count => x_msg_count ,
1422: p_data => x_msg_data
1423: );

Line 1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1423: );
1424: x_msg_data := substr(x_msg_data,1,4000);
1425: WHEN OTHERS THEN
1426: ROLLBACK TO Create_AssetNumberAssoc_PVT;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1428: IF FND_MSG_PUB.Check_Msg_Level
1429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1430: THEN
1431: FND_MSG_PUB.Add_Exc_Msg

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

1444: -- ======================================================================
1445:
1446: PROCEDURE Inst_Activity_Template(
1447: p_api_version IN NUMBER ,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1450: p_validation_level IN NUMBER :=
1451: FND_API.G_VALID_LEVEL_FULL ,
1452: x_return_status OUT NOCOPY VARCHAR2 ,

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

1445:
1446: PROCEDURE Inst_Activity_Template(
1447: p_api_version IN NUMBER ,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1450: p_validation_level IN NUMBER :=
1451: FND_API.G_VALID_LEVEL_FULL ,
1452: x_return_status OUT NOCOPY VARCHAR2 ,
1453: x_msg_count OUT NOCOPY NUMBER ,

Line 1451: FND_API.G_VALID_LEVEL_FULL ,

1447: p_api_version IN NUMBER ,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1449: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1450: p_validation_level IN NUMBER :=
1451: FND_API.G_VALID_LEVEL_FULL ,
1452: x_return_status OUT NOCOPY VARCHAR2 ,
1453: x_msg_count OUT NOCOPY NUMBER ,
1454: x_msg_data OUT NOCOPY VARCHAR2 ,
1455:

Line 1532: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1528: -- Standard Start of API savepoint
1529: SAVEPOINT Inst_Activity_Template_PVT;
1530:
1531: -- Standard call to check for call compatibility.
1532: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1533: p_api_version ,
1534: l_api_name ,
1535: G_PKG_NAME )
1536: THEN

Line 1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1533: p_api_version ,
1534: l_api_name ,
1535: G_PKG_NAME )
1536: THEN
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:
1540: -- Initialize message list if p_init_msg_list is set to TRUE.
1541: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1541: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:
1540: -- Initialize message list if p_init_msg_list is set to TRUE.
1541: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1542: FND_MSG_PUB.initialize;
1543: END IF;
1544:
1545: -- Initialize API return status to success

Line 1546: x_return_status := FND_API.G_RET_STS_SUCCESS;

1542: FND_MSG_PUB.initialize;
1543: END IF;
1544:
1545: -- Initialize API return status to success
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547:
1548:
1549: -- API body
1550:

Line 1558: RAISE FND_API.G_EXC_ERROR;

1554: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1555: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
1556: FND_MSG_PUB.ADD;
1557: END IF;
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:
1561: -- I: Find out the inventory_item_id
1562: BEGIN

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1571: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_GEN_OBJ_ID');
1572: FND_MSG_PUB.ADD;
1573: END IF;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END;
1576:
1577: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1578: 'l_inventory_item_id=' || l_inventory_item_id);

Line 1596: RAISE FND_API.G_EXC_ERROR;

1592: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1593: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_ASSOC_ID');
1594: FND_MSG_PUB.ADD;
1595: END IF;
1596: RAISE FND_API.G_EXC_ERROR;
1597: END;
1598:
1599: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1600: 'l_next_association_id=' || l_next_association_id);

Line 1712: RAISE FND_API.G_EXC_ERROR;

1708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1709: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INSERT_ASSOC');
1710: FND_MSG_PUB.ADD;
1711: END IF;
1712: RAISE FND_API.G_EXC_ERROR;
1713: END;
1714:
1715: IF l_asset_activity_row.organization_id IS NOT NULL THEN
1716:

Line 1737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1733: ,x_msg_data => x_msg_data
1734: );
1735: END IF;
1736:
1737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740:
1741: -- 3: Record outputs

Line 1738: RAISE FND_API.G_EXC_ERROR;

1734: );
1735: END IF;
1736:
1737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740:
1741: -- 3: Record outputs
1742: l_next_row := NVL(l_activity_association_id_tbl.LAST, 0) + 1;

Line 1755: IF FND_API.To_Boolean( p_commit ) THEN

1751: -- End of API body.
1752:
1753:
1754: -- Standard check of p_commit.
1755: IF FND_API.To_Boolean( p_commit ) THEN
1756: COMMIT WORK;
1757: END IF;
1758: -- Standard call to get message count and if count is 1, get message info.
1759: FND_MSG_PUB.Count_And_Get

Line 1773: WHEN FND_API.G_EXC_ERROR THEN

1769:
1770:
1771:
1772: EXCEPTION
1773: WHEN FND_API.G_EXC_ERROR THEN
1774: ROLLBACK TO Inst_Activity_Template_PVT;
1775: x_return_status := FND_API.G_RET_STS_ERROR ;
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count ,

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR ;

1771:
1772: EXCEPTION
1773: WHEN FND_API.G_EXC_ERROR THEN
1774: ROLLBACK TO Inst_Activity_Template_PVT;
1775: x_return_status := FND_API.G_RET_STS_ERROR ;
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count ,
1778: p_data => x_msg_data
1779: );

Line 1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1777: ( p_count => x_msg_count ,
1778: p_data => x_msg_data
1779: );
1780: x_msg_data := substr(x_msg_data,1,4000);
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: ROLLBACK TO Inst_Activity_Template_PVT;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1784: FND_MSG_PUB.Count_And_Get
1785: ( p_count => x_msg_count ,

Line 1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1779: );
1780: x_msg_data := substr(x_msg_data,1,4000);
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: ROLLBACK TO Inst_Activity_Template_PVT;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1784: FND_MSG_PUB.Count_And_Get
1785: ( p_count => x_msg_count ,
1786: p_data => x_msg_data
1787: );

Line 1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1787: );
1788: x_msg_data := substr(x_msg_data,1,4000);
1789: WHEN OTHERS THEN
1790: ROLLBACK TO Inst_Activity_Template_PVT;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1792: IF FND_MSG_PUB.Check_Msg_Level
1793: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1794: THEN
1795: FND_MSG_PUB.Add_Exc_Msg