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_ACTIVITYUTILITIES_PVT dependencies on FND_API

Line 40: IF p_organization_id IS NOT NULL AND p_organization_id <> FND_API.G_MISS_NUM THEN

36: -- transfer input data to output data
37: x_organization_id := p_organization_id;
38: x_organization_code := p_organization_code;
39:
40: IF p_organization_id IS NOT NULL AND p_organization_id <> FND_API.G_MISS_NUM THEN
41: -- organization_id takes precedence
42: BEGIN
43: SELECT organization_code INTO x_organization_code
44: FROM mtl_parameters

Line 51: RAISE FND_API.G_EXC_ERROR;

47: WHEN NO_DATA_FOUND THEN
48: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
49: -- FND_MESSAGE.SET_ENCODED('Organization Id invalid.');
50: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
51: RAISE FND_API.G_EXC_ERROR;
52: END;
53:
54: ELSIF p_organization_code IS NOT NULL AND p_organization_code <> FND_API.G_MISS_CHAR THEN
55:

Line 54: ELSIF p_organization_code IS NOT NULL AND p_organization_code <> FND_API.G_MISS_CHAR THEN

50: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
51: RAISE FND_API.G_EXC_ERROR;
52: END;
53:
54: ELSIF p_organization_code IS NOT NULL AND p_organization_code <> FND_API.G_MISS_CHAR THEN
55:
56: BEGIN
57: SELECT organization_id INTO x_organization_id
58: FROM mtl_parameters

Line 65: RAISE FND_API.G_EXC_ERROR;

61: WHEN NO_DATA_FOUND THEN
62: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_CODE');
63: -- FND_MESSAGE.SET_ENCODED('Organization Code invalid.');
64: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
65: RAISE FND_API.G_EXC_ERROR;
66: END;
67: ELSE
68: -- Error: both organization id and code are NULL
69: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ORG_ID_CODE_NULL');

Line 72: RAISE FND_API.G_EXC_ERROR;

68: -- Error: both organization id and code are NULL
69: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ORG_ID_CODE_NULL');
70: -- FND_MESSAGE.SET_ENCODED('Organization id and organization code cannot be both NULL.');
71: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
78: '----- Exiting EAM_ActivityUtilities_PVT.Validate_Organization -----');
79: end if;

Line 82: WHEN FND_API.G_EXC_ERROR THEN

78: '----- Exiting EAM_ActivityUtilities_PVT.Validate_Organization -----');
79: end if;
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83:
84: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
85: 'EAM_ActivityUtilities_PVT.Validate_Organization: error.' ||
86: 'p_organization_id=' || p_organization_id ||

Line 90: x_return_status := FND_API.G_RET_STS_ERROR;

86: 'p_organization_id=' || p_organization_id ||
87: '; p_organization_code=' || p_organization_code);
88: end if;
89:
90: x_return_status := FND_API.G_RET_STS_ERROR;
91:
92: WHEN OTHERS THEN
93:
94: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: 'p_organization_id=' || p_organization_id ||
97: '; p_organization_code=' || p_organization_code);
98: end if;
99:
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END;
102:
103: -- ----------------------------------------------------------------------
104: PROCEDURE Validate_Work_Order

Line 155: RAISE FND_API.G_EXC_ERROR;

151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WIP_ENTITY_ID');
153: -- FND_MESSAGE.SET_ENCODED('Wip Entity Id invalid.');
154: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
155: RAISE FND_API.G_EXC_ERROR;
156: END;
157:
158: -- also need to set org code
159: Validate_Organization(

Line 169: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN

165: );
166: l_x_work_order_rec.organization_id := l_temp_org_id;
167: l_x_work_order_rec.organization_code := l_temp_org_code;
168:
169: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
170: EAM_ActivityUtilities_PVT.Add_Message(
171: 'EAM_ActivityUtilities_PVT.Validate_Work_Order: wip_entity_id: organization validation failed.');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;

Line 172: RAISE FND_API.G_EXC_ERROR;

168:
169: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
170: EAM_ActivityUtilities_PVT.Add_Message(
171: 'EAM_ActivityUtilities_PVT.Validate_Work_Order: wip_entity_id: organization validation failed.');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: ELSIF p_work_order_rec.wip_entity_name IS NOT NULL THEN
176: -- For wip_entity_name, need to validate org first

Line 187: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN

183: );
184: l_x_work_order_rec.organization_id := l_temp_org_id;
185: l_x_work_order_rec.organization_code := l_temp_org_code;
186:
187: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
188: EAM_ActivityUtilities_PVT.Add_Message(
189: 'EAM_ActivityUtilities_PVT.Validate_Work_Order: wip_entity_name: organization validation failed.');
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;

Line 190: RAISE FND_API.G_EXC_ERROR;

186:
187: IF l_validate_org_ret_sts <> FND_API.G_RET_STS_SUCCESS THEN
188: EAM_ActivityUtilities_PVT.Add_Message(
189: 'EAM_ActivityUtilities_PVT.Validate_Work_Order: wip_entity_name: organization validation failed.');
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: BEGIN
194: SELECT wip_entity_id INTO l_x_work_order_rec.wip_entity_id

Line 203: RAISE FND_API.G_EXC_ERROR;

199: WHEN OTHERS THEN
200: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WIP_ENT_NAME');
201: -- FND_MESSAGE.SET_ENCODED('Wip Entity Name invalid.');
202: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
203: RAISE FND_API.G_EXC_ERROR;
204: END;
205:
206: ELSE
207: -- Error: both wip entity id and code are NULL

Line 211: RAISE FND_API.G_EXC_ERROR;

207: -- Error: both wip entity id and code are NULL
208: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_WIP_ENT_ID_NAME_NULL');
209: -- FND_MESSAGE.SET_ENCODED('Wip Entity Id and Name cannot be both NULL.');
210: EAM_ActivityUtilities_PVT.Add_Message(FND_MSG_PUB.G_MSG_LVL_ERROR);
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: -- Assign output
215: x_work_order_rec := l_x_work_order_rec;

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218: '----- Exiting EAM_ActivityUtilities_PVT.Validate_Work_Order -----');
219: end if;
220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223:
224: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
225: 'EAM_ActivityUtilities_PVT.Validate_Work_Order: error.'||
226: 'wip_entity_id=' || p_work_order_rec.wip_entity_id ||

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228: '; organization_id=' || p_work_order_rec.organization_id ||
229: '; organization_code=' || p_work_order_rec.organization_code);
230: end if;
231:
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: WHEN OTHERS THEN
235:
236: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: '; organization_id=' || p_work_order_rec.organization_id ||
241: '; organization_code=' || p_work_order_rec.organization_code);
242: end if;
243:
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END;
246:
247: -- ----------------------------------------------------------------------
248: FUNCTION Get_Item_Concatenated_Segments(

Line 292: RAISE FND_API.G_EXC_ERROR;

288: 'p_organization_id=' || p_organization_id ||
289: '; p_inventory_item_id=' || p_inventory_item_id);
290: end if;
291:
292: RAISE FND_API.G_EXC_ERROR;
293:
294: WHEN OTHERS THEN
295:
296: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: 'p_organization_id=' || p_organization_id ||
299: '; p_inventory_item_id=' || p_inventory_item_id);
300: end if;
301:
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END;
304:
305: -- ----------------------------------------------------------------------
306: FUNCTION Get_Act_Id_From_Work_Order(

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337: 'EAM_ActivityUtilities_PVT.Get_Act_Id_From_Work_Order: unexpected error.'||
338: 'p_wip_entity_id=' || p_wip_entity_id);
339: end if;
340:
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END;
343:
344: -- ----------------------------------------------------------------------
345: FUNCTION Get_Org_Id_From_Work_Order(

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: 'EAM_ActivityUtilities_PVT.Get_Org_Id_From_Work_Order: unexpected error.'||
377: 'p_wip_entity_id=' || p_wip_entity_id);
378: end if;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END;
382:
383: -- ----------------------------------------------------------------------
384: FUNCTION Get_Department_Code(

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419: 'p_organization_id=' || p_organization_id ||
420: '; p_department_id=' || p_department_id);
421: end if;
422:
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END;
425:
426: -- ----------------------------------------------------------------------
427: FUNCTION Get_Resource_Code(

Line 466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

462: 'p_organization_id=' || p_organization_id ||
463: '; p_resource_id=' || p_resource_id);
464: end if;
465:
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: END;
468:
469: -- ----------------------------------------------------------------------
470: FUNCTION Get_Expense_Account_Id(

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500: 'EAM_ActivityUtilities_PVT.Get_Expense_Account_Id: unexpected error.'||
501: 'p_organization_id=' || p_organization_id);
502: end if;
503:
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END;
506:
507: -- ----------------------------------------------------------------------
508: PROCEDURE Get_Asset_From_WO(

Line 542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

538: 'EAM_ActivityUtilities_PVT.Get_Asset_From_WO: unexpected error.'||
539: 'p_wip_entity_id=' || p_wip_entity_id);
540: end if;
541:
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END;
544:
545: -- ----------------------------------------------------------------------
546: FUNCTION Get_Asset_Owning_Dept_Id(

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

582: '; p_inventory_item_id=' || p_inventory_item_id ||
583: '; p_serial_number=' || p_serial_number);
584: end if;
585:
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END;
588:
589: -- ----------------------------------------------------------------------
590: FUNCTION Get_WO_Res_Scheduled_Units(

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

631: '; p_operation_seq_num=' || p_operation_seq_num ||
632: '; p_resource_seq_num=' || p_resource_seq_num);
633: end if;
634:
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END;
637:
638: -- ----------------------------------------------------------------------
639: FUNCTION Get_Master_Org_Id(

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: 'EAM_ActivityUtilities_PVT.Get_Master_Org_Id: unexpected error.'||
670: 'p_organization_id=' || p_organization_id);
671: end if;
672:
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END;
675:
676: -- ----------------------------------------------------------------------
677: PROCEDURE Validate_Asset_Number(

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: FROM csi_item_instances
714: WHERE instance_number = p_instance_number;
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_INSTANCE_NUMBER');
719: -- FND_MESSAGE.SET_ENCODED('Instance number is invalid.');
720: l_x_error_mesg := FND_MESSAGE.GET;
721:

Line 738: IF l_x_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

734: NULL,
735: l_x_org_return_status,
736: l_x_org_id,
737: l_x_org_code);
738: IF l_x_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
741: l_x_error_mesg := FND_MESSAGE.GET;
742:

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

735: l_x_org_return_status,
736: l_x_org_id,
737: l_x_org_code);
738: IF l_x_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
741: l_x_error_mesg := FND_MESSAGE.GET;
742:
743: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: WHERE inventory_item_id = p_inventory_item_id
764: AND serial_number = p_serial_number;
765: EXCEPTION
766: WHEN OTHERS THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ASSET_GRP_NUM');
769: -- FND_MESSAGE.SET_ENCODED('Asset Group, Number invalid.');
770: l_x_error_mesg := FND_MESSAGE.GET;
771:

Line 799: x_return_status := FND_API.G_RET_STS_ERROR;

795: if l_count >= 1 then
796: x_maintenance_object_id := p_inventory_item_id;
797: x_maintenance_object_type := 2;
798: ELSE
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_INV_ITEM_ID');
801: -- FND_MESSAGE.SET_ENCODED('Invalid Inventory Item Id.');
802: l_x_error_mesg := FND_MESSAGE.GET;
803:

Line 821: x_return_status := FND_API.G_RET_STS_SUCCESS;

817: END IF;
818:
819:
820: -- If reach here, means data valid
821: x_return_status := FND_API.G_RET_STS_SUCCESS;
822: END;
823:
824: -- ----------------------------------------------------------------------
825: FUNCTION Get_Cost_Activity(

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: 'EAM_ActivityUtilities_PVT.Get_Cost_Activity: unexpected error.' ||
855: 'p_activity_id=' || p_activity_id);
856: end if;
857:
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END;
860:
861: -- ----------------------------------------------------------------------
862: FUNCTION Get_Locator(

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: '; p_locator_id=' || p_locator_id);
900:
901: end if;
902:
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:
906: -- ----------------------------------------------------------------------
907: PROCEDURE Get_Op_Coordinates(

Line 947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

943: '; p_wip_entity_id=' || p_wip_entity_id ||
944: '; p_operation_seq_num=' || p_operation_seq_num);
945: end if;
946:
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
948: END;
949:
950: -- ----------------------------------------------------------------------
951: FUNCTION Get_Bom_Sequence_Id(

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

990: '; p_assembly_item_id=' || p_assembly_item_id ||
991: '; p_alternate_bom_designator=' || p_alternate_bom_designator);
992: end if;
993:
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END;
996:
997: -- ----------------------------------------------------------------------
998: FUNCTION Get_Rtg_Sequence_Id(

Line 1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1037: '; p_assembly_item_id=' || p_assembly_item_id ||
1038: '; p_alternate_rtg_designator=' || p_alternate_rtg_designator);
1039: end if;
1040:
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END;
1043:
1044: -- ----------------------------------------------------------------------
1045: FUNCTION Get_Gen_Object_Id(

Line 1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1081: '; p_inventory_item_id=' || p_inventory_item_id ||
1082: '; p_serial_number=' || p_serial_number);
1083: end if;
1084:
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1086: END;
1087:
1088: -- ----------------------------------------------------------------------
1089: PROCEDURE Get_Item_Info_From_WO(

Line 1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1128: 'EAM_ActivityUtilities_PVT.Get_Item_Info_From_WO: unexpected error.'||
1129: 'p_wip_entity_id=' || p_wip_entity_id);
1130: end if;
1131:
1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1133: END;
1134: -- ----------------------------------------------------------------------
1135: FUNCTION Default_Owning_Department_Id(
1136: p_activity_association_id IN NUMBER,

Line 1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1205: 'p_instance_id=' || p_instance_id ||
1206: 'p_organization_id=' || p_organization_id);
1207: end if;
1208:
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END;
1211:
1212: -- ----------------------------------------------------------------------
1213: FUNCTION Is_Item_Serialized(

Line 1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1257: 'p_organization_id=' || p_organization_id ||
1258: 'p_maint_id=' || p_maint_id);
1259: end if;
1260:
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END;
1263:
1264: -- ----------------------------------------------------------------------
1265: -- For logging

Line 1357: l_message_text := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);

1353: THEN
1354: -- Push message onto fnd message stack
1355: FND_MSG_PUB.ADD;
1356: -- Get translated message
1357: l_message_text := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
1358: ELSE
1359: -- Message not pushed onto fnd message stack
1360: l_message_text := FND_MESSAGE.GET;
1361: END IF;