[Home] [Help]
148: where lookup_type = 'MTL_EAM_ASSET_TYPE'
149: and lookup_code=3;
150:
151: -- validate the inventory item
152: l_validate:= eam_common_utilities_pvt.validate_inventory_item_id
153: (p_current_organization_id,
154: p_inventory_item_id,
155: l_eam_item_type);
156: if (not l_validate) then
158: RAISE FND_API.G_EXC_ERROR;
159: end if;
160:
161: -- validate that the serial number does NOT already exist
162: l_validate:=not (eam_common_utilities_pvt.validate_serial_number
163: (p_current_organization_id,
164: p_inventory_item_id,
165: p_serial_number,
166: l_eam_item_type));
884: END;
885:
886: -- validate the boolean flags
887: if (p_maintainable_flag is not null and p_maintainable_flag <> fnd_api.g_miss_char) then
888: l_validate:=eam_common_utilities_pvt.validate_boolean_flag
889: (p_maintainable_flag);
890: if (not l_validate) then
891: x_reason_failed:='EAM_MAINTAINABLE_FLAG_INVALID';
892: fnd_message.set_name('EAM',x_reason_failed);
929:
930: if (p_network_asset_flag is not null and p_network_asset_flag <> fnd_api.g_miss_char) then
931:
932: if (l_eam_item_type = 1) then
933: l_validate:=eam_common_utilities_pvt.validate_boolean_flag
934: (p_network_asset_flag);
935: if ( (not l_validate) or (p_network_asset_flag <> l_old_network_asset_flag) ) then
936: x_reason_failed:='EAM_NETWORK_ASSET_INVALID';
937: fnd_message.set_name('EAM',x_reason_failed);
948:
949:
950: --validate linear id
951: if (p_EAM_LINEAR_ID is not null and p_EAM_LINEAR_ID <> fnd_api.g_miss_num) then
952: l_validate := eam_common_utilities_pvt.validate_linear_id
953: (p_EAM_LINEAR_ID);
954:
955: if (not l_validate) then
956: x_reason_failed:='EAM_INVALID_EAM_LINEAR_ID';
967: x_reason_failed:='EAM_DEPT_ID_NULL';
968: return false;
969: */
970: if (p_owning_department_id is not null and p_owning_department_id <> fnd_api.g_miss_num) then
971: l_validate:=eam_common_utilities_pvt.validate_department_id
972: (p_owning_department_id,
973: p_current_organization_id);
974: if (not l_validate) then
975: x_reason_failed:='EAM_DEPT_ID_INVALID';
980: end if;
981:
982: -- validate wip_accounting_class_code
983: if (p_wip_accounting_class_code is not null and p_wip_accounting_class_code <> fnd_api.g_miss_char) then
984: l_validate:=eam_common_utilities_pvt.validate_wip_acct_class_code
985: (p_current_organization_id,
986: p_wip_accounting_class_code);
987: if (not l_validate) then
988: x_reason_failed:='EAM_WIP_ACCT_CLASS_INVALID';
993: end if;
994:
995: -- validate criticality code
996: if (p_asset_criticality_code is not null and p_asset_criticality_code <> fnd_api.g_miss_char) then
997: l_validate:=eam_common_utilities_pvt.validate_mfg_lookup_code
998: ('MTL_EAM_ASSET_CRITICALITY',
999: p_asset_criticality_code);
1000: if (not l_validate) then
1001: x_reason_failed:='EAM_ASSET_CRITICALITY_INVALID';
1006: end if;
1007:
1008: -- validate location_id
1009: if (p_eam_location_id is not null and p_eam_location_id <> fnd_api.g_miss_num) then
1010: l_validate:=eam_common_utilities_pvt.validate_eam_location_id_asset
1011: (p_current_organization_id,
1012: p_eam_location_id);
1013: if (not l_validate) then
1014: x_reason_failed:='EAM_LOCATION_ID_INVALID';
1206: end if;
1207: -- End of validation for prod org, equipment item, and eqp serial number
1208:
1209: if (p_checkin_status is not null and p_checkin_status <> fnd_api.g_miss_num) then
1210: l_validate:=eam_common_utilities_pvt.validate_mfg_lookup_code
1211: ('EAM_ASSET_OPERATION_TXN_TYPE',
1212: p_checkin_status);
1213: if ( (not l_validate) or (p_network_asset_flag = 'Y') ) then
1214: x_reason_failed:='EAM_CHECKIN_STATUS_INVALID';